I have requirement where a user part of "Legal Tech Group" should see every request raised under particular category and users under "Tech queries requestor group" should only see the request where they are the requestor. This requirement is additional to what access they currently have.
I have a before query BR which I have modified as in image. The condition under if block executes perfectly fine as it is an OR condition with the existing query but in else if block if I simply add new AND condition with the OR condition then AND condition takes the precedence and it affects the existing query.
If I add entirely separate query as shown in the image then even though user able to see the correct record , clicking on the record redirects to particular record which satisfy the newly added condition.
Please guide me how to achieve this requirement
