Organization Owner Approval for Modification Requests

[Sanjeevini]

Hello,

We have a workflow set up for creating and modifying organizations. The requirement is that when the organization owner submits a modification request, the approval step for the organization owner should be skipped.

Could someone help with the workflow condition to check if the requestor is the organization owner?

Thank you.

[rushikeshvartak]

You can write SQL query in if -else block

[Sanjeevini]

We are trying with the below query. However, getting an error.

(com.saviynt.ecm.identitywarehouse.domain.Organization_owners.executeQuery(
"select userkey from Organization_owners ow where ow.customerkey = ${organization.id} and ow.userkey = ${requestedby?.id}")?.size() != 0)

org.jbpm.api.JbpmException: script evaluation error: javax.script.ScriptException: groovy.lang.MissingPropertyException: No such property: com for class: Script3 at org.jbpm.pvm.internal.script.ScriptManager.evaluate(ScriptManager.java:127) at org.jbpm.pvm.internal.script.ScriptManager.evaluate(ScriptManager.java:115) at org.jbpm.pvm.internal.script.ScriptManager.evaluateExpression(ScriptManager.java:87) at org.jbpm.pvm.internal.el.ScriptExpression.evaluateInScope(ScriptExpression.java:48) at org.jbpm.pvm.internal.el.Expression.evaluate(Expression.java:108)

[rushikeshvartak]

com.saviynt.ecm.identitywarehouse.domain.Entitlement_values.executeQuery(" select userkey from Organization_owners ow where ow.customerkey = ${organization.id} and ow.userkey = ${requestedby?.id}")?.size() != 0)