History Tracking Filter out related list ID

  • 2
  • Question
  • Updated 6 years ago
  • Answered
I need to show tracking history in one of my Skuid pages. I have a client and I track what geographic area they are in and what house they are in. I know from reading other posts that Salesforce has not given access to the "Pretty view" that just says in a sentence what was changed.

My issue is that it shows the ID associated with the change as well which clutters the view and doesn't mean anything to anyone.
For Example:
2/2/2014 2:01 am John Doe Cedar City Provo Rich Slack
2/2/2014 2:01 am John Doe a02G000000BZ6iDIAT a02G000000BZ6lwIAD Rich Slack

Is there a way to filter out line 2 that shows the a02G......?

Thank you!
Photo of Rich Slack

Rich Slack

  • 4,476 Points 4k badge 2x thumb

Posted 6 years ago

  • 2
Photo of John Nelson

John Nelson, Product Manager

  • 3,508 Points 3k badge 2x thumb
Official Response
Rich, it looks like we're kind of stuck here. The reason these values are showing the way they are is because, as you've gathered, they're look up fields and the history shows both the name and id of the new and old values. Unfortunately, Salesforce limits what we're able to do with those fields. We're not to filter on them at all. Lame, I know, but even in raw SOQL it won't let us do it.