bug #7176
openpublished=false for Taxon where the according TaxonName is associated with an unpublished Registration
20%
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
Updated by Andreas Müller about 5 years ago
TaxonNames themselves do not have publish flag. So I wonder if this is only a UI issue or a DTO or so?
Updated by Andreas Kohlbecker about 5 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
Updated by Andreas Kohlbecker about 5 years ago
- Related to bug #7175: DwC-A export optionally filters by published flag added
Updated by Andreas Kohlbecker about 5 years ago
- Status changed from New to In Progress
Updated by Andreas Kohlbecker about 5 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 ...
Updated by Andreas Müller about 5 years ago
- Target version changed from Release 4.13 to Release 4.14
Updated by Andreas Kohlbecker about 5 years ago
- Status changed from In Progress to Resolved
- Target version changed from Release 4.14 to Release 4.13
review if complete
Updated by Andreas Kohlbecker about 5 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
Updated by Andreas Kohlbecker about 1 year 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.
Updated by Andreas Müller about 1 year 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.38