Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-7483

Convert to fn_GetFinancialTypeAmountsByBusinessDay

    Details

    • Type: Improvement
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: CFA 2020R1
    • Fix Version/s: CFA 2020R1
    • Component/s: None
    • Labels:
      None
    • SCRUM Team:
      Brotherhood of Mutants
    • Sprint:
      CFAMX 2020R1 Hardening

      Description

      We are currently using fn_GetFinancialTypeAmounts to gather Daily Summary data for the Finalize Day page which searches by TransactionDate Range.

      CFA typically does everything by BusinessDay so I am not sure if we are even really using the right query to do it by TransactionDate. In addition to being more correct, getting this data by BusinessDay is also much faster.

      I am moving this into an SP as well so that if we ever run into any problems, we could easily switch it back without a code deploy.

        Attachments

          Activity

            People

            • Assignee:
              charles.wheeler Charles Wheeler
              Reporter:
              Michael.DeBinder Michael DeBinder (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

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

                  PagerDuty

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