How to Export Excel for field not in the Domain model

0
I want to export the data for ReportInfo, and also including Email in the report. how can I do it ? ( I don’t want to add email field in the ReportInfo again as UserInfo has one.) For Example :  Domain Modle1: ReportInfo(GID, Number, XX, XX, XX) Domain Modle2: UserInfo (GID, Name, Email)  this two model has no association, but can get Email through GID in User. Thanks. 
asked
2 answers
0

Hi, 

The best way to achieve this is to create a new entity with the required fields and instead of using the default export to excel use this Excel export module. Few configurations and a microflow to get the fields from two databases then create objects for the entity you have created for the XLS report. 

Also, this documentation will give you a better understanding of this. 

Hope this helps!

answered
0

Hi Juan Wang,

You can create a flat table entity containing all necessary fileds you want. Do you retrieval based on id from another table and pussh all the data to the newly created no persistabel entity and show that as a grid. 

answered