Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/30/2024 02:57 AM
Hi Team,
We have created one access request approval workflow and we want to exclude primary and secondary certifier owner from the list. If ent is having primary or secondary certifier request should not go to them in workflow. How can we add this condition.
Regards,
Supriya
10/02/2024 11:25 PM - edited 10/14/2024 09:35 AM
Use custom assignment block with custom query
select userkey from entitlement_owners where entitlement_valuekey=${REQUESTACCESSOBJ.id} and rank not in (26,27) and ${ACCESSTYPE}=2
union
select userkey from role_owners where rolekey=${REQUESTACCESSOBJ.id} and rank not in (26,27) and and ${ACCESSTYPE}=3
Added Validation of Access Type Refer https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...
ROLE | 1 |
ENTITLEMENT | 2 |
ACCOUNT | 3 |
ORGANIZATION | 4 |
USER | 5 |
RULE | 6 |
ROLE BASED ENTITLEMENT | 7 |
Emergency ID | 8 |
Emergency ACCESS | 9 |
Transport | 10 |
WF Varaibles https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter12-Workflows/Workflow-Compon...
**EDITED**
10/03/2024 01:29 PM
Hi @supriya15 ,
Use the below custom assignment to exclude primary certifier (rank=26) and secondary certifier (rank=27).
select eo.userkey from entitlement_owners eo where eo.entitlement_valuekey=${REQUESTACCESSOBJ.id} and eo.rank not in (26,27)
If this helps your question, please consider selecting Accept As Solution and hit Kudos
10/15/2024 09:30 PM
The request is not going to entitlement owners in sequential order ex. it should go to rank1 owner first then rank2, but it is not happening.
Regards,
Supriya
10/15/2024 09:48 PM
Share your workflow wiring and workflow type ?
10/17/2024 12:55 AM
10/17/2024 06:50 AM
Please provide UI view of workflow and attached worklfow does not have Query added