Mass editing on Peer reviewed field?

[Joachim]

Hi,

I've got more than 200 resources from a journal I thought of being peer reviewed, but now I found out it isn't. Is there a way to change all those resources in one swoop? I know a little bit SQL, but I'm afraid to do something irreparable wrong …

Regards
Joachim

[Mark Grimshaw]

Hi Joachim,

(Moved this to the Help forum.)

Try this:
UPDATE WKX_resource_misc SET resourcemiscPeerReviewed = 'N' WHERE resourcemiscCollection = 3

where '3' is the collectionId from the collection table of the journal you want.

(Backup the database in case anything goes wrong.)

Mark

[Mark Grimshaw]

(and this assumes your config.php has 'WKX_' as the database table prefix.)

[Joachim]

Thanks Mark, it worked!

[Mark Grimshaw]

Great.

Mark