We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Expression in If-else block

Joon
Regular Contributor II
Regular Contributor II

Hello,

Can you help me to express the condition below in If-Else block in Workflow?
"ev.customproperty3 is null or ev.customproperty3 like 'n/a' or ev.customproperty3 like '%user.customproperty14%'"

 

5 REPLIES 5

SumathiSomala
All-Star
All-Star

@Joon try

((entitlement.customproperty3==null) or (entitlement.customproperty3.contains(user.customproperty14) or (entitlement.customproperty3.contains('n/a'))

 

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Joon
Regular Contributor II
Regular Contributor II

Thanks @SumathiSomala ,

' !entitlement.customproperty3.contatin('n/a') ' will also work to express 'not like'?

The if-block in the Workflow works based on Groovy/Java. Hence, you would need to accommodate your requirements based on Groovy/Java conditions and not SQL. Hence, "like" in SQL would work similar as "contains" and for "not like" you would need to negate it using "!" in Groovy/Java. 

 

Thanks,
Amit

It should be java condition

((entitlement!=null) and (entitlement.customproperty3==null) or (entitlement.customproperty3.contains(user.customproperty14) or (entitlement.customproperty3.contains('n/a'))

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Hi @Joon ,

Select java as a language in if-else block and add below conditions:

((entitlement!=null) and (entitlement.customproperty3==null) or (entitlement.customproperty3.contains(user.customproperty14) or (entitlement.customproperty3.contains('n/a'))

Hope it helps.


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂