Hi Everyone, I'm trying to customize the entities list displayed in the compliance workspace.
Requirement:
Logged in user should only be able to see the entities that they own or if they are added as a stakeholder.
Stakeholder is a custom glide list field created in sn_grc_profile table.
A person should see the downstream entites of the entities they own, now the downstream entites are provided as a related list in the entity table.
(If I'm the owner of entity A with downstream entity C, and added as a stakeholder for entity B. I should see A,B,C in the list nothing else).
The data source currently is sn_compliance_entities_reports since this table has certain fields are not present in the entity table that is required.
Can you please suggest a simple and straight forward approach to this problem, is there a way to list the downstream entites in the sn_compliance_entities_reports table?
