01-12-2023 02:40 AM
So we have a different type of user (Customer/Supplier) whose email needs to be generated in a particular way, however when we include it in the email generation query under global configuration it throws the following exception:
If we remove the forward slash, the query works fine. Can we use an escape sequence?
I used Customer/\Supplier but the same error.
01-12-2023 04:09 AM
01-12-2023 05:11 AM
Still the same error.
01-12-2023 06:11 AM - edited 01-12-2023 06:12 AM
case when (users.companyname = 'ABC Limited') AND(users.customproperty3 like 'Customer%Supplier') then concat((users.customproperty28),'@abc.com')