Reporting issue
Hi,
Can any one help on the below scenario
We have a requirement where the Manager can see the count of workItems which are completed by reporting users under that Manager in a date range.
we can able to get the data if we have single user, using pyResolvedUserID="Name". but how do i get all the users completed items who are under Manager.
I tried with the below options:
created a activity to get the reporting users under that Manager(pyReportTo="ManagerName"). tried to add all the names with separator .Final property should be like "ReportingUser1","RU2",....... so that we can give the whole property in report definition using contains condtion(pyResolvedUserID contains ). but it is not working. I am unable to add " to string.
we can add normal char like "@" , "#" etc. but how to add double quotes to string (" " ")
Thanks
Accepted Solution
Virtusa
US
Thanks for for your inputs.
We have too many operators and it may added new future also. So we need to create those many Workgroups for that manager.
I tired with joining two tables like Work table and Operator table with pyUserIdentifier(Op Table) with pyResolvedUserID(Work table). and then search by pyReportTO=Manger name.
It's working as expected.
Truviq Systems Private Limited
IN
Hi Jyothsna,
You can use pxStringCSVFromPageList function in the activity by passing the pagelist to it.
Ex: Use Call-Function in one of the steps of activity and pass the parameters as below.
Function: @(Pega-Gadgets:pxDataManipulate).pxStringCSVFromPageList(ReportingUsersList,UserName)
Return Value: Store the return value in the desired property.
This will give you the output in the required form of quotes.
Hope this helps.
Thanks,
Srikanth.
Pegasystems Inc.
IN
Hello,
You can create a work group for a manager and his team members and then create a report that returns the resolved cases under a particualr work group. That should help you.
I have created a similar usecase at my end. Please review the attached document for screenshots of my usecase.
It may help you further.
Thanks,
Gisela
Accepted Solution
Virtusa
US
Thanks for for your inputs.
We have too many operators and it may added new future also. So we need to create those many Workgroups for that manager.
I tired with joining two tables like Work table and Operator table with pyUserIdentifier(Op Table) with pyResolvedUserID(Work table). and then search by pyReportTO=Manger name.
It's working as expected.