Uploaded image for project: 'mod-circulation-storage'
  1. mod-circulation-storage
  2. CIRCSTORE-219

Create request.requestType b-tree index

    XMLWordPrintable

Details

    • CP: sprint 92
    • 0.5
    • Core: Platform
    • Q2 2020

    Description

      request.requestType is an enum with these values: ["Hold", "Recall", "Page"]
      The correct match operator is the field matching ==
      The existing "ginIndex" should be removed and a b-tree "index" created. It should be case insensitive (for usability, the same as other request b-tree indexes) and accents sensitive (we don't expect "Höld" searches.
      The new index will also provide better totalRecords estimations resolving CIRCSTORE-210.
      Front-end has already switched to ==: https://github.com/folio-org/ui-requests/pull/605/files = CIRC-817

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Task - A task that needs to be done. CIRCSTORE-139 Address index warnings from perf test

            • TBD - To be determined
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. CIRCSTORE-210 Requests -Filtering by Request Type returns (Total Records = 1000) when there are more

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            has to be done before

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CIRCSTORE-221 Release mod-circulation-storage 12.0.1

            • TBD - To be determined
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. CIRC-817 Error when trying to filter by Request type in Bugfest (only certain logins)

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                julianladisch Julian Ladisch
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases