topic Re: always one selected sort order in App Development

always one selected sort order

genovese — Sat, 16 Nov 2024 21:10:36 GMT

Hello guys,

The always one selected is a very nice feature!

Now my question: I have a client who wants to have a special sorting of his different companies in the selection bar. Is it possible to change the sort order of the field you use for "always one selected"?

How it is currently:
Alpha Company
Beta Company
Gamma Company
Zeta Company

How it is desired:
Beta Company (Sortorder ID: 1)
Zeta Company (Sortorder ID: 2)
Alpha Company (Sortorder ID: 3)
Gamma Company (Sortorder ID: 4)

Thx for every helpful comment

Best regards,

Dario

Re: always one selected sort order

dplr-rn — Tue, 26 Mar 2019 15:37:48 GMT

Havent tested it but try to define the column as a dual with string and numeric value

Re: always one selected sort order

genovese — Tue, 26 Mar 2019 15:48:03 GMT

Tested and it works with dual 🙂

dual(company,SortOrderID) as Company

Thank you very much!

Re: always one selected sort order

dplr-rn — Tue, 26 Mar 2019 15:49:17 GMT

glad to help

Re: always one selected sort order

Anders_Eriksson — Wed, 27 Mar 2019 08:43:49 GMT

You could also make sure they are loaded in the load script in the order you want and then sort by load order.
This is good if you cant use duals or change the value of fields.
Note that the load order is set the first moment a field is loaded.
Rearranging the order in a later statement in the load script by using load 'field' resident 'table' order by 'something' won't work.