Previous and Current values for a shift, crew, rotation begins
Summary
Due to Covid-19 we have had to introduce new shifts for our job sites. Need to report both current and previous values for auditingContent
I have been tasked with creating a report that shows previous and current values for SHIFT(****_ATTRIBUTE9), Crew (****_ATTRIBUTE2) and Rotation Begins (****_ATTRIBUTE1).
I was able to piggy back on a report that was designed for us some time ago and managed to get the current and previous values of SHIFT (****_ATTRIBUTE9) to display; however we found an employee that had an update and a correction on the same date.
I am not sure if it is possible, but I would want to see the Previous value from the Update record and the current value from the Correction record (I have attached a sample showing the issue)