We need to use user groups in if-else block for parallel workflow

[Sharma]

Hi Team,

We are looking for a way to put user group in a if-else block of a workflow. When a user that is present in that user group, requests access, it should auto reject.

Is it possible in Saviynt as of now. If yes, can you provide a sample query that can be used here.

Thanks

[Kaustubh]

In if-else block please try:

(com.saviynt.ecm.identitywarehouse.domain.usergroup_users.executeQuery("select ug.USERKEY from usergroup_users ug where ug.USER_GROUPKEY = <group key> AND (ug.USERKEY= '${requestedby?.id}' OR ug.USERKEY='${user.id}')")?.size() != 0)

change <group key> with actual group.

I have not tried above query, but I have worked on similar use case.

[Amit_Malik]

@Sharma , here is what we have been using :

(com.saviynt.ecm.identitywarehouse.domain.Usergroup_users.executeQuery("select ugu.id from Usergroup_users ugu where ugu.user_groupkey = 40 AND ugu.userkey= '${user.id}'")?.size() != 0)