Filter users by review interests

Version of OJS: 3.2.1.1

At the request of my manager, I need to filter reviewer users by the review interests field. Is there this option in the current versions?

Regards,
Leandro Libutti

You can use the search feature to find reviewers by their reviewer interests. The search field will return users who match the search phrase in their name, affiliation, biography and reviewer interests.

I did not know that the search engine took into account the review interests.
Something that would be good to add in the future is that it allows to show the reviewers of the journal and their review interests. Currently for this I perform the following query in the MySQL database:
(SELECT ‘Username’,‘Email’,‘Interest’)
UNION
(SELECT t2.username, t2.email, t2.interes FROM
(SELECT us2.username, us2.email , t.setting_value as interes FROM
(SELECT us.* FROM (SELECT u.*, uug.user_group_id
FROM users as u INNER JOIN user_user_groups as uug ON u.user_id = uug.user_id) us WHERE
us.user_group_id=33) us2 INNER JOIN (SELECT uc.user_id, cv.setting_value FROM
user_interests uc INNER JOIN controlled_vocab_entry_settings cv ON uc.controlled_vocab_entry_id = cv.controlled_vocab_entry_id) t ON
us2.user_id = t.user_id) t2
INTO OUTFILE ‘reviewers_interests.csv’
FIELDS ENCLOSED BY ‘"’ TERMINATED BY ‘;’ ESCAPED BY ‘"’
LINES TERMINATED BY ‘\r\n’);

Regards,
Leandro Libutti

the user_group_id 33 corresponds to the reviewers of the specific journal

That’s a nice SQL query to have! You can also use the REST API, which has an endpoint to get reviewers. (The reviewer selection list fetches reviewers from the API.)

I did not know the REST API, it is very useful!
Thanks a lot!

Regards,
Leandro Libutti

1 Like