Check Link Table Deleted
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