-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
None
-
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
- 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}
- relates to
-
PS-178877 You do not have permission to view this issue
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[JIRAALIGN-8059] Date Created column for Themes in Enterprise Insights is not being updated
The work around provided 'use fact_audit_detail' is not an available column in our instance of AA. I do see 'Theme Fact Valid From' in the 'Theme History' table however, when I select this column along with the Theme ID, I'm getting a history of all dates recorded in the audit log. We are currently developing a process for teams to address data hygiene issues directly in Jira Align but not having access to the date created of the Theme is impacting our ability to determine where data hygiene issues exist.
Anything you can do to address this issue is greatly appreciated.
Thank you,
Susan Gordon
Hello Susan.
Another workaround would be to run the following query for the Theme ID you need the information.
query select min([Date Audit Event]) from current_dw.[Theme Log] where [FK Theme ID] = {id}Please let me know if you have any questions.