5 Replies Latest reply on May 26, 2014 12:27 PM by glorifindal

    Portal Filtering on latest record

    glorifindal

      Hi there,

       

      I have one portal - displaying field level audit data. I need a second portal.

      The first portal show this:

       

      Field NameOriginal ValueNew ValueTStampRational
      StatusOpenTDS-12326/05/2014 15:48:37Workshop
      In ProjectNoYes26/05/2014 14:29:41Steering Decision
      DepartmentAfterCareGroup26/05/2014 14:29:40Steering Decision
      In ProjectYesNo26/05/2014 13:45:32
      MethodDirectIndirect26/05/2014 13:41:09Email Instruction
      In ProjectTBCNo25/05/2014 13:41:09
      StatusOpenOK25/05/2014 13:27:44Email Instruction
      MethodNetworkingDirect25/05/2014 13:27:44

       

      The new portal needs to show this:

       

      Field NameOriginal ValueNew ValueTStampRational
      StatusOpenTDS-12326/05/2014 15:48:37Workshop
      In ProjectNoYes26/05/2014 14:29:41Steering Decision
      DepartmentAfterCareGroup26/05/2014 14:29:40Steering Decision
      MethodDirectIndirect26/05/2014 13:41:09Email Instruction

       

       

      The filter for the second portal is this:

       

      • Show only the most recent audit record for each field.
      • Show only records where Rationale data has been entered.

       

      Can anyone help me with this please?

       

      Many thanks in advance

       

      G