Portal Task report in Tempo and export that report in excel format

Question

I want to display a portal Task report in Tempo and export that report in excel format. I am using the a!queryProcessAnalytics() for excecuting the report. The output I get is in PortalReportDataSubset format. This has two columns one is the user and the other is groups. Now for display of this user in SAIL Grid is handled through apply, it is working fine. For Exporting the report : we are doing a type conversion from PortalReportDataSubset to ExportableDataSubset. This also works fine, but we want to apply the function of converting user id to username and groupids to group names in the columns. I was trying to use function todatasubset(), that conversion has not worked as expected. Does anyone know how to overcome this issue? Exporting username in Excel in Tempo Report. Any help is highly appreciated. 
 OriginalPostID-225597 
 OriginalPostID-225597

kumaraveln · Accepted Answer

Hi #rishi .. I am trying to export my task report using the same plugin and I am constantly getting the 500 error. I have used this plugin earlier in other tempo reports and it was working fine over there. Only difference here is my source is getPortalReportDataSubset due to which I am getting the result in PortalReportDataSubset format. So I am looping through this result, converting it into a simple CDT structure, then doing a todatasubset() and finally passing the resultant object into the plugin function. I have printed and checked the resultant data in UI. Everything is coming fine. Even the rule when tested individually (by hard coding values in JSON string) gives the correct result (PFA). But when called from parent rule I am getting this issue. I compared my other code and everything looks perfect. If you could share a screenshot of your code here it would be of great help.