I have used Data page to show the cases in the user work queue. In data page , I have used report definition as a source to fetch the results. But I am not able to see any results in user work queue because of the below error.
In where clause of the report definition, I have used date property in left hand side and used the Pega provided date option "Today" in the right hand side with relationship as less than.
Ex: TestDate < Today
When I try to run the RD with above condition, following exception is getting triggered and same has been captured in logs as well.
Hi @Seetharaman, your observation is correct you cannot directly compare the date property with "Today" or any other OOTB values because they work only for date time properties. Also, I don't think there's an OOTB function which does the conversion of date to date time within the RD itself.
The only possible solution that I could imagine was to have a new exposed property, let's say CurrentDate, it will be linked to a declare expression which in return will calculate current date using the @CurrentDate() function and this property can be then used on the right hand side of your RD's condition.
Posted: 5 months ago
Posted: 6 Jun 2023 23:30 EDT
Seetharaman S (Seetharaman)
Specialist - Software Engineering