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?
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.
Thanks for posting your solution! If it helps,
publications.status = 3 corresponds to
Public Knowledge Project Team