Question

1
Replies
25
Views
Close popover
Enrico Angkawijaya (angke)
PEGA
Innovation Principal - Technical
Pegasystems Inc.
US
angke Member since 2010 2 posts
PEGA
Posted: November 25, 2020
Last activity: December 10, 2020

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***
Pega Platform 8.5 Reporting Lead System Architect