Export Data to Excel with Filter applied

Hi,

 I want to export the data after filtering the records in the screen, 

I have added filter in the aggregate while exporting the records and refreshed too , but still not getting the expected results.

guide me in this!


Regards,

Nandini



Hi,

At record list to excel you are using Aggregate or ListRecords/TableRecords?

Regards,

Mário



Mário Horta wrote:

Hi,

At record list to excel you are using Aggregate or ListRecords/TableRecords?

Regards,

Mário



I am using list with assigned values of aggregate.



Hi Nandini,

In your Export you can use the initial aggregate. In the export action you put a Refresh Data for your aggregate with no max records. The you can just use Record List to Excel to get the Excel.

Regards,
Lennart

Hi Nandini, 

In our application we have solved this by using not the aggregate but a structure which contains the filtered set of results. Your Record List To Excel should then use [structure name].List as the Record List.


Let us know if this helps, if not, I can provide some screenshots to visually help you out.

Gwen

Gwen Jamroziak wrote:

Hi Nandini, 

In our application we have solved this by using not the aggregate but a structure which contains the filtered set of results. Your Record List To Excel should then use [structure name].List as the Record List.


Let us know if this helps, if not, I can provide some screenshots to visually help you out.

Gwen

Hi Gwen,

Please provide the snaps so that I can understand in better way

Thank you