Listing submission IDs for all submissions belonging to a specific journal using SQL query

Software Support
1

Hi,
How can I list submission IDs for all submissions belonging to a specific journal using SQL query as it is shown via GUI(Journalxx → Submission [My Queue | Unassigned | All Active | Archives]? I can’t find the relationship between submission_id and journal_id in the tables. Any help?

Am using OJS 3.4.05.
Thanks in advance.
Obi

2

Hi @obi,

The context_id column in submissions identifies an entry in journals by journal_id. Have a look at the schema self-documentation:

https://pkp.sfu.ca/ojs/schemaspy/stable-3_4_0/tables/submissions.html

Regards,
Alec Smecher
Public Knowledge Project Team

4

Thanks a lot Alec. It solved my problem. The schemaspy is also great.
Regards
Obi

1 Like