OJS- - Change Submitter

Hi @asmecher,

I was looking at https://pkp.sfu.ca/support/forum/viewtopic.php?t=1116 and looking at your query solution.
I was able to determine the user ID. No Problem,
Determine the article ID not so much as the table has changed and no longer has a “title” field.

What queries do I use for OJS- to do the same thing?


Hi @EdwardDavid,

To find the ID of an article by title:

SELECT article_id FROM article_settings WHERE setting_name = 'title' AND setting_value = 'article-title-here'; 

Alec Smecher
Public Knowledge Project Team