Saturday, February 24, 2018

To Display Worklist and Workbasket in same Report Definition

Displaying Worklist and Workbaset in the Same grid with joining the work table:

In Pega PRPC Report definitions are used to get the results from Database table.
if we need to get fetch results from two tables with equii join we will get the results. From Prpc V7 onwards we can get the results based on Left Outer and Right Outer Joins.

In our example to see how to use left outer join, Assign worklist and Assign workbasket are stored in two different database tables. And work is stored in another table.

Normal scenarios will be like displaying the results from work list or work basket in a separate grid. In our requirement, we need to display worklist and workbasket in the same report or in the same grid.

we will see how to implement it:

A report definition needs to be created in the Work class and in the Report tab in the joining condition we need to provide Both Assign-Worklist and Assign-WorkBasket with conditions (.pxRefObjectKey == .pzInsKey )

In the Data Access Tab, we need to add both the classes in the join condition with Join Type as "Left Outer Join" as "include all rows in the joined class" with Condition pzInskey == .pxRejObjectKey.




On Executing we can see the results in the same report definition.



Note: Please let me know if any updation is needed.

No comments:

Post a Comment