Search users whose reviewing interests is blank

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