Project

General

Profile

Actions

bug #9785

closed

Update script for missing measurment unit_ids (matrix)

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

Status:
Closed
Priority:
Highest
Category:
data
Target version:
Start date:
Due date:
% Done:

100%

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

Description

for details see #9772#note-24

The problem existed already befor so there are lots of data with missing unit_id (e.g. 745 records in greece_bupleurum).

As recommended measurement units is usually only 1 unit per character it should be possible to reconstruct them.

SELECT deb.unit_id, deb.*
FROM DescriptionElementBase deb
WHERE deb.DTYPE LIKE 'Quant%' AND deb.unit_id IS NULL
ORDER BY id DESC

Related issues

Copied from EDIT - bug #9772: Improve DTO usage for character matrixClosedKatja Luther

Actions
Actions

Also available in: Atom PDF