Alnaucler: 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''.

 SELECT "public".link.from_guid, "publ..."

2019-01-10T05:52:46Z

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..."

New page

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

Check Link Table Deleted - Revision history

Alnaucler: 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''.
SELECT "public".link.from_guid, "publ..."