Query Business Rule issue

[Gayatri0506]

Hi Experts, 

I have a requirement to give the privilege to  the user if user has a custom role like 'abc' then they can only access the particular RITM records and if the user has 'sn_incident_read' then they can access all ritms records other then specific ITEM.

For that I have created a before query business rule but i am getting  unique Unique Key violation error.

Any suggestions on this requirement.

[Brad Bowman]

When you log 'query' while testing with three users who are not admin and have the read role, read_onedata, and neither are you getting the expected query logged?  Are you getting the violation error on both roled or all three test cases?  As each of the two roled users with the BR inactive can you manually filter the RITM list to the same = or != that category?

[Gayatri0506]

Hi Brad

I am getting the expected query from this business rule but when i am ordering the item from portal then i am getting that key violation error for read_onedata user.

[Brad Bowman · Accepted solution]

Repeating the same test scenario with this one Business Rule inactive yields the same results? Is the requested Catalog Item and resulting RITM one that a user with this role should see?  You may have to do this category restriction with a read ACL instead.