Describe the issue or problem
Hello everybody! I am working on a script to support our Section Editors. For this script, I need the Information of when (datetime) a submission was sent to the review stage. This information can be found under the Activity logs of a submission, in the History tab. I am trying to retrieve the data directly from the SQL database, but have not managed to find the table where it is stored. I am aware that the activity log is formed from the tables
event_log, but have not found anything useful there so far.
Below is an example screenshot of the relevant info in the activity log history for one of our submissions:
Does anybody have any hintson where I could retrieve the time of when a submission was sent to review stage?
What application are you using?
For example, OJS 3.3.0-14
Thanks for your help and kind regards,