Posted: 9 Mar 2018 1:36 EST Last activity: 10 Apr 2019 8:02 EDT
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***
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.
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
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)
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.