Email Generation Query not accepting greater than (>) or less than (>) values

[AshishDas]

We are trying to write an email generation query under global configuration. However when we upload the query it throws an error as "Operation not allowed as you are entering a value that resembles or contains script code"

Attaching a part of the query. Any solutions or alternatives?

case when (users.companyname = 'ABC') AND (users.customproperty3 in('Internal Contract','External Contract'))then if(LENGTH(concat(users.firstname,substring(users.lastname,1,1),'_c'))>10,concat(users.firstname,substring(users.lastname,1,1),'1','_c@abc.com'), concat(users.firstname,substring(users.lastname,1,1),'_c@abc.com')) END

[rushikeshvartak]

Yes > is blocked even > is not working

Workaround update to database

select name,configdata from configuration where name like '%EMAILGENERATIONRULE%'

[AshishDas]

Thanks, for the update.

Have used BETWEEN to work as a workaround.

case when (users.companyname = 'Textprint Lanka (Private) Limited') AND (users.customproperty3 in('Internal Contract','External Contract'))then if(LENGTH(concat(users.firstname,substring(users.lastname,1,1),'_c'))BETWEEN 11 AND 50,concat(users.firstname,substring(users.lastname,1,1),'1','_c@textprintlanka.com'), concat(users.firstname,substring(users.lastname,1,1),'_c@textprintlanka.com')) END

[rushikeshvartak]

Please raise this issue using saviynt ticket. This is issue in v2022 also