Uploaded image for project: 'ui-inventory'
  1. ui-inventory
  2. UIIN-199

Filter by the effective location

    XMLWordPrintable

Details

    • Core: F - Sprint 69, Core: F - Sprint 70, Core: F - Sprint 71, Core: F - Sprint 75, Core: F - Sprint 76, Core: F - Sprint 77
    • 8
    • Prokopovych

    Description

      Purpose: The filter for Locations which we implemented for alpha was based on Permanent location in the Holdings record, and Temporary location in the Item record. For beta we'll follow the Effective Location logic described on wiki: https://wiki.folio.org/display/RA/Effective+Location+Logic

      The Location filter will be derived of the effective location for the given item.

      Proposed CQL to filter by effective location:

      item.pL = x OR (item.pL = "" AND item.tL = x) OR (item.pL = "" AND item.tL = "" AND holding.pL = x) OR (item.pL = "" AND item.tL = "" AND holding.pL = "" AND holding.tL = x)

      UX mock ups:

      1) The Effective location filter will be an unfolded filter at all three segments Instance (UIIN-759), holdings (UIIN-760) and item (UIIN-761) . When no search has been entered it looks like this:

      2) When start entering search it will be following display. If a library has many, maybe even 100s of locations, then the list should only display the first 5 location.

      3) The look up will be based on type ahead functionality:

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. UIIN-233 Holdings Record. Accordion Locations. Implement new elements and reorder data

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

            New Feature - New feature requests UXPROD-140 Q4 2019 Timebox for Priority Inventory Search and Filter Enhancements

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            is blocked by

            New Feature - New feature requests CQLPG-41 Implement foreign key searches

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

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-61 Duplicate instance rows returned for cross-table filters

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINVSTOR-348 UIIN-199: Filter by Effective Location: Save Effective Location on Item Record

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

            Bug - A problem which impairs or prevents the functions of the product. RMB-178 parseQuery throws StackOverflowError for deeply nested SQL query

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

            Bug - A problem which impairs or prevents the functions of the product. RMB-179 net.sf.jsqlparser does not support "IS TRUE" and "a@>b"

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

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-364 holdingsRecord.permanentLocationId is required field

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. UIIN-1008 Inventory search. Relabel filter to be named Effective location (item) - in all three segments

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

            New Feature - New feature requests UXPROD-1432 Add new effective location attribute calculated at the time of check-out

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

            Bug - A problem which impairs or prevents the functions of the product. CHAL-91 Infinite scroll breaks/freezes when you scroll using scroll bar

            • TBD - To be determined
            • Closed

            New Feature - New feature requests CQLPG-41 Implement foreign key searches

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

            New Feature - New feature requests MODINV-56 Resolve location id overrides

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MSEARCH-3 Instance - hierarchical filter by item effective locations - inventory

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MSEARCH-32 Holdings - hierarchical facet by permanent locations

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MSEARCH-48 Instance - search by item's effective locations

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MSEARCH-55 Instance - filter/facet by item effective locations

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MSEARCH-56 Holdings - filter/facet by permanent locations

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. UIIN-194 Add Temporary Location to Inventory Holdings Record

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. UIIN-195 Add Locations Section to Inventory Item Record Incl Permanent Location

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. UIIN-196 Add Effective Location to Inventory Item Record

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. UIIN-679 Holdings and item segment. Filter by the Holdings permanent location (in addition to effective - UIIN-199)

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. UIORG-86 Delete Location (Hierarchical)

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

            Activity

              People

                mattjlc Matt Connolly
                jakub Jakub Skoczen
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases