Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/20/2024 03:30 AM - edited 09/20/2024 03:32 AM
Hello,
I have created a workflow with condition:
(entitlement.getAllowner().size() == 0) or (com.saviynt.ecm.identitywarehouse.domain.Entitlement_values.executeQuery("Select u.statuskey as eoStatus from Users u,Entitlement_owners eo,Entitlement_values ev where u.id=eo.userkey.id AND eo.entitlement_valuekey.id=ev.id AND ev.id='${entitlement.id}'").get(0).toString().contains('0'))
This is checking if owner is available or owner is inactive.
Most of the test cases are successful, however if there is active owners available and 1 inactive owner it is assinging the request to fallaback grouo owner.
Kindly suggest
Case 1 | Owner available as RANK1 | Approval goes to rank1 owner | Correct |
Case 2 | Owner available as RANK2 | Approval goes to Rank2 | Correct |
Case 3 | No owner available | Approval goes to Fallback group | Correct |
Case 4 | Owner is Inactive | Approval goes to Fallback group | Correct |
Case 5 | One owner is inactive, Active RANK1 and Rank 2 Available | Approval goes to Fallback group | Should be assigned to active owner |
09/20/2024 03:31 AM
Case 1 | Owner available as RANK1 | Approval goes to rank1 owner | Correct |
Case 2 | Owner available as RANK2 | Approval goes to Rank2 | Correct |
Case 3 | No owner available | Approval goes to Fallback group | Correct |
Case 4 | Owner is Inactive | Approval goes to Fallback group | Correct |
Case 5 | One owner is inactive, Active RANK1 and Rank 2 Available | Approval goes to Fallback group | Should be assigned to active owner |
09/20/2024 03:34 AM
You need to use custom assignment block with custom query to assign approval to active owner
09/20/2024 03:39 AM
Okay, in above workflow I need to add custom assignment instead for access approval block.
and can you help me with the query
09/20/2024 03:47 AM
select distinct eo.userkey
from entitlement_owners eo INNER JOIN request_access ra ON ra.ACCESSKEY=eo.entitlement_valuekey INNER JOIN users u ON u.userkey=eo.userkey and u.statuskey=1
where ra.REQUESTKEY=${ARSREQUEST.id}
09/20/2024 06:32 AM
@rushikeshvartak , can you help me with the document from where I can learn about transfer ownership user update rule
09/20/2024 07:54 AM
I don't this is related to original ask , if its not raise new thread