Question
JPMorgan Chase & Co.
IN
Last activity: 24 Jul 2020 9:22 EDT
Report Definition DateTime difference not working in Production
I have a report definition which is fetching work objects with date difference of Current Date Time and One more property invoice completion date time less than 3 months.
This works fine in DEV and Testing environments but fails to fetch work objects in Production environment.
Can anyone suggest on this ?
V7.3.1
***Edited by Moderator Kayla to update Content Type from Discussion to Question and updated Platform Capability tags***
Pegasystems Inc.
US
Enable DB Query events in tracer and trace the RD in both production and lower environment. The DB Query event will contain both the query and the prepared values. If no difference is found, then substitute the prepared values into the query and run the prepared query directly against the databases. See if the results are the same, and proceed from there.
Some things to check for specifically:
Does the function alias use another OOTB database function that is defined in the lower environment DB and not in production?
Is the invoice completion date time column populated and exposed properly in production?