Inconsistent Status values in the Atlassian Data Lake

XMLWordPrintable

    • Minor

      Issue Summary

      The Status column in the Jira Issue table occasionally has an incorrect status value displayed in the Atlassian Data Lake. The incorrect status of the issue appears to be a past status, but not the current status of the issue. 

      This behavior appears to be happening randomly, so some issues might have the correct value in the Status column. 

      Steps to Reproduce

      1. Query the Status and Issue key columns from the Jira Issue table. 
      2. Open the issue in Jira
      3. Compare the status values in Jira and the Atlassian Data Lake 

      Expected Results

      The Status column's values to match the status of an issue in Jira. 

      Actual Results

      The value of the Status column does not always match the status of the issue in Jira. 

      Workaround

      Query the Value (string) column from the Issue History table to capture the current status value. Include two query filters using columns from the Issue History table: Field name = 'Status' and Ended At is null. The two filters will ensure the current status is associated with the issue in Atlassian Analytics. 

            Assignee:
            Tracy Chow
            Reporter:
            Jessie Turpin (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: