Hi All,
Oracle 12c, Apex 20.1.0.00.13
I am wondering if anyone has done anything similar? We are looking at logging everything a user sees on several of our APEX apps. Its a legislative requirement for us to be able to say what a user has seen.
So far me and my colleagues have thought of the following
-Using apex views to store item values and re-run the report regions on the page. (Performance is already a problem for us for some of the apps - too much data too many filters). We strongly want to avoid this option.
-Using triggers? I thought this was an option but it seems triggers only accept INSERT, UPDATE and DELETE.
-Altering the APEX Packages to store the results of the request (It's been a few years since i've seen how its put together) - This is a problem for multiple reasons obviously but I dont know if we have another option.
We are not on ORDS yet but will that make any difference to what we are trying to do?
Any help please?