How to order a dropdown element?

[jmdc]

Hello,

Could you tell me if there is a way to order a dropdown element choosing what column i want in the form view?

Thank you in advance.

 

[jmdc]

I have found the solution:
In data-where:
where id > 0 order by id ASC

 

[cheesegrits]

Just FYI, your question was about "the dropdown element", but you seem to be talking about a join element. They are different animals.

But yes, that's how to order a join element.

-- hugh