Uploaded image for project: 'mod-orders-storage'
  1. mod-orders-storage
  2. MODORDSTOR-116

Use cross-index subqueries instead of views

    XMLWordPrintable

Details

    • ACQ Sprint 104
    • 1
    • Thunderjet

    Description

      Overview

      Now that we're using RMB 27, we can leverage the cross-index sub-queries instead of views

      Approach

      Create cross-index between order and order lines

      Acceptance Criteria

      • Schema.json

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Tech Debt - UIOR-541 Search performance speed enhancement

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

            New Feature - New feature requests UXPROD-772 Rollover Encumbrances into the next Fiscal Year

            • 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. MODORDSTOR-210 Delete order and order lines views. Use cross-index subqueries instead of views

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

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. PERF-58 CLONE - Use cross-index subqueries instead of views

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

            Activity

              People

                siarhei_hrabko Siarhei Hrabko
                cmcnally Craig McNally
                Craig McNally Craig McNally
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases