Missing 'sort*' for FE Filter

[stefanheimes]

We need a field do select on which fields the filter values are sorted.
Now i have a list, sortetd by, i don't know what id, sorting, tstamp or what ever.
But i want that all values are sorted by field 'xxx'.

[backbone87]

In the CE and Module there is a selection for sorting field?

[stefanheimes]

I mean the "FE filter CE", not the MM list elements.

[discordier]

You mean the filter options?

[stefanheimes]

Content Element - MetaModels FE Filter.

Chose MM, filter and everything else. Now go to the FE an select a value. How u see, all values sorted by sorting maybe. But i want that the values are sorted by the shown vlaue.

[zonky2]

@stefanheimes: small workaround:

add filter rule "Own SQL" as first in your filter set with
SELECT id FROM {{table}} ORDER BY <field> change

[richardhj]

I need to sort (and maybe filter) the options that are shown in the FE filter options. Exactly the purpose of @stefanheimes.

I wonder how to implement it the best way and created a mockup:

With this functionality implement (in the filter_select), you will be able to modify the filter options that are shown in the FE (my use case: I want to sort the list and don't want to show all filter options).

In addition, we can introduce a filter_sort which is doing nothing else than SELECT … ORDER BY ZZ.

Please give feedback!

[zonky2]

sounds good for me! ... and "kill two birds with one stone" so it's possible to filter e.g. all "Veranstalter" with property xy (has Catering, work only in Germany...)

[richardhj]

Yeah! The only problem encountered to me: This will only work if the foreign table is a MetaModel (not a simple table) (because you can define a filter for MetaModels exclusively). Further feedback pls.

[zonky2]

...as alternative, we can use a input field for SELECT ... ORDER BY ZZ

[discordier]

I do not completely grasp how this solves your problem, you want to select a static filter here?
What happens to the parameters in said filter? Will they revert to default? If not, how to define the values here? Like in the MOD/CE?
What about language dependent values (We have this problem in the CE filter select already)?

Do not get me wrong, I like the attempt to ease usage and implementing such a feature. I simply do not want to open up yet another can of worms while we are yet undecided where to go fishing.