Specimens sometimes have empty titleCache instead of class<UUID>
Found in Version:
E.g. in additiviy_ontology after running titleCache update for records 72 and 74
Updated by Andreas Müller 10 months ago
- Status changed from Resolved to In Progress
- Target version changed from Release 5.25 to Release 5.35
There are still records in fdac, which is not supported anymore and did not run cache updates.
SELECT * FROM SpecimenOrObservationBase sob WHERE sob.titleCache = '' OR sob.titleCache IS NULL AND sob.protectedTitleCache = 1; SELECT * FROM SpecimenOrObservationBase_AUD sob WHERE sob.id IN ( SELECT id FROM SpecimenOrObservationBase sob WHERE sob.titleCache = '' OR sob.titleCache IS NULL)