GUEST/IDM/CONNECT

Create the following Indexes in PostgreSQL prior to upgrade.

CREATE INDEX CONCURRENTLY IF NOT EXISTS ix_identity_group_id_lower_primary_email
    ON connect_projection.identity (group_id, LOWER(primary_email));

CREATE INDEX CONCURRENTLY IF NOT EXISTS ix_identity_group_id_lower_employee_number
    ON connect_projection.identity (group_id, LOWER(employee_number));

Run against EventStore DatabaseRun against EventStore Database

DELETE FROM dbo."ConnectIdentityEvents"
WHERE  eventtype IN (
    'Amag.CAC.Contracts.Events.CardOptionsUpdatedEvent, Amag.CAC.Contracts',
    'Amag.CAC.Contracts.Events.DeactivationLevelUpdatedEvent, Amag.CAC.Contracts',
    'Amag.CAC.Contracts.Events.CardUsageUpdatedEvent, Amag.CAC.Contracts'
);

DELETE FROM dbo."AccessControlIntegrationEvents"
WHERE  eventtype IN (
    'AMAG.Symmetry.Contracts.Events.IntegrationCardOptionsBackfillStartedEvent, AMAG.Symmetry.Contracts',
    'AMAG.Symmetry.Contracts.Events.IntegrationCardOptionsBackfillCompletedEvent, AMAG.Symmetry.Contracts'
);

DELETE FROM dbo."VmsEvents"
WHERE eventtype LIKE 'G4S.VMS.Contracts.Events.RecurringVisitSeries%';

Run against Logging Database

DELETE FROM dbo.amag_bash_scripts
WHERE name = '01.002.SyncIdentityBuildingLongitudeFromCore.sh';

Run Against Application Database

/********************************************************************************************
 2.5.0 Rollback Script
 Feature: Remote Door / Remote Access Administrator (epic IDM-18249)
 Run ONLY if rolling back from 2.5.0 to the previous release (2.4.x).
********************************************************************************************/
-- =========================================================================================
-- NEW REPORT: Remove the Remote Access Administrator Activity Report (IDM-20383)
-- The 2.4.x app does not know this report (no xlsx template / sproc). Remove the row so it
-- does not surface as a broken report. Also delete the RoundhousE.ScriptsRun entry so that
-- on roll-forward Grate re-runs 01.005 and re-inserts the report (migration is idempotent).
-- =========================================================================================
-- Remove any saved instances first (defensive — none expected in a fresh release).
DELETE FROM idm.report_saved_reports
WHERE report_id = 'c0276c6b-91e0-4a55-afc7-2d80daf0f8d5'::uuid;
-- Remove the report registration.
DELETE FROM idm.report
WHERE report_id = 'c0276c6b-91e0-4a55-afc7-2d80daf0f8d5'::uuid;
-- Allow the report migration to re-run on roll-forward (re-inserts the report row).
DELETE FROM "RoundhousE"."ScriptsRun"
WHERE script_name = 'idmProjection/01.005_remote_access_admin_activity_report.sql';

Users can now remove a previously assigned PIN and IDS code from an identity.

The Public API now supports adding, updating, and deleting a credential, enabling credential management through external integrations. Customers are advised refer to Swagger Documentation.

Requests now include an additional free-text details field, allowing requesters to capture supporting information.

Administrators can now configure which facility codes are allowed, restricting credential assignment to approved codes.

GUEST now supports scheduling recurring visits, removing the need to enter each visit individually.