Controlled subfields of Second repeatable and linked field could be overwritten by "Data import" update.

Description

Overview: Controlled subfields of Second repeatable (with same indicators as first repeatable field) and linked field could be overwritten by "Data import" update.
Controlled subfields that could be overwritten:

  • letter subfields (according to mapping rules of linked field)

  • $0

  • $9
    Steps to Reproduce:
    Preconditions:
    Repeatable (not first) field which has same indicators must be linked, for example:
    The "700" MARC field with "$a" value "Lee, Stan," of imported "Instance" record ("

  • ") must be linked to the "100" field of imported "MARC Authority" record ("

  • ")

  1. Log into Orchid FOLIO environment as User with following permissions:
    Inventory: All permissions
    MARC Authority: View MARC authority record
    quickMARC: View, edit MARC bibliographic record
    Data import: Can upload files, import, and view logs
    UI: Data export module is enabled

  2. Go to "Inventory" app and find the record from precondition (search query ex.: "Black Panther")

  3. Export record from precondition by clicking on checkbox next to it (in the result list) >> Click "Actions" >> "Export instances (MARC)"

  4. Go to "Data export" and download the exported record.

  5. Open downloaded record via "MarcEdit".

  6. Edit controlled subfield of linked field (ex.: 
    1 case - edit "$a" only
    2 case - edit "$0" only
    3 case - edit "$9" only

  7. Edit any not controlled subfield if linked field (ex: "$e" subfield)

  8. Save the record and upload it via "Data import" using "Update MARC bibliographic record" profile (need to create it with match by "999 ff $s")

  9. Once import is complete, open updated "MARC bibliographic record" in "Inventory" and check for updates.

Expected Results:
in 1 case: Link remains. Only not controlled subfield was updated.
in 2 case: Link deleted. Not controlled subfield was updated
in 3 case: Link remains. Only not controlled subfield was updated.
Actual Results:
In cases 1-3: Link remains, and all updates made by user are saved (controlled subfields were updated: $a, $0 or $9)
On screenshot is shown case 1 and 2:

Additional Information: see attached screencast
Interested parties:

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

21

is required by

Checklist

hide

TestRail: Results

Activity

Show:

Khalilah Gambrell April 28, 2023 at 12:16 PM

Hey - I will create the issue but I probably won't get to it for a week or so.

Yauhen Viazau April 28, 2023 at 8:28 AM
Edited

Hi , could you please create a story for Issue #2 mentioned above? We have a TC that is failing due to this. Alternatively, should me or Valery create a bug for this issue?

Valery_Pilko April 21, 2023 at 2:48 PM

So, after discussion, we've agreed that:
found Issue №1 - (When updating $0 in several fields, only the first one is unlinked, and all updated) - will be fixed in scope of MODSOURMAN-974
found Issue №2 - (When two repeatable fields linked to the same record, and one of them has $0 updated, it is added as a new linked field with updated data (original field remains the same) - will create a different story/feature to address this.

I'm moving this issue in PO review.

Valery_Pilko April 21, 2023 at 9:09 AM

Hey  
looks like you were right about the scenario:
When we have 3 repeatable fields linked to different "MARC authority" records
AND When update $0 in each.
AND If in this case, delete all subfields $9 from updated fields 
Then all fields will be unlinked and updated properly.
See attached screencast:

Does that mean that the issue №2 mentioned by will be fixed after some of the following stories?

Yauhen Viazau April 20, 2023 at 9:06 AM

Tested on Snapshot-1 - issues found

Issues:

  • When two repeatable fields linked to the same record, and one of them has $0 updated, it is added as a new linked field with updated data (original field remains the same)

  • When updating $0 in several fields, only the first one is unlinked, and all updated

See screencasts for issues:

  •  

Adding/updating controllable, non-controllable subfields in one linked or unlinked field works as expected.

Adding/updating $9 and $0 in one field also works as expected.

No issues when deleting a field.

See screencasts with working functionality:

  •  

- please review

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Spitfire

Fix versions

Release

Poppy (R2 2023)

RCA Group

Missing integration/unit test

Affected releases

Orchid (R1 2023)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created March 30, 2023 at 3:35 PM
Updated November 28, 2023 at 10:06 AM
Resolved April 24, 2023 at 11:50 AM
TestRail: Cases
TestRail: Runs