Show property of a relationship item on the parent item's search grid

Hi,

  Here is the use case I am trying to implement - 

Item A is the parent item and Item B is the related item. Assume Item AB is the relationship item between the 2. On Item AB I have a few properties (let's say prop1, prop2 prop3) defined and I want these to be shown on Item A's search grid.

For a unique combination of an instance of Item A and Item B there will be a unique relationship item Item AB. The intent is to show the property values of Item AB on Item A's search grid which will be different for different instances of Item A. So if there are 100 Item A instances showing in the search grid, each one row should show a different prop1, prop2 and prop3 value.

Is there a simple way to do this?

Any help is appreciated.

Sunil

Parents
  • Hello,  Milestone Card

    To display the properties of a relationship item on the parent item's search grid, you can create a view or query that joins the parent item with the relationship item based on their unique identifiers. This view can then include the properties from item AB. This approach ensures that each row in the search grid for item a displays the corresponding properties from their item AB. 

Reply
  • Hello,  Milestone Card

    To display the properties of a relationship item on the parent item's search grid, you can create a view or query that joins the parent item with the relationship item based on their unique identifiers. This view can then include the properties from item AB. This approach ensures that each row in the search grid for item a displays the corresponding properties from their item AB. 

Children