Create script to clean up records with inconsistent matched id values

Description

Create script to fix existing records - if 999 ff s UUID is different from matched_id and status ACTUAL - get highest generation for matched_id and overwrite matched_id to be the same as 999 ff s with incremented generation. If more than 1 ACTUAL record with the same matched_id - set status OLD to all the other records.

Script will be executed on demand and should be placed on the page https://folio-org.atlassian.net/wiki/display/FOLIOtips/Scripts+for+Inventory%2C+Source+Record+Storage%2C+and+Data+Import+Cleanup

Environment

None

Potential Workaround

None

CSP Request Details

None

CSP Approved

None

CSP Rejection Details

None

Checklist

hide

TestRail: Results

Activity

Show:

Kateryna Senchenko November 1, 2023 at 2:18 PM

Script was run on Orchid and Poppy bugfest envs in scope of correcting 20 records. Thank you and   for taking care of it. Closing this issue

Kateryna Senchenko October 11, 2023 at 8:26 AM

Hi , please close the PR - the script can take too long to be executed during module migration, and should be run on demand.

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Folijet

Release

Poppy (R2 2023) Bug Fix

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created July 6, 2023 at 10:47 AM
Updated October 28, 2024 at 5:14 PM
Resolved November 1, 2023 at 2:19 PM
TestRail: Cases
TestRail: Runs