I am querying in the Workbench with SOQL.
I need to query a history object to a custom field, but I want to see changes only to a certain field. What is the syntax to say
WHERE Field = MyTargetField ?
I tried this:
SELECT Field, NewValue, OldValue FROM MyCustomObject__History WHERE Field = myTargetField__c
but this generates an error:
WHERE Field = myTargetField__c
ERROR at Row:3:Column:14
Bind variables only allowed in Apex code