You’re offline. This is a read only version of the page.
Announcements
Hi Everyone,
I have a requirement where I have to filter a custom table's data with table permissions based on two other custom tables.
Let's say I have to filter a table called Pets based on the relationship with another table Cats and a different table Dogs. The requirement is that the user should only see a record in the Pets if it has a relationship to a record in both the Cats and Dogs.
However if I create two parent permissions, one for filtering Pets by Cats and another for filtering Pets by Dogs, then I see the records in Pets which either has a Cat or a Dog and not the records filtered by both Cats and Dogs.
Is there any way I can implement the above requirement only using table permissions ? Please let me know if more details are needed.
Thanks in advance for the help
No, Table Permissions will always act as an OR.
But, you can create a View on Pets that has 2 Related Table entries (at the same level as each other) a Related Cats and a Related Dogs (the fetchxml that it creates will be act as an AND and would only show Pets when there was a Cat and a Dog record. (similar can be done using Liquid fetchxml )
Share
Report
All responses (
Answers (
8,338
