Hi All,

Is it possible to use multiple fields in query.extend.order().

for eg if i want sort by field1,field2,field3

Can i use query.extend.order("field1 field2 field3 desc")

Regards,

Abhijit

Yes, you can use it with multiple fields but you have to spearate the fields by comma.
E.g.
query.extend.order("field1, field2, field3 desc") <- field1 & field2 ascending order, field3 descending order
query.extend.order("field1 desc, field2 desc, field3 desc") <- all fields in descending order

Hi Abhijt,

as per my information the function query extend.order is only available from Baan V onwards, so not available for Baan IV

Regards,
Juergen

Hi Wiggum,

I used it as per your sugggestion and its working that way.

Thanks all,