Duplicate records are generating in timecard reported entries.

Summary:

Report was working perfectly fine earlier and now producing duplicate rows in the table.

Content (please ensure you mask any confidential information):

Requirement

This report is used to identify the number of times a timecard is amended and the detailed amendments that were made to the time entries on any changes after the 1st approval. It will provide the amendment details, amendment date and user making the amendment. The report captures changes in felids like TIMECODE_NAME, Calculation Timecard start date, MEASURE, comments, costing override (custom timecard field) etc.

Also, we need to capture only those changes which are after first approval of the timecard. Hence if the latest timecard is not approved then fetch all changes from first approval.