You need to sign in to do that
Don't have an account?
Opportunity Field History - Query error on a field that exists in the WSDL
I'm trying to get a list of field histories for an Opportunity, including who made the change and when. I see the CreatedBy and CreatedDate fields for the OpportunityFieldHistory entity in my WSDL, and therefore I can also see the properties in my generated Salesforce domain. However, when I try to specify them as fields to select on or filter by in the query, I get an INVALID_FIELD error that the table doesn't have these fields. The documentation for this table does not include the fields. The remaining info is useless to me and my users without these two fields. My WSDL was generated against version 20.0 of the API. What's going on here?
Can you post your specific query, i was able to run this query fine.
The History Records are different sObjects as you can tell by Simon's query. You can use the WHERE clause to specify which field names you want to look at. Remember that the field names aren't the labels. I'm not sure if the field names contain the namespace. But if you look at the results of Simon's query you'll see the format of the names.