Describe the issue or problem
Steps I took leading up to the issue
Hi,
Our installation will be hosting a couple of journals.
We’ll want the best way to get a quick count (total for all journals) of the following, to display on our homepage to visitors.
total journals hosted.
total articles (submitted/published).
etc. (we’d probably figure out the rest, if we can get the first two).
I checked the Stats & Reports page, JournalStatisticsDAO.inc.php, and StatisticsHandler.inc.php. It seems, I think (I might be 100% wrong on this one), that what’s being imple…
But the database was changed in version 3.
What application are you using?
Additional information
Hi,
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:
* @class PKPSubmission
* @ingroup submission
* @see PKPSubmissionDAO
*
* @brief The Submission class implements the abstract data model of a
* scholarly submission.
*/
// Submission status constants
define('STATUS_QUEUED', 1);
define('STATUS_PUBLISHED', 3);
define('STATUS_DECLINED', 4);
define('STATUS_SCHEDULED', 5);
// License settings (internal use only)
define ('PERMISSIONS_FIELD_LICENSE_URL', 1);
define ('PERMISSIONS_FIELD_COPYRIGHT_HOLDER', 2);
define ('PERMISSIONS_FIELD_COPYRIGHT_YEAR', 3);
abstract class PKPSubmission extends DataObject {
/**
Regards,
1 Like