Is there a way to show attributes of 2 different entities in one single data grid / list view?

Hi, I have a problem with how to deal with domain modeling. I attached an image of how my domain model looks like. Employees should be able to join multiple projects and a project can have multiple employees working on it. The main purpose of ProjectMember_Registration is to record the date when an employee joins the project. If the employee, later on, quit the project, his/her quit date will be recorded too. Now, In a project detail page, I want to show the information of employees that are active and inactive in the project. So I will need to show the name, start date, end date and status of the employees. I use a data grid in a project data view, but I can’t get all the information I need. The data grid will show either ProjectMember_Registration info or Employee info. Is there a way to solve this?    
2 answers

Hi Lisa,


I was able to display 2 entities on one  list/grid view by the steps below.

  1. Create a grid page and assign/select the datasource Entity property.
  2. Right-click on the column you want to add additional entity info and click ‘Add column left/right’ whichever you prefer
  3. Once a column is created, click on that new column and on the Data source properties, you can assign an attribute entity path


Let me know if that helps.



Hi Lisa,

the main entity of your data grid needs to be the ProjectMember registration. In a datagrid, you can always show attributes from associated objects, if the associated object is on the “1” side of your association. That means it will not work with *-* associations, but with 1-1 and with *-1 (as long as the main entity is on the * side).