Sql statistics downloads

good afternoon, I hope you are well, I am working on a mini-platform to show the statistics of the ojs, I have the problem that I cannot find the data of the downloads by articles.

Could someone please give me the sql query to show the number of downloaded articles?

the data in the “metric” table does not match the data in the file downloaded from www.page.algo/management/tools#statistics

ojs version →


Hello @gmorales,

Please note, that the version of OJS that you’re using is no longer supported by PKP. I recommend that you upgrade to the newest version of OJS, as it is possible that your issue will be resolved by upgrading. However, other community members may wish to offer assistance.

Upgrading instructions are available in the PKP Administrator’s Guide.

Information about the latest version of OJS can be found on the PKP Website

Best regards,

PKP Team