Posted: 8 Jan 2020 5:02 EST Last activity: 21 Jan 2020 5:59 EST
Not able to add Workbasket Records in Worklist report definition
I have a requirement where we have to display all open tasks from worklist and workbasket along with other information like country, region, work parties info and other stuff fro different classes.
So for this we create a report in Assign and join all the classes for the other info. And to show the tasks from worklist and workbasket we simply use properties in columns like .pxRefObjectInsName, .pxTaskName, .pxObjClass etc and in filter condition pass .pxObjClass = "Assign-Worklist" , "Assign-WorkBasket",
Now when we manually run the report then all the tasks come properly i.e., from both the tables worklist and workbasket. But when we run it from Manager portal (From Report Menu under Navigation) then only Worklist tasks are visible (this might be true because on short cut an OOTB activity runs in which Assign-Worklist is hardcoded under a java step)
So what we might be try to save as the same report in Assign-Workbasket class and use this report as a sub report in the Assign- report.
Now here we expect just to include all rows which come as a output of sub report. Not want to add any new column from the subreport as column is already present there. We just want to add rows and show all the tasks.
We need to display only a single column for both worklist and workbasket. For eg there is task in worklist whose ID is stored in .pxRefObjectInsName. This property is also used in workbasket.
So we need to display tasks for both classes under this single column. If we create class in Work and join with Worklist and workbasket then to show the data of both the classes, we need to include them seperately in different columns which is not helpful in our case.