Check if requestor or requestee is single entitlement owner in workflow

[SUMAIYA_BABU]

In a workflow, I need to check if the item being requested(entitlement/role) has only a single owner and if that owner is requestor or requestee. Is this possible?

[CR]

@SUMAIYA_BABU 

We can check try below condition:

entitlement!=null and entitlement.getOwnerRank1().size() > 0

[SUMAIYA_BABU]

I need to check if the entitlement has one owner only and whether owner is either requestor or requestee

[rushikeshvartak]

Use if else with groovy block

(com.saviynt.ecm.identitywarehouse.domain.Usergroup_users.executeQuery("select u.id from Users u,Usergroup_users ug where u.id=ug.userkey AND ug.user_groupkey='${dynamicAttributesReqAccess.get(requestaccesskey).get('USERGROUPOWNERKEY')}' AND u.id='${requestedby.id}'").size()!=0)

 Above is sample

[Manu269]

Check this post : Solved: User group is not working as expected in if else b... - Saviynt Forums - 64590

[SUMAIYA_BABU]

@rushikeshvartak @Manu269 

I modified the query to below to fit out requirement

(com.saviynt.ecm.identitywarehouse.domain.entitlement_owners.executeQuery("select u.id from Users u,entitlement_owners eo where u.id=eo.userkey AND (u.id='${requestedby.id}' or u.id='${requestedFor.id}'"))

Looks like this is not working. I see the below error

stdout F de.odysseus.el.tree.TreeBuilderException: Error parsing '#{((com.saviynt.ecm.identitywarehouse.domain.entitlementslist.get(requestaccesskey)_owners.executeQuery("select u.id from Users u,entitlementslist.get(requestaccesskey) eo where u.id=eo.userkey AND u.id='${requestedby.id}'").size()!=0)) eq true }': syntax error at position 83, encountered '_owners', expected ')'

Tried with 

[rushikeshvartak]

(com.saviynt.ecm.identitywarehouse.domain.Entitlement_values.executeQuery("select u.id from Users u,entitlement_owners eo where u.id=eo.userkey AND (u.id='${requestedby.id}' or u.id='${requestedFor.id}'"))

[chitraca]

Could you do something like this:

The first condition checks if there is an entitlement in the request. The second condition checks that there are no owners on the first 3 ranks of the entitlement.  The 3rd condition checks that there is only one owner on Rank1 and the other 2 ranks are empty and the Rank1 owner is either the requestor or the requestee.

[SUMAIYA_BABU · Accepted solution]

Hi Chitra,

I was able to get it working using the below query:

entitlement ne null and entitlement.allowner.size() eq 1 and (entitlement.allowner.contains(requestedby.username) or entitlement.allowner.contains(user.username))