Posted: 25 Nov 2020 21:33 EST Last activity: 10 Dec 2020 12:25 EST
pyAgeByWorkQueue is not calculating correctly
I'm running pyAgeByWorkQueue report definition on Pega 8.5 and it's not calculating the Past Goal count correctly. The SQL generated by the function appears to be correct, but the database is returning "1" for CASE WHEN (("PC0"."pxgoalexecute"::TIMESTAMP IS NOT NULL) AND ("PC0"."pxdeadlineexecute"::TIMESTAMP IS NULL)) even when pxgoalexecute is NULL.
Any clue is appreciated.
***Edited by Moderator: Pooja Gadige to add product details tag***