Check Link Table Deleted

From IMSMA Wiki
Revision as of 07:52, 10 January 2019 by Alnaucler (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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

Template:NavBox Hub