Question

For Datagrid why sort option is not available when we choose to select data from association.

0

Hi All, I have observed that, sort based on attributes option is only available when we select data using xpath option for datagrid. Is anyone aware why such behaviour? Thanks, Vaishali

asked 2021-09-03

Vaishali Karkhile

2 answers

Mohammed Qadri · Answer 1 · 2021-09-05

hello Vaishali

I can suggest an alternative.

instead of choosing the data source type association, you can choose a microflow

then retrieving data from the database where the XPath equals the association (id) equal the object you passed

and do the sorting as you like

Martin Crawford · Answer 2 · 2021-09-03

This is normal for Mendix, I’m not sure I understand the deep technical reasons, except it has to do that association use cached data, where and path will query the database. I suspect the sorting is done in the query statement and since the association is using cached data, there is no way to sort the data.

I find this to be a strange quirk with Mendix as I’m not sure what a good use case for not having the data sorted.

As of yet, I have not found a workaround.