Actions
feature request #8006
closedImprove labels for taxon relationships
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
Updated by Andreas Müller about 4 years ago
- Related to bug #7857: Update name relationship type representations and symmetrie added
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
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
Updated by Andreas Müller about 4 years ago
- Related to bug #8007: Improve labels for concept relationships added
Updated by Andreas Müller about 4 years ago
concept relationship labels moved to #8007
Updated by Andreas Müller about 4 years ago
- Related to deleted (bug #8007: Improve labels for concept relationships)
Updated by Andreas Müller about 4 years ago
- Copied to bug #8007: Improve labels for concept relationships added
Updated by Andreas Müller almost 4 years ago
- Related to bug #7772: Rename TermBase_inverseRepresentation to DefinedTermBase_InverseRepresentation added
Updated by Andreas Müller over 1 year ago
- Copied to feature request #9767: Improve labels for concept relationships added
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