« 00019 · Edit Form · 00021 »

Summary: Peer Review Status: Not peer-reviewed
Type: Usage

Priority (1<5) = 3
Status: Closed

Raised by: Florian Ackermann?
Project: CORE Organic
Related to Issues?
Date opened: 2005–07–21
Assigned to hal
Hours used (estimates in brackets) = 2
Date closed: 2005–08–16

Description:
I suppose the text: “Peer Review Status: Not peer-reviewed” is not necessary in the summary page. May be it it is able to delete it.
Thanks, F Lorian? Ackermann

Implementation

• 15aug2005: The default has been disabled for now. May reimplement it later to add only default for relevant eprint types, when I figure out how to do so … Asked Eprints Tech list.
• 16aug05: Removed ‘Not Peer-reviewed’ in the database for eprint types where they are not relevant. Generated new abstracts.

SQL code

1. Setting refereed to NULL for researchprogramme organization project facility
   1. First:

SELECT *
FROM `archive`
WHERE `type LIKE ‘researchprogramme’ OR `type LIKE ‘organization’ OR `type LIKE ‘project’ OR `type LIKE ‘facility’
ORDER BY `eprintid  ASC;

SELECT *
FROM `inbox`
WHERE `type LIKE ‘researchprogramme’ OR `type LIKE ‘organization’ OR `type LIKE ‘project’ OR `type LIKE ‘facility’
ORDER BY `eprintid  ASC;

SELECT *
FROM `buffer`
WHERE `type LIKE ‘researchprogramme’ OR `type LIKE ‘organization’ OR `type LIKE ‘project’ OR `type LIKE ‘facility’
ORDER BY `eprintid  ASC;

SELECT *
FROM `deletion`
WHERE `type LIKE ‘researchprogramme’ OR `type LIKE ‘organization’ OR `type LIKE ‘project’ OR `type LIKE ‘facility’
ORDER BY `eprintid  ASC;

1. Then:

UPDATE `inbox SET refereed=NULL WHERE `type LIKE ‘researchprogramme’ OR `type LIKE ‘organization’ OR `type LIKE ‘project’ OR `type LIKE ‘facility’

UPDATE `archive SET refereed=NULL WHERE `type LIKE ‘researchprogramme’ OR `type LIKE ‘organization’ OR `type LIKE ‘project’ OR `type LIKE ‘facility’

UPDATE `buffer SET refereed=NULL WHERE `type LIKE ‘researchprogramme’ OR `type LIKE ‘organization’ OR `type LIKE ‘project’ OR `type LIKE ‘facility’