03/23/2023 06:49 AM
We have a issue with createdate in user profile , we thought of taking first ruletriggere date as createdate.
I am using the below query , but its not fetching that attribute(createddate);-
select u.startdate,uh.ruleruns from users u inner join usershistory uh on u.userkey=uh.userkey where uh.RULERUNS like '%PasswordEndUserRoleAssignment%';
I need to fetch the first rule triggere date ,Can you please suggest any inputs here?
Thanks & best regards,
Siva Avula
Solved! Go to Solution.
03/23/2023 07:37 AM
It looks like you are trying to fetch the first rule triggered date from the user profile. However, the query you are using is not fetching that attribute(createddate).
I would suggest you to try using the following query instead -
SELECT MIN(uh.startdate) as createddate FROM usershistory uh WHERE uh.RULERUNS LIKE ‘%PasswordEndUserRoleAssignment%’;
Let me know if this helps or if you have any other questions or concerns.
03/23/2023 10:10 PM
Hi @DixshantValecha
Thanks for the query, Its throwing error because of usershistory (uh.startdate). If i remove it and run then its working.
Could you please suggest anyother attribute or field that fetch date of rule triggered
Thanks
Siva Avula
03/24/2023 12:36 AM
Hi Siva,
You can refer below document for further information.