Query Business Rule on RITM Table

[zeeshan ahmed]

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

[Kieran Anson]

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