To have a filtered list from a retrieve (by association), we need to use the retrieve action and a list operation action.
This will create a list with all the objects retrieved from that association (which can be many) and then a second list with the objects that we want to work with.
I wonder if it would be possible to add the filter by expression to the retrieve (by association) action.
Great idea: this can optimize performance very well!
As a retrieve over association always performs a database retrieve, the filter can directly be applied as XPath constraint, retrieving less objects from database.
A retrieve over database is not always desired, as some changed objects may exist in cache.
I would love to have a retrieve by association with XPath filter available!
An option to directly sort as well would be awesome!
[I think a filter by expression is hard to implement on DB-level]
OK, I formulated a similar idea : https://community.mendix.com/link/space/studio-pro/ideas/4812