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

Date Created column for Themes in Enterprise Insights is not being updated

XMLWordPrintable

    • 1
    • Severity 3 - Minor
    • No

      Issue Summary

      The `current_dw.Theme` view seems to be getting the Date Created from the audit log of Theme, `fact_Audit_Detail`

      Steps to Reproduce

      1. The issue was found by Development team after DoS investigation.

      Expected Results

      We expect to have the EI Date created column for Theme updated based on the same data we have in Jira Align database.

      Actual Results

      Instead the EI is updating Date Created from the audit log of Theme, `fact_Audit_Detail`

      Workaround

      Get the information from the fact_Audit_Detail view.

      Run the following query and get the oldest

      query select min([Date Audit Event]) from current_dw.[Theme Log]
      where [FK Theme ID] = {id} 

              942a0c021598 Melissa Hartsock
              121fc1e6b3d8 Andre Deme
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: