Custom order in listbox issue

[Anonymous]

Hello,

I'm trying to custom order for a field "Country" .

I did a mapping with the field "Country" and " Country Order"  like below:

Country  Country Order   

USA                 1

Canada            2 

Brazil                3

After loading, i use sort by expression in the listbox:

But the problem is : when i select a value in the listbox, the value selected goes to the end of the list. (i had some similar problem with the value selected goes to the top of the list ), as result, impossible to sort by expression.

I unchecked the box "State", but it does not work.

Any tips for this?

Thanks in advance!

[vishsaggi]

Try these settings in your Sort tab of Listbox.

[dinuwanbr]

Hi,

PFA

Rgds,

Tharindu

[its_anandrjs]

Hope you are looking for this

In sort properties of list object try

=Only({1} [Country Order])

[Anonymous]

Thanks a lot guys!

[vishsaggi]

YOu did not find the answer what you looking for?

[Colin-Albert]

Create the country field as a dual value with the text and numeric sort order.

The list box will display the text in numeric order without the need to change the sort sequence.

How to use- Dual()