Can I use non-persistent objects with the Excel Exporter?
90% of our domain model consists of non-persistent objects, including the ones that were required in the Excel export. The console (error trace), however, was telling me that the error was due to not being persistent objects. After creating a proof-of-concept I was actually able to export my data into an Excel file. The documentation only speaks of 'virtual objects' and some more research on the web refers virtual objects to 'in transaction created objects' and not non persistent. It would seem non-persistent objects are accepted, but I haven't been able to thus far. So basically my question is: can I use non-persistent objects with the Excel exporter?
Excel Exporter generates an OQL query to retrieve the data needed when building a spreadsheet. OQL can't retrieve non-persistent objects since these objects are not stored in the database.