I installed OpenMRS to use as part of a demo app for a new tool I am developing. I am editing OpenMRS-Core to suit the demo requirements.
As part of the demo I would like to send Database requests to my external API. I need three pieces of information from OpenMRS
The SQL query
The username of the person making the request
The number of returned rows
Can anyone advise the best strategy for collecting this information? I’ve been looking at the ChainingInterceptor class as a place to gather this for every data request from the DB.
Does that make sense? If so, how can I get the App User information when making the request. Also, how can I find the SQL statement from hibernate on the onLoad() function.