Show most recent value with selectFirstByDefault in Single Select Filter

[sbaur]

Hey everyone,

I have a single select filter that operates on a column with timestamps (formatted as strings) and I would like to have the most recent date selected by default.

Using selectFirstByDefault results in exactly the opposite: the oldest value (which happens to be on top of the source table) gets selected by default. I tried to sort the source table via sql with order by desc in the source options of the element definition as well as the data options of the datasource defintion, but the sorting seems to get overidden somewhere. When checking with dialog editor sorting works as intended.

Is there a way to apply sorting or an option that controls how selectFirstByDefault behaves exactly?

thanks in advance!

[katharina.selig]

Maybe this questions helps:

Specifying which way the filter elements are ordered

Hello OD Community, I have a filter element which displays the different version numbers of an optimizer which we display in the App Page. It would be useful to have the latest version (i. e. the highest number in the column) as the first value. I have specified in the related datasource that it should be sorted in descending order and the SQL Editor shows it in the correct order. However in the filter element the values are sorted in ascending order. Is there a way to specify this in the filt…

[sbaur]

Exactly what I needed, thanks Katharina!