2 Replies Latest reply: Mar 7, 2013 3:03 PM by Jonathan Love RSS

    Load all records where they ever existed in a specific state

    Jonathan Love

      I have a history qvd that tracks changes to a record.  Record_Id 1 for example has 3 history records associated to it, in two of those history records the status was "Escalated" and in the other the status was something other than "Escalated"  I want to load all 3 records for record_id 1 because at some point its status was "escalated"  All I seem to be able to get is ONLY the escalated records.  If a record_id was never in a status "escalated", I do not want to load it all.  In the example below, I would get 6 records returned, all of record_id 1 and 3

       

      Capture.PNG

       

       

      Please see attached and thanks very much.