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

Add unique constraint for user externalSystemId

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Development Team:
      Core: Platform
    • Release:
      Lotus R1 2022
    • Affected Institution:
      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

            relates to

            Bug - A problem which impairs or prevents the functions of the product. UIU-2049 Trim input values and convert empty string to null

            • TBD - To be determined
            • Blocked

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. UIU-2529 Error popup on HTTP error status code (500, 400, 409, ...)

            • TBD - To be determined
            • Open

            New Feature - New feature requests UXPROD-2936 Check-Out App: Allow Custom Fields as Patron Identifiers for Check-Out

            • TBD - To be determined
            • Closed

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODUSERS-159 Extend External System ID to support multiple IDs and types

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Open

            New Feature - New feature requests UXPROD-2148 Users App: Support multiple External System IDs

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Analysis Complete
            mentioned in

            Page Loading...

            Page Loading...

              Activity

                People

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases