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

XMLWordPrintable

      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} 

            Assignee:
            Melissa Hartsock
            Reporter:
            Andre Deme
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: