Changes

Link Orphans

664 bytes added, 17:09, 17 April 2017

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}}

• ← Older edit

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits