Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/12/2024 02:43 AM
Hi all ,
I need to find numeric employee ID in technical rule facing error ,while executing the advanced SQL query in technical rule showing invalid condition but successfully executed on SQL builder. Could you please help me on this.
select empid from users where empid REGEXP '^[0-9]+$'; -----> executed in SQL builder
07/12/2024 03:02 AM
I doubt you can use regex.
07/12/2024 03:38 AM
can ypu pls provide regex syntax
07/12/2024 07:33 AM
a.statuskey = 1 and a.employeeid is not null and a.employeeid !='' and LENGTH(a.employeeid) = LENGTH(TRIM(a.employeeid)) and LENGTH(a.employeeid) = LENGTH(REPLACE(a.employeeid, '0', '')) + LENGTH(REPLACE(a.employeeid, '1', '')) + LENGTH(REPLACE(a.employeeid, '2', '')) + LENGTH(REPLACE(a.employeeid, '3', '')) + LENGTH(REPLACE(a.employeeid, '4', '')) + LENGTH(REPLACE(a.employeeid, '5', '')) + LENGTH(REPLACE(a.employeeid, '6', '')) + LENGTH(REPLACE(a.employeeid, '7', '')) + LENGTH(REPLACE(a.employeeid, '8', '')) + LENGTH(REPLACE(a.employeeid, '9', ''))