Cascadingdropdown list order

[johnonorvic]

I am using a cascadingdropdown element configured as a checkbox list. The list items appear in alphabetical order. I want to control the order, but can find no way of doing so. The list used for the cascadingdropdown's data is based on a view, so I can easily change the record order of that, but the list remains alphabetical. Is there any way of controlling the order or of just preventing it being sorted?

 

[troester]

I don't have a good test case.

Try in Advanced/ Where query
1=1 Order by xyz

 

[johnonorvic]

That's a good idea - I vaguely remember seeing somthing a bit like it once before. It certainly works for me. Thanks very much.

 

[vipzeus]

And how ordering by number - 1,2,3,4 etc instead of 1,10,11,12 ?

 

[troester]

ORDER BY cast(`xyz` AS int) ASC

or make your element to be integer or add your values with preceding 00

 

[vipzeus]

Thank you Troester.
I use in advance tab

1=1 ORDER BY {thistable}.mese_rif cast(`xyz` AS int) ASC

and i have 1064 error.
What is the right syntax to do this?

 

[troester]

1=1 ORDER BY cast({thistable}.mese_rif AS int) ASC