Click HERE to see how Saviynt Intelligence is transforming the industry. |
11/08/2023 07:12 AM
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%'"
11/08/2023 08:52 AM
@Joon try
((entitlement.customproperty3==null) or (entitlement.customproperty3.contains(user.customproperty14) or (entitlement.customproperty3.contains('n/a'))
11/09/2023 05:13 AM
Thanks @SumathiSomala ,
' !entitlement.customproperty3.contatin('n/a') ' will also work to express 'not like'?
11/12/2023 11:09 PM
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.
12/05/2023 07:17 PM
It should be java condition
((entitlement!=null) and (entitlement.customproperty3==null) or (entitlement.customproperty3.contains(user.customproperty14) or (entitlement.customproperty3.contains('n/a'))
12/05/2023 08:31 PM
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.