We have had a recent audit and the auditor has requested a report of all changes that have ever been sent for CAB Approval.
I would like to be able to run a query that shows me all changes that have at some point in its lifecycle had the status: CAB Approval to fulfil his request. I can run a query that shows me anything currently at the Status CAB approval but not for anything that has ever had that status.
I thought i could do it via the criteria part but none of the conditions fulfill my requirement. A condition of was equal to or something like that would do the trick but isn't there.
Can anyone help me please?