MARC Bib record doesn't open after update of repeatable linked field "$0" using mapping profile which allows to update

Description

Overview: MARC Bib record doesn't open after update of repeatable linked field's "$0" subfield using mapping profile which allows to update "$0" subfield of updated field.
Steps to Reproduce:

  1. Log into Snapshot FOLIO environment as User with following permission:
    Data import: Can upload files, import, and view logs
    Inventory: All permissions
    MARC Authority: View MARC authority record
    quickMARC: Can Link/unlink authority records to bib records
    quickMARC: View, edit MARC bibliographic record

  2. The job profile should be created for "Data import" app: "Update MARC Bib by matching 999 ff $s subfield value", with "700 * * 0" specified in "Field mapping - MARC Bibliographic - Updates" accordion of mapping profile.
    See example on screenshot:

  3. Create a link between imported "MARC Authority" (

  1. ) and "MARC Bibliographic" (

  1. ) records:
    The "700" MARC field with "$a" value "Lee, Stan," of imported "MARC bib" must be linked to the "100" field of imported "MARC Authority".

  2. Export and download "MARC Bib" record with linked "700" field ("Lee, Stan,") via "Data export" app.

  3. Open downloaded ".mrc" file via "MarcEdit" (or any similar app).

  4. Edit subfield "$0" of linked repeatable field allowed to update.
    For example: edit the value of subfield "$0" in "700" field:
    From "$0id.loc.gov/authorities/names/n83169267" to "$0id.loc.gov/authorities/names/n831692"

  5. Save the edited ".mrc" file.

  6. Go to "Data import" and import saved ".mrc" file using created at 2nd step job profile.

  7. Once import is complete open detail view of updated record in "Inventory" app.

  8. Click on the "Actions" button and select "Edit MARC bibliographic record" option.

Expected Results:
1) Editing window of updated "MARC bib" record is opened.
2) "700" field with "Stan, Lee" in "$a" subfield was unlinked.
3) updated value is displayed in "$0" subfield "id.loc.gov/authorities/names/n831692" ** 
Actual Results:
1) "Record cannot be found or loaded." is displayed on UI.
In "Actions" > "View source" you can see that:
2) "$0" wasn't updated in "700" field with "Stan, Lee" in "$a"
3) "$9" wasn't deleted from "700" field with "Stan, Lee" in "$a"
From API call to "/links/instances/<UUID of Instance>" you can see that:
4) The link was deleted. 
Additional Information: See attached screencast:

1) When mapping profile is set up with "700 * * *" and user executes same sceanario as in desrciption - "700" field with updated "$0" deletes in updated record.

2) Works as expected when mapping profile is set up with "100 * * 0" and user updates "$0" of linked "100" field.
Interested parties:

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

6

Checklist

hide

TestRail: Results

Activity

Show:

Valery_Pilko May 25, 2023 at 2:24 PM
Edited

The issue described in this ticket was fixed.
See attached screencast:

More common issue was defined during testing:

Hey  
Please review comment from https://folio-org.atlassian.net/browse/MODDICORE-332 
We might need to schedule an additional meeting to discuss the most common use cases about field mapping restrictions and linked fields.
Thank you in advance.

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

Poppy (R2 2023)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created May 3, 2023 at 11:44 AM
Updated October 11, 2023 at 7:45 PM
Resolved May 28, 2023 at 2:35 PM
TestRail: Cases
TestRail: Runs