NoPublic, bureaucrat, administrator
6,632
edits
Changes
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}}
<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}}
