Question
Tata Consultancy Services
IN
Last activity: 4 May 2016 6:39 EDT
Fetching records count from an activity
I have an assignment, which needs to capture the records count using by calling the report definition in an activity.
1.I have defined the report definition using the pxCallRetrieveReportData
2.I have defined the fields in the parameters tab,say for example count1,count2 so on
3.I have defined in property set stating the parameter variable
ex:param.count1 to property value from clipboard
When im trying to capture the record count using the log message,
ex:"***Rec count: " + param.count1
im getting an empty value.
I have an assignment, which needs to capture the records count using by calling the report definition in an activity.
1.I have defined the report definition using the pxCallRetrieveReportData
2.I have defined the fields in the parameters tab,say for example count1,count2 so on
3.I have defined in property set stating the parameter variable
ex:param.count1 to property value from clipboard
When im trying to capture the record count using the log message,
ex:"***Rec count: " + param.count1
im getting an empty value.
How to achieve this. Please someone help me on this.
Thanks,
Message was edited by: Lochan | Moved from Mesh help
Virtusa Consulting Services Pvt. Ltd.
IN
Hi Gayathri,
Can you put some screen shots of the rule where you are trying to do the log-message and property-set (expand the steps) and the count returned by the report on the clipboard
Thanks & regards,
Goutham
Tata Consultancy Services
IN
Hi Gautham,
Thank you for the reply.I am mentioning the step by step process in the activity.Please let me know if a change is required
1.Log-Message--> to track the messages in PEGA log
2.Call Rule-Obj-Report-Definition.pxRetrieveReportData
pyReportName - RD name
pyReportClass - Applies to class of RD
pyPageName - Page name
3.loop----->pagename.pxResultsCount
4.property set--->Param.count1=.pySummaryCount(1)
count 1 defined in the parameters tab
5.Log message---->"***Result 1: " + Param.count1
I ran the activity and could see no values in the log
But when i run the report definition i can see clear classification of the count of records
Thanks
I understand that you want to execute the report definition from an activity and to print the result count. To achieve this please try below steps,
1) Call Rule-Obj-Report-Definition.pxRetrieveReportData Activity from the activity step by passing below parameters,
pyReportName - RD name
pyReportClass - Applies to class of RD
pyPageName - page to populate the results, say MyResultSet
2) Do Property-Set for the local variable with MyResultSet.pxResultCount property
Tata Consultancy Services
IN
Hi Sathish,
Thank you for the reply.I am mentioning the step by step process in the activity.Please let me know if a change is required
1.Log-Message--> to track the messages in PEGA log
2.Call Rule-Obj-Report-Definition.pxRetrieveReportData
pyReportName - RD name
pyReportClass - Applies to class of RD
pyPageName - Page name
3.loop----->pagename.pxResultsCount
4.property set--->Param.count1=.pySummaryCount(1)
count 1 defined in the parameters tab
5.Log message---->"***Result 1: " + Param.count1
I ran the activity and could see no values in the log
But when i run the report definition i can see clear classification of the count of records
Thanks
There is no need for the loop in Step 3 actually. After step 2, you will get the value for pxResultCount