Versions Compared

Old Version 2

changes.mady.by.user Pavlo Smahin

Saved on

compared with

New Version Current

changes.mady.by.user Pavlo Smahin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Due to migration issues in previous releases, there may be cases where deleted authority records are not transferred to the authority archive. While this doesn't significantly impact functionality, moving them to the correct location would enhance consistency.

Module

Instructions

Comments

Contact person

mod-entities-links

Manually executed script for each tenant

Code Block
-- Check if such record exists
SELECT 1 FROM <tenantId>_mod_entities_links.authority WHERE deleted = true;
-- Move to archive
INSERT INTO <tenantId>_mod_entities_links.authority_archive
SELECT * FROM <tenantId>_mod_entities_links.authority WHERE deleted = true
ON CONFLICT DO NOTHING;
-- Delete deleted
DELETE FROM <tenantId>_mod_entities_links.authority WHERE deleted = true;

,
automation Jira