Announcements
In Dynamics you can only select one relationship in the subgrid for one table. Is there a way to customize the subgrid with your own query?
I would like to show all related records based on two relations from one table.
Example: selected contact = ‘Peter’ has two relations to table "connections"
Result should show all records where column A =’ Peter’ or column B = ‘Peter’
query example:
SELECT *
FROM Contact WHERE Column A = Peter OR Column B = Peter
Hi,
I think you can do this easily with the filter criteria inside the view u are using in the subgrid.
Try using the grouped OR condition
Go to the sub-grid. Get the view name which is used.
Now update the filter criteria as per your requirement u will have to add OR condition in the view, Publish and check it after that.
maybe I didn't express myself well. Again: I would like to show two relationships in one subgrid. See the screenshot.
I would like Connections (Role From Contact) AND Connections (Role To Contact), related to contact where the subgrid is in.
Hi Dy365Fan
The field/column - Connections (Role to Contact or Role From Contact) can be added to the view you want displayed on the subgrid.
Let me know if this helps.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Syed Aqib Raza 25
Daniyal Khaleel 23 Most Valuable Professional
Ayesha Wajahat 16
