Project

General

Profile

task #7455

Updated by Andreas Müller 7 months ago

Check if all existing markers are still up-to-date with the current E+M import strategy.

~~~
SELECT flag, dtb.titleCache, count(*) as n
FROM Marker m INNEr JOIN DefinedTermBase dtb ON dtb.id = m.markerType_id
GROUP BY flag, titleCache
ORDER BY n, titleCache, flag;

SELECT deb.DTYPE, deb.feature_id, dtb.titleCache
FROM DescriptionElementBase deb
INNER JOIN DescriptionElementBase_Marker MN ON MN.DescriptionElementBase_id = deb.id
INNER JOIN Marker m ON m.id = MN.markers_id
INNEr JOIN DefinedTermBase dtb ON dtb.id = m.markerType_id
ORDER BY deb.DTYPE, dtb.titleCache
~~~

The most important decision is the publish flag on distributions. Is it needed?

![](picture714-1.png)

Back

Add picture from clipboard (Maximum size: 40 MB)