Expression in If-else block

[Joon]

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%'"

[SumathiSomala]

@Joon try

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

[Joon]

Thanks @SumathiSomala ,

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

[amit_krishnajit]

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. 

[rushikeshvartak]

It should be java condition

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

[pmahalle]

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.