Project

General

Profile

feature request #8006

Improve labels for taxon relationships

Added by Andreas Müller almost 3 years ago. Updated about 1 month ago.

Status:
Closed
Priority:
New
Category:
cdm
Target version:
Start date:
01/22/2019
Due date:
% Done:

100%

Severity:
normal

Description

labels should start with "is ..." and should use small laters where appropriate. Similar to #7857


Related issues

Related to Edit - bug #7857: Update name relationship type representations and symmetrie Closed 10/23/2018
Related to Edit - bug #7514: Change direct and inverse symbol for pro parte synonym and misapplied name relationship types. Closed 06/26/2018
Related to Edit - bug #7772: Rename TermBase_inverseRepresentation to DefinedTermBase_InverseRepresentation Closed 09/19/2018
Copied to Edit - bug #8007: Improve labels for concept relationships New 01/22/2019
Copied to Edit - feature request #9767: Improve labels for concept relationships Duplicate 09/17/2021

Associated revisions

Revision a2228e59 (diff)
Added by Andreas Müller over 2 years ago

ref #8006 update labels for MAN, ppSynonyms, inval. desig. & tax. included

Revision 26dbefd5 (diff)
Added by Andreas Müller over 2 years ago

ref #8006, ref #7514 , ref #7857 fix TermRepresentationUpdater sql

Revision 6cd6cbd2 (diff)
Added by Andreas Müller over 2 years ago

ref #8006 update labels for MAN, ppSynonyms, inval. desig. & tax. included

Revision 08f94ac8 (diff)
Added by Andreas Müller over 2 years ago

ref #8006, ref #7514 , ref #7857 fix TermRepresentationUpdater sql

History

#1 Updated by Andreas Müller almost 3 years ago

  • Related to bug #7857: Update name relationship type representations and symmetrie added

#2 Updated by Andreas Müller almost 3 years ago

  • Related to bug #7514: Change direct and inverse symbol for pro parte synonym and misapplied name relationship types. added

#3 Updated by Andreas Müller almost 3 years ago

  • Subject changed from improve labels for taxon relationships to Improve labels for taxon relationships
  • Status changed from New to Resolved

#4 Updated by Andreas Müller almost 3 years ago

  • % Done changed from 0 to 50

#5 Updated by Andreas Müller almost 3 years ago

  • Related to bug #8007: Improve labels for concept relationships added

#6 Updated by Andreas Müller almost 3 years ago

concept relationship labels moved to #8007

#7 Updated by Andreas Müller almost 3 years ago

  • Related to deleted (bug #8007: Improve labels for concept relationships)

#8 Updated by Andreas Müller almost 3 years ago

  • Copied to bug #8007: Improve labels for concept relationships added

#9 Updated by Andreas Müller over 2 years ago

  • Related to bug #7772: Rename TermBase_inverseRepresentation to DefinedTermBase_InverseRepresentation added

#10 Updated by Andreas Müller about 1 month ago

#11 Updated by Andreas Müller about 1 month ago

  • Status changed from Resolved to Closed
  • % Done changed from 50 to 100

Looks correct in production databases

SELECT r.text, r.abbreviatedLabel, r.label, r.plural, r.language_id, dtb.titleCache, dtb.idInVocabulary, dtb.symbol, dtb.symbol2, dtb.id, dtb.vocabulary_id
FROM Representation r INNER JOIN DefinedTermBase_Representation MN ON MN.representations_id = r.id 
INNER JOIN DefinedTermBase dtb ON dtb.id = MN.DefinedTermBase_id
WHERE r.label = 'is taxonomically included in' OR dtb.vocabulary_id IN (24)
;
SELECT r.text, r.abbreviatedLabel, r.label, r.plural, r.language_id, dtb.titleCache, dtb.idInVocabulary, dtb.symbol, dtb.symbol2, dtb.id, dtb.vocabulary_id
FROM Representation r INNER JOIN DefinedTermBase_InverseRepresentation MN ON MN.inverseRepresentations_id = r.id 
INNER JOIN DefinedTermBase dtb ON dtb.id = MN.DefinedTermBase_id
WHERE r.label = 'is taxonomically included in' OR dtb.vocabulary_id IN (24)

(for E+M)

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)