Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Enrico Angkawijaya (angke)
PEGA
Innovation Principal - Technical
Pegasystems Inc.
US
angke Member since 2010 2 posts
PEGA
Posted: Nov 25, 2020
Last activity: Dec 10, 2020
Posted: 25 Nov 2020 21:33 EST
Last activity: 10 Dec 2020 12:25 EST
Closed

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***
To see attachments, please log in.
Pega Platform 8.5
Reporting
Lead System Architect

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice