Question
Work Items per WorkBasket
I have a certain number of WorkBaskets in my Appliction (running on Pega v6.1) and every year a certain number of WorkObjects are created, which are then routed (based on end users working on these Assignments/WorkObjects and other rules) to each of these Work Baskets, which are the further processed.
Is there a way to find out how many of the WorkObjects were routed to EACH of the individual WorkBaskets (filtered by year) after which they are picked up and assigned to an individual's worklist and then resolved.
I am trying to determine the number of assignments for each workbasket in a calendar year.
You need to join(not sql join) data from history tables (completed assignments) and assignment tables (worklist and workbasket). But still you will need a way to store the original workbasket since assigned operator changes from workbasket to operator once it is moved to worklist.
Other and better approach would be to store this reporting data separately whenever a new assignment is created. This would avoid collecting this data from various table and will also avoid unnecessary customizations.
With your basic requirements you can just write CreateDateTime and Workbasket Name and workobject ID (more.. if you need anything else).