Uploaded image for project: 'mod-users'
  1. mod-users
  2. MODUSERS-247

Add unique constraint for user externalSystemId

    XMLWordPrintable

Details

    • Standard Bug Write-Up Format
    • Core: Platform
    • Lotus R1 2022
    • Chalmers, TAMU, University of Chicago

    Description

      FOLIO is allowing more than one user to have the same externalSystemId. This field is missing a unique constraint. Please add one like the existing ones for barcode and username.

      The Check-Out settings allow to use the external system id as a unique patron identifier: https://folio-snapshot.dev.folio.org/settings/circulation/checkout

      If external system id is not unique the check-out will pick one of the multiple matches without any warning that it might be the wrong patron.

      The upgrade will fail if existing patrons have non-unique external system id with an error message containing the duplicate value. This is mentioned in the https://wiki.folio.org/display/REL/Lotus+%28R1+2022%29+Release+Notes

      There is no automated way to fix duplicates during migration therefore the failure is the only option we have.

      See also https://wiki.folio.org/display/UM/2021-02-17+Meeting+Notes

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                julianladisch Julian Ladisch
                jemiller Jon Miller
                Votes:
                0 Vote for this issue
                Watchers:
                11 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases