Uploaded image for project: 'cql2pgjson'
  1. cql2pgjson
  2. CQLPG-41

Implement foreign key searches

    XMLWordPrintable

Details

    • Core: Platform

    Description

      We need to be able to search things in the related tables. For example, in mod-inventory-storage, an itemcan have an ID of a MaterialType, and we want to search by the name of the materialType.

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Umbrella - CQLPG-59 Get rid of the regexp indexes and queries

            • 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-199 Filter by the effective location

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

            Task - A task that needs to be done. CQLPG-95 SPIKE: design foreign key search support

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

            Task - A task that needs to be done. RMB-380 implement new approach for searching array-of-strings and array-of-objects fields

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

            New Feature - New feature requests CQLPG-81 Redesign CQL to SQL generation

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

            Task - A task that needs to be done. CQLPG-87 SPIKE: Determine the scope of the work required to implement cross-table queries

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

            New Feature - New feature requests CQLPG-37 Schema driven CQL generation and PGFT support

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

            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. UIIN-199 Filter by the effective location

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

            New Feature - New feature requests CQLPG-40 Find out what mod-inventory-storage needs to work with the fulltext stuff

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

            New Feature - New feature requests CQLPG-49 More Schema-driven indexes

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

            New Feature - New feature requests CQLPG-90 Remove legacy query translation based on individual json schema files

            • 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. MODINVSTOR-138 Create indices for all location IDs (holdings-record, item)

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

            New Feature - New feature requests MODINVSTOR-277 SPIKE: filtering by Effective Location

            • 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. UIIN-1515 Item lookup and selection

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

            New Feature - New feature requests UXPROD-1049 Search by automatically deriving relationships and data types from table and entity schema

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

            Activity

              People

                kurt Kurt Nordstrom
                heikki Heikki Levanto
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases