always one selected sort order

[genovese]

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

[dplr-rn · Accepted solution]

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

[genovese]

Tested and it works with dual 🙂

dual(company,SortOrderID) as Company

Thank you very much!

[dplr-rn]

glad to help

[anderseriksson]

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.