Question
BANK OF NEWYORK MELLON
US
Last activity: 18 Jul 2016 6:02 EDT
Work status filter not working as expected
According to the requirement pxassignedusername field needs to be there in the report. When trying to apply the filter conditions "pending-rework" and "pending-preapproval".No data is being displayed in the report. When removed pxassignedusername , the data is being displayed. I have tried adding pxassignedoperatorID field to the reports, but there is no data being displayed in the report. I have found that in the association PxWorklistAssignments (final rule) when the type is changed from "only include matching rows " to " include rows in the work class" the report is working as expected. Since, its a final rule it can't be modified. Is there any other solution to sort out this problem ?
***Updated by Moderator: Vidyaranjan. Removed user added #helpme tag. Apologies for confusion, shouldn't have been an end-user option***
Accepted Solution
Pegasystems Inc.
IN
Would suggest you to check the DB query with and without "only include matching rows " to " include rows in the work class" to know the DB query is different. This might help in changing the report appropriately.
Pegasystems
IN
Would suggest you to check the DB query with and without "only include matching rows " to " include rows in the work class" to know the DB query is different. This might help in changing the report appropriately.
Only include matching rows should result in an INNER JOIN whereas include rows in the work class should result in an OUTER JOIN. Which report definition is this?