Hi All,
I have a tempo report with multiple filters and an export to excel functionality. The export to excel reads from DB and creates key-value pairs to export data. Currently filters are applied to the report data but same filters are not applied to the data while export to excel and the complete data from the db view is being exported. How can i export only the filtered data from the report to the excel as well?
TIA!!
Discussion posts and replies are publicly visible
How are you exporting data to excel? Are you using the record list or are you using the a!exportDataStoreEntityToExcel() smart service?
If you are using the Export Data Store Entity to Excel smart service, in the inputs tab use the filter, provide the filters using the a!queryLogicalExpression() function to provide multiple filters. To do so you need to pass the filters criteria to model.