Can anyone please suggest a way to download data from a list in excel, when the list entity is non persistent? We are using List View to show a report from a non persistent entity. The report is generated via a microflow. We need to download this report in excel. But as we are using list view and also group box to show nested data in the report, the default Export to Excel button is not available. We have tried using Excel Exporter module to generate the report and download the same. To achieve that we have created a fileDocument type of persistent entity and added one association with the report entity [non persistent]. Please refer attached domain model screenshot. However, when trying to generate the report as the association value is never committed, an exception is being thrown, refer below. Please guide. Microflow for generating and downloading the data.
Excel Exporter cannot access non persistent entities. See this post for a bit more detail.
Excel Exporter doesn’t work with NPE. However, another approach would be as below:
In the export Micrflow, retrieve the objects again, commit them(along with the association with FileDocument(Generalized) entity) temporarily and after export, delete the committed objects.
Would using a datagrid be an option? This widget can export np entities to excel.