-
Bug
-
Resolution: Fixed
-
Low
-
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 Loading...