Abnormal review forms count

Hi,

I’m using OJS 3.0.2.0 and postgresql.
In rco/management/settings/publication review tab I can see this information:
Screenshot%20from%202018-03-06%2014-23-55

But this journal has only 669 submissions.

select count(*) from submissions where context_id = 45;
-[ RECORD 1 ]
count | 669

And there is only 366 review forms assignments for this journal:

select count(*) from review_assignments where submission_id in (select submission_id from submissions where context_id = 45);
count | 366
(1 row)

I manually executed the follow query and got the same results:

SELECT rf.review_form_id,
rf.assoc_type,
rf.assoc_id,
rf.seq,
rf.is_active,
COUNT(rac.review_id) AS complete_count,
COUNT(rai.review_id) AS incomplete_count
FROM review_forms rf
LEFT JOIN review_assignments rac ON (
rac.review_form_id = rf.review_form_id AND
rac.date_confirmed IS NOT NULL
)
LEFT JOIN review_assignments rai ON (
rai.review_form_id = rf.review_form_id AND
rai.date_notified IS NOT NULL AND
rai.date_confirmed IS NULL
)
WHERE rf.assoc_type = 256 AND rf.assoc_id = 45
GROUP BY rf.assoc_type, rf.assoc_id, rf.review_form_id, rf.seq, rf.is_active
ORDER BY rf.seq
;
review_form_id | assoc_type | assoc_id | seq | is_active | complete_count | incomplete_count
----------------±-----------±---------±----±----------±---------------±-----------------
324 | 256 | 45 | 1 | 1 | 20 | 20
25 | 256 | 45 | 2 | 1 | 6096 | 6096
33 | 256 | 45 | 3 | 0 | 0 | 0
70 | 256 | 45 | 4 | 0 | 0 | 0
164 | 256 | 45 | 5 | 0 | 0 | 0
(5 rows)

But, if I execute the cont of “In review” for “Formulário de Avaliação - RCO” only, I get a different result:

select count(*) from review_assignments where submission_id in (select submission_id from submissions where context_id = 45)
and review_form_id = 25
AND date_confirmed IS NOT NULL;
count | 127
(1 row)

And the count of “Completed” for “Formulário de Avaliação - RCO” only:

select count(*) from review_assignments where submission_id in (select submission_id from submissions where context_id = 45)
and review_form_id = 25
AND date_notified IS NOT NULL
AND date_confirmed IS NULL;
count | 48
(1 row)

I think there’s something wrong.

Regards,
Tarcisio Pereira.

Hi @Tarcisio_Pereira,

This query has already been rewritten for OJS 3.1.1, which we hope will be released within a few weeks, so I’d suggest waiting for that version and upgrading when it’s available.

Regards,
Alec Smecher
Public Knowledge Project Team

Thank you.

Regards,
Tarcisio Pereira.