Query Business Rule on RITM Table

zeeshan ahmed
Tera Contributor

Hello Experts,

 

I am writing query BR on RITM Table , idea is to show RITM's only to users if they are part of Assignment group or Assigned to.

below is the sample query i used which is working fine.

 

current.addEncodedQuery('assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744^ORassigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe')
 
we have catalog tasks which are assigned to different groups/users , i want those users also to see the RITM's.
How to achieve this.
 
I tried using RLquery but only RLquery is working , first part of the query is not working , please see the sample query below.
current.addEncodedQuery('assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744^ORassigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe^NQ^RLQUERYsc_task.request_item,>=1^assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORassignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744^ENDRLQUERY');
 
also tried with below query by adding current.getEncodedQuery() at the end but still its not working.
current.addEncodedQuery('assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744^ORassigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe^NQ^RLQUERYsc_task.request_item,>=1^assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORassignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744^ENDRLQUERY^current.getEncodedQuery()');
with this query the result is RITM only visible which has tasks assigned to their groups or to them. But the result i need all RITM's which are assigned to user/group and RITM's with Tasks assigned to user/group
 
is there any other syntax to use RLQUERY as OR condition along with Encodedquery.
thanks in advance
 
 
1 REPLY 1

Kieran Anson
Kilo Patron

Perhaps a Deny Unless ACL is a better solution as it's aware of "current" and evaluated on a per-record basis