Actions
task #7713
openAtomize last scrutiny references
Status:
In Progress
Priority:
Priority14
Assignee:
Category:
data
Target version:
Start date:
Due date:
% Done:
40%
Estimated time:
1:30 h
Severity:
normal
Description
Last scrutiny references currently are all(?) flat and with protected cache. They should:
use inreferences (sometimes in-in-references)RefCategory should be Websiteyears should be extracted,also ask ERS if all "xxxx+" years are correct of if some ordinary years should be "+" yearsextract authorsextract titles
Also we need to include references to import references!
Open issues:
- authors sometimes look like: "Aedo, C., Estébanez, B. & Navarro, C.; with contributions from Raab-Straube, E. von & Parolly, G."
- Compositae references do not yet have in-references
- think about using PartOf (CatFk=2) which gives better formatting results or adapt formatting
- handle references which are currently not last scrutiny references but should (#7713#note-8)
- correct formatting for in-in-references
Related issues
Updated by Andreas Müller over 4 years ago
- Status changed from New to In Progress
Updated by Andreas Müller over 4 years ago
- Related to bug #3992: [CHECK] Use last scrutiny instead of sec reference added
Updated by Andreas Müller over 4 years ago
- Related to feature request #3990: [DISCUSS] How to implement citation suggestion to each taxon added
Updated by Andreas Müller over 4 years ago
SELECT RefId, Notes, RefYear, RefCategoryFk, RefCache, NomRefCache, PreliminaryFlag, InRefFk, Title, NomTitleAbbrev, NomAuthorTeamFk, RefAuthorString, DateString, Edition, Volume, Series, PageString, ISSN, ISBN, URL, ExportDate, PublicationTown, Publisher, ThesisFlag, RefDepositedAt, InformalRefCategory, IsPaper, RefSourceFk, IdInSource, NomStandard, Created_When, Updated_When, Created_Who, Updated_Who, IdInMCL
FROM Reference AS r
WHERE (RefId IN
(SELECT LastScrutinyFk
FROM PTaxon AS pt
WHERE (LastScrutinyFk IS NOT NULL)))
AND (RefCache NOT LIKE '%xxxx%')
OR (InRefFk = 9005392)
ORDER BY RefId
InRefFk = 9005392 nicht notwendig, nur zur Sicherheit
Updated by Andreas Müller over 4 years ago
Find last scrutiny references not in use:
SELECT * FROM Reference AS r WHERE (RefId NOT IN (SELECT LastScrutinyFk FROM PTaxon AS pt WHERE (LastScrutinyFk IS NOT NULL))) AND (RefCache LIKE '%+Med Plantbase - the information resource for Euro-Med%') ORDER BY RefId
Updated by Andreas Müller over 4 years ago
- Description updated (diff)
- % Done changed from 0 to 40
Updated by Andreas Müller almost 4 years ago
- Target version changed from Euro+Med Migration to Euro+Med post migration
we will do this after migration
Actions