RecentFieldChange
Supported Calls
describeSObjects(), query()
Special Access Rules
Fields
Field | Details |
---|---|
ChangeDate |
|
CurrencyIsoCode |
|
FieldName |
|
ParentId |
|
PreviousCurrencyValue |
|
PreviousDateOnlyValue |
|
PreviousTextValue |
|
ValueChangedById |
|
Usage
One recentFieldChange record is returned for each field that was changed in the past seven days. The supported fields are Amount, Close Date, Forecast Category, Next Step, and Stage Name. Only the most recent previous value is returned.
Example
select PreviousTextValue from RecentFieldChange where ParentId = '006R0000003JkHBIA0' and FieldName = 'StageName'
If the sales rep didn't change the opportunity stage name in the past seven days, no values are returned. If the sales rep changed the opportunity amount several times in the past seven days, only the most recent previous value is returned.
Example
select PreviousTextValue, PreviousCurrencyValue, PreviousDateOnlyValue from RecentFieldChange where ParentId = '006R0000XXXXXXXXXX' and FieldName IN ('StageName', 'Amount', 'CloseDate')
If the opportunity amount, close date, forecast category, next step, and stage name didn’t change in the past seven days, no values are returned.