A journal came today asking for a list of reviewers. Looks like now this is important for the academics’ career.
As far as we will migrating to OJS 3.x this year I didn’t want to spend much time on it so I created a mysql view and an specific user, to let this journal download (via phpmyadmin) this list on real-time.
If you are in a similar situation you could find this snippet useful:
CREATE ALGORITHM = UNDEFINED VIEW
AS SELECT ra.review_id, u.first_name, u.middle_name, u.last_name, u.email, us.setting_value as affiliation, ra.submission_id, ra.date_completed
FROM review_assignments AS ra, users AS u, user_settings AS us
(ra.reviewer_id = u.user_id) AND
(ra.reviewer_id = us.user_id) AND
(us.setting_name LIKE “affiliation”) AND
(ra.declined = 0 AND ra.replaced = 0 AND ra.cancelled = 0)