Apex Code Development You need to sign in to do that
Don't have an account?
Sam Kamensky Is there a bug on the when querying the FieldHistoryArchive table?
Background:
The FieldHistoryArchive table is neither available from dataloader nor dataloader.io
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:
My columns in the result are
and the data from the query successfully displays.
However if I use the query:
My columns in the result are
and the OldValue and NewValue are skipped completely!
Is this a bug?
The FieldHistoryArchive table is neither available from dataloader nor dataloader.io
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?