feature request #7799
open
- Status changed from New to In Progress
- % Done changed from 0 to 30
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);
- Related to bug #7817: Team caches should not show '& al.' added
- Status changed from In Progress to Resolved
This should be fixed. We may check for not atomized authors after import again
- % Done changed from 30 to 90
Also available in: Atom
PDF