Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-500

Instance source index for = search

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: P3
    • Resolution: Won't Do
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
    • Template:
    • Development Team:
      Prokopovych

      Description

      Overview
      During testing export instance UUIDs workflow.
      The next missing index has been found

      WARNING: Doing FT search without index for instance.jsonb->>'source', CQL >>> SQL: source = folio >>> to_tsvector('simple', f_unaccent(instance.jsonb->>'source')) @@ replace((to_tsquery('simple', f_unaccent('''folio''')))::text, '&', '<->')::tsquery
      
      

      Steps for testing:

      1. Open Inventory App
      2. Select Instance tab in top left
      3. Select Query search in the drop down and type "source=FOLIO" in search field
      4. Under Actions menu click the option “Save instances UUIDs”

      Acceptance Criteria

      • the indexes are added
      • the search consumes less time
      • the warnings are disappeared

      Additional Information:
      URL: https://wiki.folio.org/display/FOLIJET/Export+Instance+UUIDs+Test+Report

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                Zmiivska Svitlana Zmiivska
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases