How to exclude primary and sec certifier from entitlement owner list for request approval workflow

[supriya15]

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

[rushikeshvartak]

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... 

Request_access Access Type Column Mappings

Column Name Mapping Value

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**

[PremMahadikar]

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

[supriya15]

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

[rushikeshvartak]

Share your workflow wiring and workflow type ?

[supriya15]

shared. Tried with both parallel and serial.

[rushikeshvartak]

Please provide UI view of workflow and attached worklfow does not have Query added