Issue checking owner status and availablity from workflow

[Aniketk]

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

[Aniketk]

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

[rushikeshvartak]

You need to use custom assignment block with custom query to assign approval to active owner

[Aniketk]

Okay, in above workflow I need to add custom assignment instead for access approval block.

and can you help me with the query

[rushikeshvartak]

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} 

[Aniketk]

@rushikeshvartak , can you help me with the document from where I can learn about transfer ownership user update rule

[rushikeshvartak]

I don't this is related to original ask , if its not raise new thread