Advanced Reporting reports for Workflow data fetch all the / duplicate records despite setting the date options to current date.
The requirement is to get the latest / current record for particular transactions
Advanced Reporting, Realms, Workflow Information
Reproducing the Issue
Navigate to Advanced Reporting.
Enter the Workflow Management view in Realms and drag the object to the canvas.
Set the date option to Current Date and check the results.
Modify the date options to other criteria and result set remain the same and displays all data.
Workflow Steps comments field causes the duplicates to appear in the report.
Adding the 'Workflow Steps comments' field from Workflow Steps Workflow Wf request comments table introduces duplicate records.
If the Workflow Comments are not required for the actual report, the 'Workflow Steps Workflow Wf request comments' should not be added to the report.
If the table is required, the 'Workflow Steps comments' field should be added to the result list (e.g. 'comment'),
Please be aware that each table which contributes to the query with multiple records will result in a multiplication of all other records (A * B * C * ...)
To reduce the number multiplied results, apply filter on the Action Type = "COMMENT".
This filter should be designed as 'restriction' (if it would be a 'regular' query filter this would suppress all WF steps which don't contain any comment).
Use the 'Edit Restrictions' option from the 'Workflow Steps Workflow Wf request comments' table
This has been applied to our EC standard reports.
Also, Workflow table within Advanced Reporting does not follow any effective dating and displays all current records irrespective of the date option defined.
This is an expected behavior.
Realms, Workflow, Advanced Reporting, Duplicates , KBA , LOD-SF-ANA-ODS , Advanced Reporting , Problem