Project

General

Profile

Actions
Copy link

bug #10163

closed

Fix label for "Orthography Conserved" and "Conserved Desig"

Added by Andreas Müller 12 months ago. Updated 12 months ago.

Status:
Closed
Priority:
Highest
Assignee:
Andreas Müller
Category:
cdm
Target version:
Release 5.33
Start date:
Due date:
% Done:

100%

Estimated time:
Severity:
normal
Found in Version:

Description

When fixing #9311 the label update for "Conserved Desig => Conservation Designated" went wrong as the wrong term was taken. Instead of relabeling nom. cons. des. (uuid = 4e9c9702-a74d-4033-9d47-792ad123712c) orth. cons. (uuid = '34a7d383-988b-4117-b8c0-52b947f8c711') was relabeled.

So we need to relabel Conserved Desig => Conservation Designated and the current Conservation Designated back to Orthography Conserved again.

Related issues

Related to EDIT - bug #9311: Update some (abbrev) labels for nomenclatural status typesClosedAndreas Müller

Actions
Actions
Copy link
 #1

Updated by Andreas Müller 12 months ago

  • Related to bug #9311: Update some (abbrev) labels for nomenclatural status types added
Actions
Copy link
 #2

Updated by Andreas Müller 12 months ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 70
Actions
Copy link
 #3

Updated by Andreas Müller 12 months ago

Still needs to switch to schema version 5.33 and after release check databases for possibly incorrect data.

Actions
Copy link
 #4

Updated by Andreas Müller 12 months ago 

SELECT dtb. UUID, dtb.id, dtb.titleCache, r.label, r.abbreviatedlabel, r.text
FROM DefinedTermBase dtb INNER JOIN DefinedTermBase_Representation MN ON MN.DefinedTermBase_id = dtb.id 
INNER JOIN Representation r ON r.id = MN.representations_id 
WHERE dtb.UUID = '4e9c9702-a74d-4033-9d47-792ad123712c' OR dtb.UUID = '34a7d383-988b-4117-b8c0-52b947f8c711';
Actions
Copy link
 #5

Updated by Andreas Müller 12 months ago

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

This seems to work as expected now.

Actions
Copy link
 #6

Updated by Andreas Müller 12 months ago

Andreas Müller wrote in #note-3:

Still needs to switch to schema version 5.33 and after release check databases for possibly incorrect data.

All databases checked. Flora of Greece had 1 occurrence but it was correct. "Moose" and "German Standardliste" had occurrence but they can't be caused by the issues.
8 occurrences in flora cuba were sent to WGB for checking.

Actions
Copy link
 #7

Updated by Andreas Müller 12 months ago 

SELECT  ns.id,  tn.fullTitleCache, tn.created, tn.createdBy_id, tn.updated
FROM DefinedTermBase dtb INNER JOIN DefinedTermBase_Representation MN ON MN.DefinedTermBase_id = dtb.id 
INNER JOIN Representation r ON r.id = MN.representations_id
INNER JOIN NomenclaturalStatus ns ON ns.type_id = dtb.id
LEFT JOIN TaxonName tn ON tn.id = ns.name_id 
WHERE dtb.UUID = '34a7d383-988b-4117-b8c0-52b947f8c711'
Actions
Copy link

Also available in: Atom PDF