Project

General

Profile

bug #6340

Update script for nomenclatural status types

Added by Andreas Müller almost 2 years ago. Updated over 1 year ago.

Status:
Closed
Priority:
Highest
Category:
cdm
Target version:
Start date:
01/25/2016
Due date:
01/25/2016
% Done:

100%

Severity:
normal
Found in Version:

Description

Until #5488 was solved it was possible to add a zoological nom status to a botanical name in TaxEditor.
Especially for "invalid" this may have happened as the differences could not be distinguished.
We should update data in the way that botanical names that have a zoological "invalid" state get the botanical "invalid".

Associated revisions

Revision 8947f698 (diff)
Added by Andreas Müller over 1 year ago

fix #6340 update incorrect 'invalid' nomenclatural states

History

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

  • Due date set to 01/25/2016
  • Start date changed from 01/18/2017 to 01/25/2016

#3 Updated by Andreas Müller over 1 year ago

  • Priority changed from New to Highest

#4 Updated by Andreas Müller over 1 year ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 50

#5 Updated by Andreas Müller over 1 year ago

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

I checked on test server for negative results with

SELECT st.id 
FROM NomenclaturalStatus st 
INNER JOIN DefinedTermBase stType ON stType.id = st.type_id  
INNER JOIN TaxonName_NomenclaturalStatus MN ON MN.status_id = st.id
INNER JOIN TaxonName tn ON tn.id = MN.TaxonName_id
WHERE stType.uuid = 'b09d4f51-8a77-442a-bbce-e7832aaf46b7' AND tn.nameType = 'ICZN';

SELECT st.id 
FROM NomenclaturalStatus st 
INNER JOIN DefinedTermBase stType ON stType.id = st.type_id  
INNER JOIN TaxonName_NomenclaturalStatus MN ON MN.status_id = st.id
INNER JOIN TaxonName tn ON tn.id = MN.TaxonName_id
WHERE stType.uuid = '2bef7039-c129-410b-815e-2a1f7249127b' AND tn.nameType <> 'ICZN'

did not found any.

Difficult to check for positive result (successful changes) as I did not remember any false record.
Close anyway.

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)