i need to compare two entities in domain model with association relation

i am new to mendix(8.11 version ), suppose i need to compare two entities with association for example (one ----------to ------------many relation) A is entity i have attributes aaa (department ) and bbb(department id )  and B is another entity i have attributes ccc(employes name ) and ddd(age ) eee(location) and etc…….with association relationship . i need to compare both attributes and if attributes are same should be listed in separate page and different means get in another page final agenda i need see differences for comparing both.    
1 answers

What do you mean with comparing?

Entity A and entity B contains different attributes, so comparing apples with pears.


If you what to show the reference/associated objects/entities i.e. showing the orderlines of an order then step away of your existing knowledge on how to build the SQL yourself. That Mendix handling for you. Try to think as I described it in first sentence: showing the associated list (entity B/Orderlines) of the main object (Entity A/Order).

In that case; add a dataview with context object/entity A, add a list into the dataview with contecxt objects/entity B and use the association as path on the datasource