Hi, everybody:
Could you tell me how to order by field in a form, and the field is not a index field.
Thanks a lot!

I think that you talk about display forms. In your case , you can use query.extension() command. Search threads about query.extension and query commands.

Good luck !

Hi,

Could you please clarify whether its a form field or a table field?

Regards

Hi, I want order by a table field, but this field is not in any index.

Hi,

If u have the source code then using the query.extension can restrict the records using like.
But I doubt if u can do order by.

First part I have tried & works fine.

The easiest way is adding an index starting with the field you want to sort on and add other fields of primary key to this index to make it unique. Than you can activate this index for the session where you want to have the data sorted on this field.

One other option is using the standard filter functionality of Baan sessions. On the second form the ordering sequence can be defined.
As far as I know there is no way to automatically call this functionality from within a script.

Youp

thanks ，everybody！