Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

[RRT] Prevent permanentLocation populating for Holdings and correct the data

Description

'permanentLocation' field should not be added to the Holdings, it is causing various issues while processing such records. 'permanentLocationId' should be the only reference. 

  • Add validation for Holdings to remove the 'permanentLocation' field

  • Provide migration script to clean up existing data

Environment

None

Potential Workaround

None

Attachments

2

has to be done before

is caused by

is continued by

is required by

relates to

Checklist

hide

TestRail: Results

Activity

Show:

Sri Ranjan December 12, 2023 at 9:32 AM

Thanks  

Pavlo Smahin December 12, 2023 at 9:28 AM

Sri Ranjan December 11, 2023 at 3:06 PM

Can you please confirm the script is https://folio-org.atlassian.net/wiki/display/FOLIJET/Quesnelia+%28R1+2024%29%3A+Holdings+migration? I am not seeing any update statement . Please advise.

Pavlo Smahin December 11, 2023 at 9:28 AM

, no, it's not possible after script. You can change the script by adding "RETURNING id, jsonb" to the update statement, it will return updated records, by it make decrease performance of the script. 

Sri Ranjan December 6, 2023 at 9:22 AM

is it possible to get list of records which get modified by the script after script is run?

Done

Details

Assignee

Reporter

Labels

Priority

Story Points

Sprint

Development Team

Spitfire

Parent

Fix versions

Release

Quesnelia (R1 2024)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created August 8, 2023 at 1:44 PM
Updated September 18, 2024 at 5:22 PM
Resolved December 1, 2023 at 3:50 PM
Configure
TestRail: Cases
TestRail: Runs