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

EI view [MAP Objective to Epic], as for some of their Objectives, the count of items on the UI x EI doesn't match.

    XMLWordPrintable

Details

    • 1
    • Severity 3 - Minor
    • No

    Description

      Issue Summary

      EI view [MAP Objective to Epic], as for some of their Objectives, the count of items on the UI x EI doesn't match.

      This is reproducible on Data Center: yes

      Steps to Reproduce

      1. Create an Objective in Jira Align for a specific Program
      2. Create multiple Epics and Capabilities related to a specific Program
      3. In the Objective panel screen add the Epics and Capabilities created to relate the Objective to all Epics created.
      4. After waiting the ETL job to run, execute the following SQL query and check if the Epics listed to Objetive match with the ones listed in Jira Align UI.
        select * from current_dw.[MAP Objective to Epic]
        where [FK Objective ID]=1261
      5. Remove one of the Epics of the Objective and wait for the ETL job to run, check in the view the Epic will be removed on current_dw schema, it will show with deleted flag in export_dw schema
      6. Add back the removed Epic to the Objective and wait for the ETL job to run, check in the view the Epic will be added back on the current_dw schema.

      SQL Query:

      select * from current_dw.[MAP Objective to Epic]
      where [FK Objective ID]=1261

      Interestingly when we look at the below screenshot, we can see that on upd_map_objective_epic, the ones that are appearing on EI have the [fk capability id] as null, while all the other ones have it as the same as the [fk epic id] (and this is the point I believe your comment touches, and why they are missing)

      Expected Results

      All Epics and Capabilities to reflect in [MAP Objective to Epic] in Enterprise Insights as the Portfolio Epics list for the Objective in JA UI.

      Actual Results

      Only Epics are listed in [MAP Objective to Epic] in Enterprise Insights

      Workaround

      No workaround available.

      Attachments

        Issue Links

          Activity

            People

              dguimbellot@atlassian.com David Guimbellot
              121fc1e6b3d8 Andre Deme
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync