Report Definition is not fetching Results, When if you do not give Filter condition Like pxobjclass NotEqualTo A-B-c-d
Hi Team,
I have created one Report Definition in A-B-C-D class ,when in filter condition i given pxobjclass 'Is NotEqual' A-B-C-D then it is fetching results.
When i removed that filter condition it is not fetching any results.
Could you please tell me why it is happening.
Thanks i advamced
Ravi
***Edited by Moderator Marissa to update Product***
Accepted Solution
Updated: 24 Sep 2021 14:41 EDT
moj.gov.sa
GB
Can you please check if the report on the descendant class is checked or not?
By default, Pega includes pxobjclass as the current class on the SQL query as "PC0"."pxobjclass" LIKE ?
This option is useful to include specific classes from the workpool or report created on the Framework layer. If Report on descendant class instances is selected, you can choose to include only the implementation class or all descendant classes (all framework and implementation classes).
The filter condition on pxobjclass changed to "PC0"."pxobjclass" IN (? , ? , ? , ? , ? , ? , ? , ? ), where ? depends upon the number of descendant classes. You can select a specific subset of descendant classes to include or exclude by adding a filter condition on .pxObjClass.
