Element - databasejoin - order of data in dropdown

[alastairwalker]

I am using Fabrik 3.1 RC2.

I am using the element plug-in databasejoin in order to access an associate table's values, and to present these values in an ordered list.

The plugin (databasejoin) does not seem to provide a way to alter the order of the default order of associate table values.

Implicitly, the order seems to be determined by the Label values (i.e. they are sorted alphabetically).

I want to preserve the order implicit in the underlying index (i.e. id) values.

Can this be done? Or changed?

I cannot find a 'Group by' feature which would solve this problem neatly.

Any comments?

Alastair Walker

 

[rackem]

In the "Data" section of the dbjoin element options there is a setting called "Joins where and/or
order by statement (SQL)"

So you would just need to put in something like

ORDER BY id ASC

 

[alastairwalker]

Thank you very much! That is very helpful!

Kind regards,

Alastair