Conditions on 'Old Value' and 'New Value' on history object

  • 1
  • Problem
  • Updated 2 years ago
I have history enabled on an object and have a model pulling from that history object. I am able to successfully run conditions on the 'ParentId' and 'Field' fields, but conditions on 'OldValue' and 'NewValue' are not working. I'm not sure if this is because the field type for these is 'ANYTYPE'. I tried overriding the meta data to be string, and still was not able to run a condition on those two fields.

My end goal is to be able to see when a boolean field changes to 'true', who changed it and when. My first thought was to use the history object to do this. I realize I could write a trigger and record to a custom field or object, but would like to avoid that for simplicity if possible.

Anyone else experience similar issues?

I'm on Skuid 8.15.9 - I have not tried this on other Skuid versions.
Photo of Craig Rosenbaum

Craig Rosenbaum

  • 4,776 Points 4k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Craig.   Unfortunately according to the salesforce docs for the field history object,  the OldValue and NewValue fields are not filterable.  See here: https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_fieldhistoryarchiv...

I don't think you are going to have any luck here . Sorry. 
Photo of Craig Rosenbaum

Craig Rosenbaum

  • 4,776 Points 4k badge 2x thumb
Thanks for the response Rob  I didn't think to check the Salesforce side of it. I ended up using a trigger to write some values to a custom field which works just fine.