Query OldValue & NewValue on OpportunityFieldHistory

Question

Hello,

I'm trying to filter NewValue and OldValue on OpportunityFieldHistory and am getting an error on the Query Editor.

Here's my statement: Select Id, CreatedById, CreatedDate, Field, NewValue, OldValue from OpportunityFieldHistory Where Field = 'StageName' AND CreatedDate = Last_Month AND OldValue !='Owned Lead' AND NewValue='Owned Lead'

Error Message: [object Object]: AND CreatedDate = Last_Month AND OldValue !='Owned Lead' AND NewValue='Owned ^ ERROR at Row:1:Column:152 field 'OldValue' can not be filtered in a query call

Any ideas anyone?

Thanks,

Hieu

Rajamohan Vakati · Accepted Answer

You cannot able to use OldValue and NewValue in where clause OpportunityFieldHistory object. Please refer this link

https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_opportunityfieldhistory.htm

Use below Query to get the data and Filter it by using Apex code

Select Id, CreatedById, CreatedDate, Field, NewValue, OldValue from OpportunityFieldHistory Where Field = 'StageName' AND CreatedDate = Last_Month

Query OldValue & NewValue on OpportunityFieldHistory

Apex

Aprendizaje relacionado

Más ayuda