Sorting listbox based on another field

[#1]

Hi,

in my example you see left a listbox and on the right there is a tablebox. In this tablebox I have the sorting order for ID based in the obj! How can I do this for the listbox ID?

Thank you

[Clever_Anjos]

Not so sure about which requirement you have. What do you want to do?

[#3]

The ID Listbox should have the same sort like the table. Sorting für ID based on Obj...

[marcus_sommer]

It is the same sorting.

[Clever_Anjos]

Do you want to do it automatically? If the user changes the sort order of the table, resort the listbox?

[#6]

In the listbox is...

ID: 1, 2, 3, 4, 5

In the table is...

ID: 1, 3, 2, 4, 5

I want the sorting from the table, which based on Obj in the listbox as well.

[jeroen_wagner]

You can do the sorting in script.

temp:

LOAD * INLINE [

    ID, Obj, Amount

    1, A, 10

    2, B, 10

    3, A, 10

    4, B, 10

    5, B, 10

];

table:

NoConcatenate LOAD  *

Resident temp Order by Obj asc;

Drop Table temp;

[marcus_sommer]

You need only to change the order of columns within the sorting-tab from the tablebox.

[nagaiank · Accepted solution]

Try changing start order to

match(Obj,'A','B')

instead of Only(Obj)