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

Moving work item to Parking Lot fails to update "Parking Lot Flag" in EI

XMLWordPrintable

    • 1
    • Severity 2 - Major
    • No

      Issue Summary

      When a work item is moved from Backlog to the Parking Lot, the "Parking Lot Flag" value does not get updated in Enterprise Insights.

      Steps to Reproduce

      Tested with Program rank, but context does not seem to affect issue.

      1. Move a Jira Align Epic from main backlog to Parking Lot
      2. Allow EI enough time to update
      3. Query the appropriate program rank in EI
        SELECT E.[Epic ID], E.[Epic Name],
        ROW_NUMBER() OVER(ORDER BY e.[Parking Lot Flag], ISNULL(r.[Rank], 2147483647), e.[Epic Name] ASC) AS Row#, e.[Parking Lot Flag]
        FROM current_dw.Epic E
        INNER JOIN current_dw.[MAP Epic to Program] mEP
        	ON E.[Epic ID] = mEP.[FK Epic ID]
        LEFT OUTER JOIN current_dw.[Epic Rank Program] r
        	ON e.[Epic ID] = r.[FK Epic ID]
        	AND mEP.[FK Program ID] = r.[FK Program ID]
        	WHERE mEP.[FK Program ID] = 467
        ORDER BY e.[Parking Lot Flag], ISNULL(r.[Rank], 2147483647), e.[Epic Name]
        
      4. Notice that the rank is updated successfully and reflects the items move to the Parking Lot, BUT the "Parking Lot Flag" itself is still set to "No"
      5. Open the work item and click Save (allow EI enough time to update)
      6. Repeat the same EI query and notice the "Parking Lot Flag" is now updated

      Expected Results

      EI "Parking Lot Flag" is updated automatically when a work item is moved to the Parking Lot

      Actual Results

      EI "Parking Lot Flag" is NOT updated automatically when a work item is moved to the Parking Lot

      Workaround

      Open the work item in the UI and manually Save

        1. image-2022-07-18-13-45-40-515.png
          62 kB
          Brandon Harris
        2. image-2022-07-18-13-47-07-164.png
          19 kB
          Brandon Harris
        3. image-2022-07-18-13-47-52-733.png
          34 kB
          Brandon Harris
        4. image-2022-07-18-13-48-08-610.png
          19 kB
          Brandon Harris

            8e26ebc02345 Evelyn Doro
            1a93744f1bf8 Brandon Harris
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: