Group multiple table permissions on same table with AND operation

(0) Share

Report

Posted on by jinx02

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

Categories:

General

All responses (1)

Answers (0)

Fubar 7,960 Super User 2025 Season 1 on at

Like (0)

Report

Re: Group multiple table permissions on same table with AND operation

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 )