I am trying to query on history object. I want to query records which have specific old value on Lead Status Field.
I have already checked Field can not be filtered in SOQL query call
It is anytype datatype not text area as shown in Image.
Expected SOQL Query is (Query Editor):
SELECT OldValue,Id, LeadId, CreatedDate FROM LeadHistory Where Field='Status' AND OldValue = 'New'
[object Object]: LeadHistory Where Field='Status' AND OldValue = 'New' ^ ERROR at Row:1:Column:84 field 'OldValue' can not be filtered in query call