We need to fetch 5 columns first name ,last name email,address,and the last column should be like if there is any case assigned to worklist then worklist name should be fetched or if the case is assigned to a workbasket then only workbasket name should be fetched so for this we can have joins but how only in single column we will handle this logic?
You can use two joins in the Report Definition for the Work class - one for the Workbasket and another for the Worklist. The join type should be “Include all rows in this class.”
In the Selected Columns, you can use the OOTB “Case When Input Is Null” function alias. Configure it so that if WB.pxAssignedOperatorID is null, it returns WL.pxAssignedOperatorID; otherwise, it returns WB.pxAssignedOperatorID.
