Hi,
I’m using OJS 3.0.2.0 and postgresql.
In rco/management/settings/publication review tab I can see this information:
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.