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

Add unique constraint for user externalSystemId

    XMLWordPrintable

Details

    • 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

            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...

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases