Can Multiple Data Filtration rules be used on a table?

[tahnalos]

I am attempting to implement several different rules for Data Filtration.

1) I have two rules that handle the category of the records in question.  I have already set up role based rules to handle each category so that's fine.

2) I am trying to put in an exclusion where if the person doesn't have the roles in question, if they are marked as an assignee to the ticket, they should also get access.

Already I tried to put in a data filtration based on the category which is set up so only the person can see it, and also set up a second data filtration entry based on the category and the assignee, but not set up with a role filter.  While the first filtration rule works, the second one does not.

Does anyone have an approach to handle this particular scenario?

[James Chun · Accepted solution]

Okay, I have done something similar in my PDI and was able to get it working.

Below is my configuration, try comparing it to yours and see if you can get it working.

Data filtration record (note the condition appears as if it's caller is system admin but in fact, it's caller_id!=javascript:gs.getUserID()^category=network:

Subject criteria record:

Role filter criteria record:

[James Chun]

Actually, you can simplify it. Note that I am not using a subject condition but using a security attribute condition instead.

[tahnalos]

But does this handle the situation where the person is not part of Role A?

[James Chun]

Yup, see the below:

Admin user with no Role A -  can only see Incidents where category = network and caller is me

User with Role A - can see all Incidents where category = network

[tahnalos]

I realize that I had completely set up the background script wrong, so I managed to finally fix this issue.

Thanks, you have been a great help.