OJS3: Get total articles counts

Describe the issue or problem
We need to get count of the total articles published in a multi-journal OJS installation.

Steps I took leading up to the issue
I followed the guidelines:

But the database was changed in version 3.

What application are you using?
OJS 3.3.0-10

Additional information


Initially we got the count through the bank through the following query:

select count(distinct(publication_id)) from publications where status = 3;

However, the general count can also be obtained by copying the website with published editions to a spreadsheet with excel and in excel performing the count of articles.

Hi @luciano,

Thanks for posting your solution! If it helps, publications.status = 3 corresponds to STATUS_PUBLISHED:

Alec Smecher
Public Knowledge Project Team

1 Like