12-13-2022 04:40 AM
I want to create a detective technical rule through which we can compare a user's custom attribute with function sysdate()
I have used query- '(a.statuskey=1) AND (date(sysdate()) = date(a.customproperty45))' but this query isn't working. Customproperty45 is also DATE type field.
Kindly suggest solution for this.
Solved! Go to Solution.
12-13-2022 07:16 AM
12-13-2022 07:57 AM - edited 12-13-2022 08:00 AM
We have chosen attribute type as DATE in Global config for CS45.
12-13-2022 08:09 AM
I see it is working as expected for me with below condition
(a.statuskey=1) AND (date(a.CREATEDATE)=date(sysdate()))
Can you check if you have any users with matching condition which you used?
12-13-2022 08:12 AM
From above screenshot I see that User Form field you made a date field which you mapped to CP45 of user. But does CP45 of user table is of date type?
12-13-2022 08:26 AM
yes i think you are correct I just checked the datatype of CP45 it's tinytext.
12-13-2022 08:26 AM - edited 12-13-2022 08:27 AM
12-13-2022 08:46 AM
Thank you so much Rushikesh.