AnsweredAssumed Answered

Portal Filtering on latest record

Question asked by glorifindal on May 26, 2014
Latest reply on May 26, 2014 by 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

Outcomes