We are on Apex 5.1.4.00.08. We may soon be going to 19.1.
We have an application that is used by multiple separate entities (companies). They log in to the application using a domain indicator which separates the data they see in many tables by that domain id.
Question 1: We utilize several interactive report and grids in the application, but we are forced to only allow the end user the ability to save PRIVATE reports in the reports and grids, because the PUBLIC reports will be seen by the other domains that use the application. Is there any way we can add some delimiter to tie PUBLIC reports to a specific domain, so that only members of that domain or group can access those public reports?
Question 2: The different domains may save their PRIVATE reports in the production instance of the application. However, we are also, in the meantime, doing further development on the application in a different ‘development’ instance of APEX. In practice, we would export the current production application and import it into the development APEX instance, so further development can be done. This development may take a good period of time.We would then export the modified application from development and import it over the production application so production now has the new enhancements. Basically we periodically upgrade the application. This would overwrite the PRIVATE reports and only include those reports that existed at the time we exported the production application. The users would lose any private reports they created during the development period. Is there any way to export the CURRENT private reports in one application and import them into another? And if question 1 has an answer, could that be done with PUBLIC reports as well?
Any help would be appreciated.