NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
== Missing Local ID Auxiliary data and Task==__NOEDITSECTION__
=== Country structure===__NOEDITSECTION__
In 5.x the Country Structure ID was not visible in the editor and therefore many countries will have blank here. To have a proper ID will facilitate Country structure updates which happens regularly.
<pre>
SELECT
gazetteer.gazetteer_localid
FROM
gazetteer
WHERE
gazetteer_localid IS NULL OR length(trim(gazetteer_localid)) = 0
</pre>
=== Organisation ===__NOEDITSECTION__
<pre>
SELECT
organisation.org_localid
FROM
organisation
WHERE
org_localid IS NULL OR length(trim(org_localid)) = 0
</pre>
=== Place ===__NOEDITSECTION__
<pre>
SELECT
place.place_localid
FROM
place
WHERE
place_localid IS NULL OR length(trim(place_localid)) = 0
</pre>
=== Task===__NOEDITSECTION__
<pre>
SELECT
task.localid
FROM
task
WHERE
task.localid IS NULL or length(trim(task.localid))=0
</pre>
=== Work item ===__NOEDITSECTION__
<pre>
SELECT
work_item.localid
FROM
work_item
WHERE
work_item.localid IS NULL OR length(trim(work_item.localid)) = 0
</pre>
=== Example update query ===__NOEDITSECTION__
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
