Complex order

Hello,

I got a mm_table with people. There is an attribute for their department (Management, Supply chain ...).

Can I list all of them but sorting them this way :
1. The boss (management but can be selected by his name or ID)
2. other management people by name asc
3. all other by name asc.

Not sure how to do it wit sql and no more with MM filter.

Thanks for help.

For an individual sorting according to several criteria you can work with the filter rule "Own SQL". All other sorting in the list settings must then remain switched off. Please note that this sorting filter rule must be the first one in the filter.

see https://metamodels.readthedocs.io/de...-attribut-fest

Quote:

---

Originally Posted by zonky

For an individual sorting according to several criteria you can work with the filter rule "Own SQL". All other sorting in the list settings must then remain switched off. Please note that this sorting filter rule must be the first one in the filter.

see https://metamodels.readthedocs.io/de...-attribut-fest

---

Thanks Zonky,
That's what I did but I had a problem to combine it with a frontend filter. But I solved it. That works. MM rocks !!