You need to sign in to do that
Don't have an account?
Manohar kumar
prior values of a field
Hi All, i need to track a custom field fee on a case object.My goal is when i click on this fee it should disply the all previous values and the user who changged it.I enable the chatter feed for this field.What object do i have to query to get the details.How can i do this?Any help would be appreciated.
Thanks,
Manohar
For the use case mentioned above a field history tracking might be a better approach. Once you have enabled field tracking on the object you can see the changes in the related list. If you have a specific requirement around mining that information you can query the objects history table.
The naming of these tables follows a simple convention so should be easy to find. For standard objects the name of the history table follows the format: 'ObjectNameHistory' so for the Account object the history table is AccountHistory
For custom objects the name of the convention simply replaces the 'c' on the end of the API name with 'History'. So, for a custom object call My_Custom_Object__c the history table is called My_Custom_Object__History
Hi Prateek thnaks for your reply.I am seeing a object called caseHistory.But their fields(newValue and oldValue) are coming empty for my caseId.Can you tell me which fields should contain the value? I am new to salesforce.Thanks in advance
Thanks,
Manohar
The fields newValue and oldValue will contain the values, but first you need to set the field tracking on the fields you want. Also please note that this will start tracking once you have enabled the history tracking, anything changed in past will not be available.
For steps on how to enable field history tracking visit the following links
https://help.salesforce.com/apex/HTViewHelpDoc?id=tracking_field_history_for_standard_objects.htm&language=en_US
https://help.salesforce.com/apex/HTViewHelpDoc?id=tracking_field_history_for_custom_objects.htm&language=en_US