6 Replies Latest reply on Aug 7, 2015 5:31 AM by DPatel

    How to create a query of historical status - Example


      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?