Changes

Check Link Table Deleted

536 bytes added, 07:52, 10 January 2019

Created page with "The common reason why soft delete did not have effect is that several DEFs have been created with the same ''Date of Information''. <pre> SELECT "public".link.from_guid, "publ..."

The common reason why soft delete did not have effect is that several DEFs have been created with the same ''Date of Information''.
<pre>
SELECT
"public".link.from_guid,
"public".link.from_link_type,
"public".link.to_link_type,
"public".link.to_guid,
"public".link.update_type,
"public".link.deleted,
"public".link.data_entry_date
FROM
"public".link
WHERE
"public".link.update_type = 'DELETE' AND
"public".link.deleted = 'f'
ORDER BY
"public".link.from_link_type ASC
</pre>
[[Category:SQL Queries]]
[[Category:NoPublic]]
{{NavBox Hub}}

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits