Sorting list order is not working in List collector

[Eswar Namuduri]

We are trying to sort the list of values in a list collector variable. For that a new column 'Order' is created in the table and tried to put 'ORDERBY' in reference qualifier which is not working. We need to order the list based on the column order.

But checked in the product documentation I found the below.

Reference qualifiers do not support the ORDERBY condition. In reference qualifiers, you can sort the reference lookup list by using standard list controls. To specify the order of an auto-complete list for a reference field, use the ref_ac_order_by dictionary attribute.

Please suggest me how to achieve this.

[Elijah Aromola]

This only affects the auto-completion choices such as: 

You can't change the order of the list collector once you go into it (click on the magnifying glass). You can change the list once you start typing into the field.

Does this answer your question? If so, please mark this answer as helpful.

[ccajohnson]

It is unclear what you are trying to accomplish.

It sounds like you want the values of the list collector to be in some sort of order. For example, if I had a List collector that pointed to the User table to allow me to select multiple users. Once I am done with my selections (no matter what order I select them in), the list will be in alphabetical order.

[Allen Andreas]

As others have stated above, you can't change the order of appearance of the selections inside the list collector. You can modify the searching of them...as you've found in documentation, but if I choose John Doe first...then Jane Doe second...

Jane Doe will appear first then John Doe in the selection list due to alphabetical order. That is the order list collectors show their selections in.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Allen Andreas]

Hi,

I just wanted to check-in on this and see if your question was answered by my post?

If so, please mark it as Helpful/Correct so that other users can find the answer easily.

Thanks!