Retrieving date when submission was sent to review stage (stageId 3)

Software Support
1

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 notes, email_log and 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:

activity_log_review_stage_date
activity_log_review_stage_date771×78 9.57 KB

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,

Max

2

hi @Max358

The date you probably want is the date_decided field in the edit_decisions table. The decision column contains a number that gets mapped to a particular EDITOR_DECISION_* constant. These constants are defined in lib/pkp/classes/workflow/PKPEditorDecisionActionsManager.inc.php and classes/workflow/EditorDecisionActionsManager.inc.php.

Best
Jason

1 Like
3

Hi Jason,

thanks a lot this info helps a great deal!

Kind regards,

Max

1 Like