Check the Number of active assignee

[vvaibhav]

Hi team,

Can we check the number (count) of active assignee in the 'if else' block of workflow ? I have a condition in which if

1. user raise a request for approver and there is no other active approver present in the user group - approval should route to approver's manager

2. Approver request for self and no other active approver is present in user group - approval should route to approver's manager

Please help me out achieving this.

Regards,

Vikash

[NM]

@vvaibhav try this 

(com.saviynt.ecm.identitywarehouse.domain.Usergroup_users.executeQuery("select count(*) from Usergroup_users ugu, Users u where ugu.user_groupkey = 'groupkey' AND ugu.userkey=u.usekey AND u.status=1")?.size() != 0)

And then else condition would be approval to manager ..

[vvaibhav]

Hi @NM 

Thank you for looking into it.

Unfortunately, It did not work. I am not able to submit the request itself. Could you please suggest if there is any other work around. Also, please take a look to my query once more as i have edited it and removed one of the condition.

Regards,

Vikash