Project

General

Profile

Actions

bug #7176

open

published=false for Taxon where the according TaxonName is associated with an unpublished Registration

Added by Andreas Kohlbecker about 6 years ago. Updated about 2 years ago.

Status:
Feedback
Priority:
New
Category:
cdm-vaadin
Target version:
Start date:
Due date:
% Done:

20%

Estimated time:
Severity:
blocker
Found in Version:
Tags:

Description

the Taxa having a TaxonName which is not yet published (publication date == null) and which is associated with an unpublished Registration must have a publish flag with value = false

the Registration.status being set to PUBLISHED must be the only criterion for setting the publish flag to true

This is needed to filter the list of Taxa exported as DWC-A (see #7175)

TODO

  • implement in registration UI and business layer (RegistrationDTOService) TODO?
  • fix existing data with sql query : #7186 DONE

Related issues

Related to EDIT - bug #7175: DwC-A export optionally filters by published flagClosedKatja Luther

Actions
Actions #1

Updated by Andreas Müller about 6 years ago

TaxonNames themselves do not have publish flag. So I wonder if this is only a UI issue or a DTO or so?

Actions #2

Updated by Andreas Kohlbecker about 6 years ago

  • Subject changed from published=false for unpublished TaxonNames which are associated with a Registration to published=false for unpublished Taxon where the accoring TaxonName is associated with a Registration
  • Description updated (diff)

ah, well, so the according taxon must be set to published=false

Actions #3

Updated by Andreas Kohlbecker about 6 years ago

  • Related to bug #7175: DwC-A export optionally filters by published flag added
Actions #4

Updated by Andreas Kohlbecker about 6 years ago

  • Status changed from New to In Progress
Actions #5

Updated by Andreas Kohlbecker about 6 years ago

  • Description updated (diff)
Actions #6

Updated by Andreas Kohlbecker about 6 years ago

  • Subject changed from published=false for unpublished Taxon where the accoring TaxonName is associated with a Registration to published=false for Taxon where the accoring TaxonName is associated with an unpublished Registration
  • Description updated (diff)

after a discussion with henning we came to the conclusion that the Registration.status being set to PUBLISHED must be the only criterion for setting the publish flag to true!

changing issue subject and description ...

Actions #7

Updated by Andreas Müller about 6 years ago

  • Target version changed from Release 4.13 to Release 4.14
Actions #8

Updated by Andreas Kohlbecker about 6 years ago

  • Status changed from In Progress to Resolved
  • Target version changed from Release 4.14 to Release 4.13

review if complete

Actions #9

Updated by Andreas Kohlbecker about 6 years ago

  • Subject changed from published=false for Taxon where the accoring TaxonName is associated with an unpublished Registration to published=false for Taxon where the according TaxonName is associated with an unpublished Registration
Actions #10

Updated by Andreas Kohlbecker almost 6 years ago

  • Tags set to phycobank
Actions #11

Updated by Andreas Kohlbecker about 2 years ago

the production dvb is not consitent in the sense of this ticket:

testes on edit-db:

USE cdm_production_phycobank;
select r.identifier, r.status, r.updated , tb.titleCache, tb.publish from Registration r 
    left outer join Registration_TypeDesignationBase r_td on r.id = r_td.registrations_id
    left outer join TaxonName n on n.id = r.name_id
    left outer join TaxonBase tb on n.id = tb.name_id 
    where r.status <> 'PUB' AND tb.publish = 1 AND r.specificIdentifier > 101000
    order by r.registrationDate 

Not only cleaning of older data is needed, The result of above query shows inconsistencies which happendend quite recently.

Actions #13

Updated by Andreas Kohlbecker about 2 years ago

  • Description updated (diff)
Actions #14

Updated by Andreas Kohlbecker about 2 years ago

  • % Done changed from 100 to 20
Actions #15

Updated by Andreas Müller about 2 years ago

  • Status changed from Resolved to Feedback
  • Assignee changed from Andreas Kohlbecker to Andreas Müller
  • Target version changed from Release 4.13 to Release 5.45
Actions

Also available in: Atom PDF