Hi @ramon,
Thanks for flagging this. To help look into this further, could you answer a few questions about your specific case?
Was this a journal that was recently upgraded and did these issues only start after the upgrade was complete?
How many submissions have you noticed are missing from the report? You specifically mention submission ID 5238, but are there others?
If this limited to this or a few submissions, you could look at the entries in the database to see if there may be some reason those submissions are missing and not others. Within the review reports plugin, one of the primary database queries is below. You could try exploring that and see why it would not be appearing. It’s possible something could have gotten lost or changed over the course of upgrades.
Here is the query:
SELECT r.stage_id AS stage_id,
r.review_id as review_id,
r.round AS round,
COALESCE(asl.setting_value, aspl.setting_value) AS submission,
a.submission_id AS submission_id,
u.user_id AS reviewer_id,
u.username AS reviewer,
COALESCE(ugl.setting_value, ugpl.setting_value) AS user_given,
CASE WHEN ugl.setting_value <> '' THEN ufl.setting_value ELSE ufpl.setting_value END AS user_family,
u.email AS email,
u.country AS country,
us.setting_value AS orcid,
COALESCE(uasl.setting_value, uas.setting_value) AS affiliation,
r.date_assigned AS date_assigned,
r.date_notified AS date_notified,
r.date_confirmed AS date_confirmed,
r.date_completed AS date_completed,
r.date_acknowledged AS date_acknowledged,
r.date_reminded AS date_reminded,
r.date_due AS date_due,
r.date_response_due AS date_response_due,
(r.declined=1) AS declined,
(r.unconsidered=1) AS unconsidered,
r.recommendation AS recommendation
FROM review_assignments r
LEFT JOIN submissions a ON r.submission_id = a.submission_id
LEFT JOIN publications p ON a.current_publication_id = p.publication_id
LEFT JOIN publication_settings asl ON (p.publication_id = asl.publication_id AND asl.locale = ? AND asl.setting_name = ?)
LEFT JOIN publication_settings aspl ON (p.publication_id = aspl.publication_id AND aspl.locale = a.locale AND aspl.setting_name = ?)
LEFT JOIN users u ON (u.user_id = r.reviewer_id)
LEFT JOIN user_settings ugl ON (u.user_id = ugl.user_id AND ugl.setting_name = ? AND ugl.locale = ?)
LEFT JOIN user_settings ugpl ON (u.user_id = ugpl.user_id AND ugpl.setting_name = ? AND ugpl.locale = ?)
LEFT JOIN user_settings ufl ON (u.user_id = ufl.user_id AND ufl.setting_name = ? AND ufl.locale = ?)
LEFT JOIN user_settings ufpl ON (u.user_id = ufpl.user_id AND ufpl.setting_name = ? AND ufpl.locale = ?)
LEFT JOIN user_settings uas ON (u.user_id = uas.user_id AND uas.setting_name = ? AND uas.locale = a.locale)
LEFT JOIN user_settings uasl ON (u.user_id = uasl.user_id AND uasl.setting_name = ? AND uasl.locale = ?)
LEFT JOIN user_settings us ON (u.user_id = us.user_id AND us.setting_name = ?)
WHERE a.context_id = ?
ORDER BY submission
where the params are:
["en_US","title","title","givenName","en_US","givenName","en_US","familyName","en_US","familyName","en_US","affiliation","affiliation","en_US","orcid",1]
In this case en_US is the locale and 1 is the journal ID.
In addition to this query, you could also try looking at the reviewer/review associations for submission ID 5238 in the database.
Best,
Erik
PKP Team
