Details

    • Type: Customer Defect
    • Status: In Functional Review (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: CFA 2022R5
    • Component/s: Reports
    • Labels:
      None
    • Root cause - Reason:
      Code defect
    • Root Cause:
      code change

      Description

      in sp_suggestedorderexport.sql , The WHERE clause is using ipo.orderdate, which is the immutable "created date" of the order. The SP returns orders from a date range. This means that if an order is created on 9/1 and updated on 9/10 and we hit the SP with a date range of start>=9/9 and end<=9/10, this order will not be included... ie we might have the original order, but never update it.

       

       

      CFA believes the fix is changing orderdate to ipo.lastupdatedate, but I wanted Fourth to confirm that this will work.

       

        Attachments

        1. image-2022-09-29-15-53-07-260.png
          103 kB
          Wesam El-Gendy
        2. image-2022-10-04-12-11-17-124.png
          74 kB
          Wesam El-Gendy
        3. image-2022-10-04-12-11-34-907.png
          160 kB
          Wesam El-Gendy
        4. sp_suggestedorderexport.sql
          9 kB
          Colin Wyatt-Goodall

          Issue Links

            Activity

              People

              • Assignee:
                wesam.el-gendy Wesam El-Gendy
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 8h
                  8h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.