List Box sorting

[marco_puccetti]

Hello, i have sorted a list box, with a dual function, but i have noticed that the sorting is working only before the selection, after having selected the field, the sorting is lost.

How can i solve this?

Thanks

Marco

[marcus_sommer]

You need to disable sorting to state, too.

- Marcus

[sunny_talwar]

Is this a front end dual function that you are using? If yes then you might want to add {1} to the dual function:

Dual(FirstExpression with {1}, SecondExpression with {1})

[#4]

what are the settings for your sort order

I can duplicate your issue when I ahve state as decending and numeric and ascending

when I do not use the Ste option, the sorting remains the same as before selction

[stigchel]

Don't know where the dual function comes in (sorting is done on numbers), but in the sort expression use a function that takes set analysis to exclude the selection in this field. e.g.

Only({1} Month)

Or if the field is numeric (or dual) by itself, uncheck the sort by expression and just check sort on numeric value

[agni_gold]

Hi Friend ,

When you are creating your month field , use

Dual(Month,1)  AS Month

And in listbox , just sort by number .

It will solve your problem .

if still problem exists then please attach your sample application.

Thanks ,

[marco_puccetti]

If i uncheck the sorting by expression the dual function in the expression field is disabled.

Marco

[sunny_talwar]

What is your sort expression right now?

[agni_gold]

no please make this field at your backend script , it will work fine

[marco_puccetti]

The expression is this:

=dual([Mese di Decorrenza],[Mese di Decorrenza Num])

Where have i to insert the {1}? I get syntax error!!

Marco