Project

General

Profile

Actions

feature request #8006

closed

Improve labels for taxon relationships

Added by Andreas Müller about 4 years ago. Updated over 1 year ago.

Status:
Closed
Priority:
New
Category:
cdm
Target version:
Start date:
Due date:
% Done:

100%

Estimated time:
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 symmetrieClosedAndreas Müller

Actions
Related to EDIT - bug #7514: Change direct and inverse symbol for pro parte synonym and misapplied name relationship types.ClosedAndreas Müller

Actions
Related to EDIT - bug #7772: Rename TermBase_inverseRepresentation to DefinedTermBase_InverseRepresentationClosedAndreas Müller

Actions
Copied to EDIT - bug #8007: Improve labels for concept relationshipsNewAndreas Müller

Actions
Copied to EDIT - feature request #9767: Improve labels for concept relationshipsDuplicateAndreas Müller

Actions
Actions #1

Updated by Andreas Müller about 4 years ago

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

Updated by Andreas Müller about 4 years ago

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

Updated by Andreas Müller about 4 years ago

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

Updated by Andreas Müller about 4 years ago

  • % Done changed from 0 to 50
Actions #5

Updated by Andreas Müller about 4 years ago

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

Updated by Andreas Müller about 4 years ago

concept relationship labels moved to #8007

Actions #7

Updated by Andreas Müller about 4 years ago

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

Updated by Andreas Müller about 4 years ago

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

Updated by Andreas Müller almost 4 years ago

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

Updated by Andreas Müller over 1 year ago

Actions #11

Updated by Andreas Müller over 1 year 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)

Actions

Also available in: Atom PDF