Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/11/2024 09:40 AM
Hello All,
i need a help to find out the numeric employeeid here it is the condition and converted into advance sql query.
And( u.status == true, IsRegexMatch(u.Employee ID, "^\d+$") )
Solved! Go to Solution.
07/11/2024 10:34 AM
Query is used where ?
07/11/2024 10:35 AM
technical rules
07/11/2024 12:36 PM
u.statuskey=1 AND u.EmployeeID REGEXP '^[0-9]+$';
07/11/2024 12:40 PM
thank you but unfortunately not working . Is regexp supported in advance sql query
07/11/2024 12:42 PM
it's showing invalid condition
07/11/2024 12:53 PM
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', ''))
07/11/2024 01:00 PM
thank you so much rushikesh
07/11/2024 01:26 PM
✅Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question and hit kudos👍