function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Sam KamenskySam Kamensky 

Is there a bug on the when querying the FieldHistoryArchive table?


The FieldHistoryArchive table is neither available from dataloader nor
So I had to go with Workbench on this one.

When querying the FieldHistoryArchive (whether you turn on include archived records or not), your query result will only show certain fields of the query based off of the other fields that were included in your query.
Additionally, it seems that workbench cannot resolve the field names for NewValue and OldValue.

For example, and my use case, when I use this query:
SELECT Id,NewValue,OldValue,ParentId FROM FieldHistoryArchive

My columns in the result are
Id    Unknown_Field__1    Unknown_Field__2    ParentId

and the data from the query successfully displays.

However if I use the query:
SELECT Field,Id,NewValue,OldValue,ParentId FROM FieldHistoryArchive

My columns in the result are
Field    Id    ParentId

and the OldValue and NewValue are skipped completely!

Is this a bug?