I am on OJS-2.4.7.1.
I am trying to get a list of reviewers registered with a journal that have filled nothing in “reviewing interests”. I need to be able to do this through the UI.
If this currently is not possible. Will a user be able to get this type of information in OJS-3?
Thanks,
Edward
Hi @EdwardDavid,
That’s an awfully specific requirement, and we’re always wary of loading the interface down with too many features. This might either be something you could offer via phpMyAdmin or similar as a SQL query, or it might need to be a plugin or modification.
Regards,
Alec Smecher
Public Knowledge Project Team
Hi @asmecher,
I was pretty sure that would be the response just wanted to verify. This request was from one of our journal managers.
Thanks,
Edward
Hi @asmecher,
Is there a back end query I can run that would show users reviewers and their reviewing interests?
Thanks,
Edward
Hi @EdwardDavid,
The joins on this thread from the old forum should be useful:
https://pkp.sfu.ca/support/forum/viewtopic.php?t=9919
For example:
SELECT cves.setting_value, u.user_id
FROM controlled_vocabs cv
JOIN controlled_vocab_entries cve ON (cv.controlled_vocab_id = cve.controlled_vocab_id)
LEFT JOIN controlled_vocab_entry_settings cves ON (cve.controlled_vocab_entry_id = cves.controlled_vocab_entry_Id)
LEFT JOIN user_interests ui ON (cve.controlled_vocab_entry_id = ui.user_id)
LEFT JOIN users u ON (ui.user_id = u.user_id)
WHERE cv.symbolic = 'interest' AND u.user_id IS NULL;
Regards,
Alec Smecher
Public Knowledge Project Team