Quick way to tell what stage an article is in

Hey - hopefully this is an easy one, I’m just a little crosseyed staring at the OJS tables today. Is there a quick way for me to tell if an article is in a particular stage? Primarily:

  1. Unassigned
  2. In Review
  3. In Editing
  4. Archived


Hi @ajrbyers,

Have a look at the queries in classes/submission/editor/EditorSubmissionDAO.inc.php, in particular:

  • getEditorSubmissionsUnassigned
  • getEditorSubmissionsInReview
  • getEditorSubmissionsInEditing
  • getEditorSubmissionsArchives

These all fall back on the same _getUnfilteredEditorSubmissions, adding SQL snippets for the relevant queues as function parameters.

Alec Smecher
Public Knowledge Project Team