How to use escape sequence in Email Generation

[AashishD]

Hi,

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:

Query : 

case when (users.companyname = 'ABC Limited') AND(users.customproperty3 ='Customer/Supplier') then concat((users.customproperty28),'@abc.com')

END #

Error : Operation not allowed as you are entering a value that resembles or contains script code

 

If we remove the forward slash, the query works fine. Can we use an escape sequence?

I used Customer/\Supplier but the same error.

Any suggestions?

[rushikeshvartak]

Try below 

////

[AashishD]

Still the same error.

[rushikeshvartak]

case when (users.companyname = 'ABC Limited') AND(users.customproperty3 like 'Customer%Supplier') then concat((users.customproperty28),'@abc.com')