Hi all.
Search from the screen and download displayed data into Excel.
I am using the RecordListToExcel widget in a server action.
The problem is that the data from the second page of the pager is not displayed in Excel.
What could be the cause?
I appreciate if you could teach me.
Regards,
Zamiemon
Hi Zamiemon U,
Can you share a OML for reference to look into the issue.
Regards,Wasimkhan S
Hi @Zamiemon U ,
Its because you are using same aggregate list which has max record property so it will only fetch records which are shown on first page.
what you can do is create a server action and pass filter applied by user as input to server action and filter data using new aggregate inside server action this way you will get all the records which matches the current filter.
now pass the list you got from new aggregate to recordListToExcel, you will get the excel with all the records that matches with current filter.
Pramod.
Hi,
If you are using single aggregate for pagination and excel then it will only show current page records due to start index and max records of aggregate.
For achieving your requirement copy and paste same aggregate inside the screen and remove start index and max records variable from that aggregate and use this one for excel.
Arun
Hi Arun
I appreciate.
When I try to delete max record I get an error saying it cannot be deleted. Do you know anything?
Can you please let me know from where you are deleting max records?
I have attached the sample .oap for your reference.
Hope this helps.
Manish Jawla
Hi Zamiemon U ,
Check out here in the documentation step by step how to do it
https://success.outsystems.com/documentation/how_to_guides/data/how_to_export_entity_data_to_excel/
Hope that it helps you
Hi @Zamiemon U
1) create a data action, for excel functionality. - Only on demand
2) when click on button to download excel, pls use
3) For List, use different aggregate.
Let me know if any queries. Hope it helps.
Hi Zamineou,
Please see the attachment i will help you in your query