Project

General

Profile

Actions

feature request #7799

open

AM: Parse authorteams

Added by Andreas Müller almost 4 years ago. Updated over 3 years ago.

Status:
Resolved
Priority:
Highest
Category:
cdmadapter
Target version:
Start date:
Due date:
% Done:

90%

Estimated time:
3:00 h
Severity:
normal
Tags:

Description

many of them are single persons and also the resulting persons/teams could be parsed probably


Related issues

Related to EDIT - feature request #7800: Parse preliminary RefDetailsClosedAndreas Müller

Actions
Related to EDIT - feature request #7801: AM: Deduplicate referencesClosedAndreas Müller

Actions
Related to EDIT - bug #7817: Team caches should not show '& al.'DuplicateAndreas Müller

Actions
Actions #1

Updated by Andreas Müller almost 4 years ago

  • Tags set to euro+med
Actions #3

Updated by Andreas Müller almost 4 years ago

Actions #4

Updated by Andreas Müller almost 4 years ago

Actions #6

Updated by Andreas Müller almost 4 years ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 30
Actions #7

Updated by Andreas Müller almost 4 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);
Actions #8

Updated by Andreas Müller almost 4 years ago

  • Related to bug #7817: Team caches should not show '& al.' added
Actions #9

Updated by Andreas Müller over 3 years ago

  • Status changed from In Progress to Resolved

This should be fixed. We may check for not atomized authors after import again

Actions #10

Updated by Andreas Müller over 3 years ago

  • % Done changed from 30 to 90
Actions

Also available in: Atom PDF