WF query

[Dalalsaleh888]

we are trying to use the below query in the workflow to redirect the access to another group "custom assignment" when value of false. howver it is not progressing. is the quey correct?

com.saviynt.ecm.identitywarehouse.domain.roles.executeQuery("Select u.statuskey as roStatus from Users u, Role_owners ro, roles r where u.userkey = ro.userkey AND ro.rolekey = r.rolekey AND r.rolekey = '${role.rolekey}' AND ro.rank = 1 AND u.statuskey = 1"

).size() > 0

[NM]

@Dalalsaleh888 try this

com.saviynt.ecm.identitywarehouse.domain.Roles.executeQuery("Select u.statuskey from Users u, Role_owners ro, roles r where u.userkey = ro.userkey AND ro.rolekey = r.rolekey AND r.rolekey = '${role.id}' AND ro.rank = 1 AND u.statuskey = 1"

).size() > 0

[rushikeshvartak]

com.saviynt.ecm.identitywarehouse.domain.roles.executeQuery("select u.statuskey from Users u, Role_owners ro, Roles r where u.id = ro.userkey AND ro.rolekey = r.id AND r.rolekey = '${role.id}' AND ro.rank = 1 AND u.statuskey = 1").size() > 0

Please share logs and also confirm where is this workflow attached ?