feature request #8006
Improve labels for taxon relationships
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
Associated revisions
ref #8006 update labels for MAN, ppSynonyms, inval. desig. & tax. included
ref #8006 update labels for MAN, ppSynonyms, inval. desig. & tax. included
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
- Copied to feature request #9767: Improve labels for concept relationships added
#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)
