How to get filtered data from client side in export to excel?
I'm using a report definition as a source in Data Page and displaying it on the screen, on filtering the columns at the client end I'm getting the filtered data on the screen. I need to get the filtered data exported via excel.
I'm using the Call MSOGenerateExcelFile to get the data but I need to know at which page the filtered data be so that I can pass it to MSOGenerateExcelFile and get only filtered data exported.
***Edited by moderator, Maryrita: moved to Product Support from Applications***
Swedbank AB
SE
Hello Shiva,
You can go to edit mode and add additional filters so that when executed, it gives the filtered results as desired. This data can then be exported.
Sincerely,
Pawan
EvonSys
US
Hello,
I think the filtered data in clipboard might not include all the relevant records if there is pagination or progressive loading enabled.
Filters and sorting parameters applied in UI are available in pyReportDefinition.pyUI page in clipboard. You can open the report definition using an activity and set pyUI page (which contains UI filters) to opened report definition page. Then call exporting activity (pzRDExportWrapper)
pzRDExportWrapper activity clears UI filters. So you need to save the activity with another name and skip clearing filters and sorting.
Cheers,
Tharinda
Accenture India PVT Ltd
IN
I have a similiar requirement.
Can you please let me know how how to open the report defintion in activity which is shown is displayed in grid to the user.
Accenture India PVT Ltd
IN
I am using already using pxRetrievereportdata activity. When i apply filter on the UI list, those filters are not applied on the excel content.Excel shows all the records ignoring all temp filters applied by user on UI.Pls suggest how to get the temp filters
EvonSys
US
pyUI page inside report definition page has the UI filters. You can copy this to a temp page. Then when calling RDExportWrapper copy that to the report definition page. Create a wrapper to call RDExportWrapper and copy from there.
pzRDExportWrapper activity > Save as with a new name > comment 2nd step (Java step which is removing any UI filters)
Evoke Technologies Private Limited
IN
Hi Tharinda,
Can you please elaborate what you mean by copy the pyUI page to the report definition page? I commented the java step but the export was still the un-filtered list.
Thanks,
Charan
Pegasystems Inc.
IN
Hi,
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write Post button here. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.