Revise reviewer ratings?

In OJS, is there a simple way to review, update or delete reviewer ratings? I have inherited some reviewers and would like to start afresh using a non-rating system.

Hi @GlenC,

Would you like to simply hide the reviewer ratings? If you disable the option in Setup, they will no longer be presented or recorded.

Regards,
Alec Smecher
Public Knowledge Project Team

Thanks for reply, but no I want to delete ratings.

Hi @GlenC,

To delete reviewer ratings, run this in your database:

UPDATE review_assignments SET quality = NULL;

Make sure you back up your database before doing this just in case.

Regards,
Alec Smecher
Public Knowledge Project Team

err, thanks, but can you give me step by step instructions for that please?

best,

Hi @GlenC,

This will depend on your server, since you’re working with tools outside of OJS. You’ll probably have access to a tool called phpMyAdmin; you can use that both to perform a database backup and to execute an SQL query.

Regards,
Alec Smecher
Public Knowledge Project Team