NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
SELECT
"public".link.approval_state,
"public".link.from_guid,
"public".link.from_link_type,
"public".link.to_link_type,
ORDER BY
"public"."location".location_localid ASC
</pre>
==Case Items linking to other than Location orphans==__NOEDITSECTION__
The items that was approved to these items do not exist in the database anymore. The items that have the orphans opens without any error messages so I do not think these orphans must be deleted from the database.
<pre>
SELECT
"public".link.approval_state,
"public".link.from_guid,
"public".link.from_link_type,
"public".link.to_link_type,
"public".link.system_link,
"public".link.to_link_is_version,
"public".link.data_entry_date,
"public".link.update_type
FROM
"public".link
WHERE
"public".link.from_guid IS NULL AND
"public".link.to_link_type <> 'LOCATION'
</pre>
[[Category:SQL Queries]]
[[Category:NoPublic]]
{{NavBox Hub}}
