Sequence in lookup Values

hi

i need help in lookup i want to show the Values in order how to do that i.e EDT

Hii ,

Can you explain me what exactly you are searching…

Hi Nani,

If I understadn your question correctly, you want to show the lookup values in a sorted order. If you are deriving the lookup using an EDT, chances are the lookup values are already sorted in descending order, example SalesId

If you have built a custom lookup using the SysLookup class, you can add a order by clause to your query and specify the sort order as well.

Example,

Query query;
QueryBuildDataSource qbds;
;
query = new Query();
qbds = query.addDataSource(tableNum(Address));
qbds.addOrderByField(fieldNum(Address, Name), SortOrder::Ascending); // Add an order by field and the sort order

Hope this helps.