--- schema_version: "1" id: 4f32e5d9a6c29c178b66ac004ee522cedc36fd24a4d36aadfa9bdb4e286ddcdf title: RecentFieldChange collection: legacydeveloper version: current locale: en-us portal_url: https://docs.salesforce.com/legacydeveloper/current/en-us/object_reference/sforce_api_objects_recentfieldchange.md canonical_url: https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_recentfieldchange.htm source_site: developer.salesforce.com content_type: documentation content_hash: acfa88d66dba1366e2d571248ad368e5a6193c36f8f440fd44c32b92c34af748 description: Use this virtual object to see how an opportunity has changed in the past seven days. Learn the previous value of a field, who made the change, and when the change was made. This object is available in API version 52.0 and later. --- # RecentFieldChange Use this virtual object to see how an opportunity has changed in the past seven days. Learn the previous value of a field, who made the change, and when the change was made. This object is available in API version 52.0 and later. ## Supported Calls describeSObjects(), query() ## Special Access Rules To use RecentFieldChange, set up historical trend reporting for opportunities in your org. You must also have the Pipeline Inspection user permission and the Pipeline Inspection setting enabled. ## Fields | Field | Details | | --- | --- | | ChangeDate | Type dateTime Properties Description The date and time that the specified field was changed. | | CurrencyIsoCode | Type picklist Properties Defaulted on create, Filter, Group, Restricted picklist, Sort Description The ISO code for the currency value. Must be one of the valid alphabetic, three-letter currency ISO codes defined by the ISO 4217 standard, such as USD, GBP, or JPY. The default value is 'USD'. | | FieldName | Type string Properties Filter, Group Description The name of the opportunity field that you want the previous value of. Possible values are: - Amount - CloseDate - StageName - ForecastCategory - NextStep | | ParentId | Type reference Properties Filter, Group Description The ID of the opportunity that you want the change history for. This is a relationship field. Relationship Name Parent Relationship Type Lookup Refers To Opportunity | | PreviousCurrencyValue | Type currency Properties Nillable Description The previous value of a currency field on an opportunity. | | PreviousDateOnlyValue | Type date Properties Group, Nillable Description The previous value of a date field on an opportunity. | | PreviousTextValue | Type string Properties Group, Nillable Description The previous value of a text field on an opportunity. | | ValueChangedById | Type reference Properties Group Description The ID of the user who changed the specified field's value during the specified time period. This is a relationship field. Relationship Name ValueChangedBy Relationship Type Lookup Refers To User | ## 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 To see the most recent previous amount for an opportunity, use the following query. Replace 006R0000XXXXXXXXXX with the ID of the opportunity. 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 To see the most recent previous amount, close date, forecast category, next step, and stage name for an opportunity, use the following query. Replace 006R0000XXXXXXXXXX with the ID of the opportunity. 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.