feature request #7799
AM: Parse authorteams
Status:
Resolved
Priority:
Highest
Assignee:
Category:
cdmadapter
Target version:
Start date:
09/29/2018
Due date:
% Done:
90%
Estimated time:
3.00 h
Severity:
normal
Description
many of them are single persons and also the resulting persons/teams could be parsed probably
Related issues
Associated revisions
ref #7799 handle protected titlecache for teamOrPerson.getFullTitle
ref #7799 handle initials for teamOrPerson.getFullTitle
ref #7799 implement author parsing for AuthorTeam and Reference.RefAuthorString
ref #7799 and others reinstall null check
ref #7799 improve performance of authorteam loading
ref #7799 compute author caches in deduplicationHelper
ref #7799 deduplicate and parse authorteams
History
#1 Updated by Andreas Müller over 2 years ago
- Tags set to euro+med
#3 Updated by Andreas Müller over 2 years ago
- Related to feature request #7800: Parse preliminary RefDetails added
#4 Updated by Andreas Müller over 2 years ago
- Related to feature request #7801: AM: Deduplicate references added
#6 Updated by Andreas Müller over 2 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 30
#7 Updated by Andreas Müller over 2 years ago
Useful scripts
DECLARE @authorId as int;
Set @authorId = 3395
;
SELECT *
FROM Name n INNER JOIN dbo.v_cdm_exp_namesAll v ON n.NameId = v.NameId
WHERE (1=0)
OR n.AuthorTeamFk IN (@authorId) OR n.ExAuthorTeamFk IN (@authorId) OR n.BasAuthorTeamFk IN (@authorId) OR n.ExBasAuthorTeamFk IN (@authorId)
OR n.NomRefFk IN (SELECT r.RefId
FROM Reference r INNER JOIN v_cdm_exp_refAll v ON v.RefId = r.RefId
WHERE r.NomAuthorTeamFk IN (@authorId))
;
SELECT *
FROM Reference r INNER JOIN v_cdm_exp_refAll v ON v.RefId = r.RefId
WHERE r.NomAuthorTeamFk IN (@authorId);
SELECT *
FROM AuthorTeam at
WHERE at.AuthorTeamId IN (@authorId);
SELECT *
FROM AuthorTeamSequence seq
WHERE seq.AuthorTeamFk IN (@authorId)
DECLARE @id int;
SET @id = 3453; -- 697, 2168, 3453
--113977, 88135, 88204
SELECT n.*
FROM Name n INNER JOIN dbo.v_cdm_exp_namesAll v ON n.NameId = v.NameId
WHERE n.NomRefFk IN (@id)
SELECT *
FROM v_cdm_exp_refSourceNumbers
WHERE RefId IN (@id);
SELECT *
FROM v_cdm_exp_refNomStatusRefs
WHERE RefId IN (@id);
SELECT pt.*
FROM PTaxon pt INNER JOIN dbo.v_cdm_exp_taxaAll v ON pt.RIdentifier = v.RIdentifier
WHERE pt.PTRefFk IN (@id) or pt.LastScrutinyFk IN (@id)
SELECT *
FROM v_cdm_exp_refLanguageRefs
WHERE RefId IN (@id);
SELECT *
FROM v_cdm_exp_refFactRefs
WHERE RefId IN (@id);
SELECT *
FROM v_cdm_exp_refInRefs
WHERE RefId IN (@id);
#8 Updated by Andreas Müller over 2 years ago
- Related to bug #7817: Team caches should not show '& al.' added
#9 Updated by Andreas Müller almost 2 years ago
- Status changed from In Progress to Resolved
This should be fixed. We may check for not atomized authors after import again
#10 Updated by Andreas Müller almost 2 years ago
- % Done changed from 30 to 90