we have an OOTB report on the Dashboard, Work-.CountResolvedByResolverTop5IC from Pega-ProCom:07-10-01, which is configured to have an interactive chart (Chart and Data) of type Pie Chart

When we click on any Pie for the first time, we are seeing the error

The query which was generated is

SELECT PYID AS "pyID" , PYLABEL AS "pyLabel" , PXCREATEDATETIME AS "pxCreateDateTime" , PYRESOLVEDTIMESTAMP AS "pyResolvedTimestamp" , PYSLAGOAL AS "pySLAGoal" , PYSLADEADLINE AS "pySLADeadline", PZINSKEY as "pxInsHandle" FROM CTO_PAYRS_DB.pc_work WHERE ( pxObjClass LIKE ? ) AND ( ( PYSTATUSWORK LIKE ? ) AND PYRESOLVEDTIMESTAMP >= ? ) AND ( (PYRESOLVEDUSERID = ? ) ) AND (( "PC0".PYSTATUSWORKIS NOT NULL ) ) ORDER BY PYID

When we open the report using “Show Data” icon and drill down, we are getting data. Now when we access the pie from the chart, we are not seeing the issue.

The query which was formed for second time after accessing “Show Data” and clicking pie chart is

SELECT "PC0".pxObjClass AS "pxObjClass", "PC0".PYID AS "pyID" , "PC0".PYLABEL AS "pyLabel" , "PC0".PXCREATEDATETIME AS "pxCreateDateTime" , "PC0".PYRESOLVEDTIMESTAMP AS "pyResolvedTimestamp" , "PC0".PYSLAGOAL AS "pySLAGoal" , PC0".PYSLADEADLINE AS "pySLADeadline", "PC0".PZINSKEY as "pxInsHandle" FROM CTO_PAYRS_DB.pc_work "PC0" WHERE ( "PC0".pxObjClass LIKE ? ) AND ( ( "PC0".PYSTATUSWORK LIKE ? ) AND "PC0".PYRESOLVEDTIMESTAMP >= ? ) AND ( ("PC0".PYRESOLVEDUSERID = ? ) ) AND (( "PC0".PYSTATUSWORK IS NOT NULL ) ) ORDER BY "PC0".PYID

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.