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)

[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