How to Sort ShipTo in Order history page

[former_member666604]

Hi Experts ,

I'm trying to sort lots of field in order history page and everything working fine all field except "ShipTo".

ShipTo sorting not working as per street name and street number .

Please find below query used for sorting :

private static final String SORT_ORDERS_BY_SHIP_TO = " ORDER BY {a:streetname}, {a:streetnumber}, {a:" + AddressModel.TOWN + "}, {o:" + OrderModel.CREATIONTIME + "} DESC, {o:" + OrderModel.PK + "}";

private static final String SORT_ORDERS_BY_SHIP_TO_DIR = " ORDER BY {a:streetname}, {a:streetnumber}, {a:" + AddressModel.TOWN + "}, {o:" + OrderModel.CREATIONTIME + "} ";

private static final String SORT_ORDERS_BY_SHIP_TO_PK = ", {o:" + OrderModel.PK + "}";

Could anyone help me on this by providing suggestion or solution , it will help me too much .

Regards,

Satish