Check Link Table Deleted

From IMSMA Wiki
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