[OPS] Editorial Activity: incorrect number of Submissions Published

[alexxxmendonca]

Describe the bug In the Editorial Activity report, the number of "Submissions Published" don't match the actual number for the chosen period.

To Reproduce Steps to reproduce the behavior:

1. Go to Statistics -> Editorial Activity
2. Make sure you select a date range that represents the whole period you are trying to check
3. Check the number in "Submissions Published"
4. Check that against the number of actual preprints published and notice how the numbers don't match -- easiest way is to go to the Archives and see the total number of preprints available.

What application are you using? Open Preprint Systems 3.2.1.0

Additional information

[NateWr]

This is how that stat is calculated.

• All submissions with their first version that was published within the date range
• AND with a status of STATUS_PUBLISHED.

That suggests to me a few ways the numbers might be off:

1. If you have published submissions in which the status is not STATUS_PUBLISHED (3 in the database).
2. If you have published submissions in which the first published version (publication in the database) has a date_published value that does not fall within the date range
3. If the number 415 is actually the incorrect value. For example, if that number is counting total versions instead of submissions it might be larger than the actual number. I can see from your stats that it says there have been 516 total submissions and 265 have been declined. That sounds to me like the 415 number may be wrong and the 241 may be more accurate.

[alexxxmendonca]

While we are at it, I don't think that number of submissões (516) is correct either.

My "Archives" tab is showing 688 submissions:

[NateWr]

Have you tried to determine what the correct number is by using the next/prev pages or looking into the database?

[alexxxmendonca]

I have not looked into the database but I don't think the 415 (now 423) are counting versions.

There are 22 archive pages, with 20 preprints each. 22x19=420 + 3 from the last page = 423.

https://preprints.scielo.org/index.php/scielo/preprints/index/22 (this is the last page).

[NateWr]

Hmm, and 423 + 265 (declined) = 688. So could be one of the other issues (date range or status).

[alexxxmendonca]

Does date rage make sense being an issue? It's from January 1st, 2020. OPS wasn't even released back then...

[NateWr]

It depends on what the dates are in the database. There shouldn't be any, but it's pretty clear that data has gone wrong somewhere in the database, so you'll need to check it anyway.

[JhonathanLepidus]

Hi! We're currently working on this issue.