Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Hello, everyone.We have a requirement to sort by employee number, and my query sorts it in Data Analyzer but not in Analytics Report.'ORDER BY 'Employee ID''Any suggestions on how to do this would be greatly appreciated.
SELECTU.USERNAME AS 'Employee ID',U.EMPLOYEETYPE,U.FIRSTNAME,U.LASTNAME,U.EMAIL AS 'Email ID',U.DEPARTMENTName AS 'DEPARTMENT',U.REGION,U.LOCATION AS 'HCM Location',U.Customproperty52 AS 'Country',CASE WHEN U.STATUSKEY = 0 THEN 'INACTIVE' ELSE 'ACTIV...