Order on two columns does not have the expected result
When i do the order by with shift en mousebutton, select first hoofgroep and the stap, then i works fine? Do anybody why the layout show a wrong "order by"
Rob van den Hondel
It looks like you found a bug! As community we cannot help you fix this, only try some work-arounds. However, I would advice to submit a ticket for support (https://support.mendix.com).
I think it has to do with the reference set you are retrieving it from: does it work when you retrieve directly from database/XPath?
Johan Flikweert - old account
As a workaround you could use as datasource a MF. Within the MF you retrieve your data and create a sorted list which you can return.
not sure if this is a bug. some pointers;
- Version_Steps is a *-* association, not sure about the Steps_Headgroup association. But *-* associations are a pain in the ass by definition.
- You are sorting (which is a Xpath enrichment => db query) over an association, while the reference set selector is in memory. This might conflict. and thus shouldn't be done
These a just thoughts. Use them to test/investigate further; if you have more answers let us (the community) know.
🚴René van Hofwegen🎓