Dear Alec,
I wish to know how to list the reviewer (pull from the reviewer database) not manually input like Batosai did. I am using 2.4.8. What template file I should edit?
I found this topic List of reviewers for OJS 2.x
CREATE ALGORITHM = UNDEFINED VIEW redi_reviewers
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
WHERE
(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)
ORDER BY ra.date_completed DESC
Where to insert that snippet and in what file?
Best wishes,
Romy