Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-454

sortby does not work with target tables (when using cross-table search)

    XMLWordPrintable

Details

    • CP: Roadmap backlog
    • 3
    • Core: Platform

    Description

      "RMB has offered views and sorting can of course work with that.

      RMB-395 offers cross table queries but does not offer the ability to sort by joined (target) columns.

      We need to extend the cross-table (join) support to also allow sorting by joined properties

      This is illustrated by a unit test that had to be disabled: https://github.com/folio-org/mod-inventory-storage/blob/292063d90e7b4d5d0d4da038d2691232763633e5/src/test/java/org/folio/rest/api/InstanceStorageTest.java#L1337

      CQL: title="Long Way to a Small Angry Planet*" sortBy holdingsRecords.permanentLocationId

      This is likely not a real-life problem since we do not offer this specific sort criteria to the UI.

      And it is not clear which permanentLocationId to use if an instance has several holdings.

      Workaround:

      Run the query against the API endpoint that contains the record with the sort field. Using the CQL example from above: Run this CQL query against the holdings API:
      instance.title = "Long Way to a Small Angry Planet*" sortBy permanentLocationId
      This is not exactly the same because an instance is returned multiple times if it has multiple holdings.

      TestRail: Results

        Attachments

          Issue Links

            blocks

            New Feature - New feature requests MODCR-21 Sorting on joined fields

            • TBD - To be determined
            • Blocked

            New Feature - New feature requests UXPROD-1820 RMB 27 release features and core module rollout (performance, virtual indexes, search enhancements)

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

            New Feature - New feature requests UXPROD-2119 RMB 28 release features and core module rollout (performance, virtual indexes, search enhancements)

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

            Task - A task that needs to be done. RMB-467 SPIKE: how to sort and select on the data from foreign tables?

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

            Task - A task that needs to be done. RMB-395 support nested sub queries across multiple tables

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

            New Feature - New feature requests FOLIO-677 Sorting on names (rather than IDs) of fields that are linked into main record

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

            Task - A task that needs to be done. MODINVSTOR-339 Use new foreign key for holdings and bar code search

            • 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-466 drop CQL2PgJSON view constructor

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

            Activity

              People

                Unassigned Unassigned
                adam Adam Dickmeiss
                Votes:
                2 Vote for this issue
                Watchers:
                13 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases