Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-7863

Feature Forecast: No estimate values are returned at team level of additional program

XMLWordPrintable

    • 1
    • Severity 3 - Minor
    • No

      Issue Summary

      The estimates value of team level in the additional program is not returned in the Feature Forecast table in EI/AA.

      This is reproducible on Data Center: (yes)

      Steps to Reproduce

      1. Step 1. Create 2 features with additional programs
      2. Step 2. Add an estimate for the additional program itself to the first feature
      3. Step 3. Add an estimate only for one of the teams of the additional program to the second feature
      4. Step 4. Then run the following query in EI /AA:
         
        -- checking Forecast estimate for additional program
        SELECT [Feature Forecast].[Estimate Float Value] AS [Estimate Float Value],
                   [Feature Forecast].[Feature Forecast ID] AS [Feature Forecast ID],
                   [Feature Forecast].[FK Feature ID] AS [FK Feature ID],
                   [Feature Forecast].[Estimation Object] AS [Estimation Object],
                   [Feature Forecast].[FK Team ID] AS [FK Team ID],
                   [Feature Forecast].[FK Program ID] AS [FK Program ID]
        FROM [current_dw].[Feature Forecast] AS [Feature Forecast]
        WHERE 
        -- adding the filter for  given programs (the primary program = 627 and the additional one = 450)
        [Feature Forecast].[FK Program ID] in ( 450)
        --adding the filter for given feature ids 18565 and 18567 have estimates in additional program 18565-> program and 18567 team)
        and [Feature Forecast].[FK Feature ID] in (18565,18567)
        GROUP BY [Feature Forecast].[Estimate Float Value],
                 [Feature Forecast].[Feature Forecast ID],
                 [Feature Forecast].[FK Feature ID],
                 [Feature Forecast].[FK Team ID],
                 [Feature Forecast].[Estimation Object],
                 [Feature Forecast].[FK Program ID]
        ORDER BY [Estimate Float Value] ASC,
                 [Feature Forecast ID] ASC,
                 [FK Feature ID] DESC
        
      5. Step 5. The query only returns the result for the Feature where the estimate was added at the additional program level
        The query does not return the one at the team level
      6. Step 6. Creating a feature where the estimate is only added to a team belonging to the primary program will have the expected result in EI

      Expected Results

      The estimates value of team level in the additional program is returned in the Feature Forecast table in EI/AA.

      Actual Results

      The estimates value of team level in the additional program is not returned in the Feature Forecast table in EI/AA.

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

        1. AA2.png
          AA2.png
          284 kB
        2. EIAA.png
          EIAA.png
          275 kB
        3. featureDetail.png
          featureDetail.png
          107 kB
        4. featureFF.png
          featureFF.png
          116 kB
        5. forecast.png
          forecast.png
          240 kB
        6. forecast2.png
          forecast2.png
          169 kB

              942a0c021598 Melissa Hartsock
              965b37518492 Rachel Kim
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: