Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Query history for field with "Track History" turned on

Is it possible to query the history for a custom field on a standard object on which we turned on Track History, preferably through SQL?

We have a custom field on the Opportunity object. It tracks the status of the opportunity. I want to find records that have been in a particular status at some point in their lifetime. They don't need to be in that status now. It seems the easiest way to do that would be to turn on history tracking for that field and query it but I don't know what to query.

1 person has
this question