How to retrieve a list with objects which have at least one association (are in use)?

0
Hi, Mendix fans,    I’m building a dashboard metric for the administrator (access to all entities) which represents a list of currently used objects from a master data entity.  I’ll try to explain it with an example:  Entity ‘Houses’ has an *->1 association to a Districts entity  Districts entity has an attribute Name, filled by import of a CSV file  Constructor firms entering Houses and assigning Districs accordigly I’m trying to retrieve a list of Disctrics which are currenty assigned/are in use or with other words filter by “has an association” How can I achieve it? Thanks for your support. 
asked
2 answers
4

See the documentation here: https://docs.mendix.com/refguide/xpath-not/
To check the objects with no reference you can do something like this:
 

 [not(Sales.Customer_Order/Sales.Order)]

And thus to retrieve all the objects that do have a reference you can use this:
 

 [Sales.Customer_Order/Sales.Order]

Regards,

Ronald

answered
0

Thanks, Ronald! 

answered