2

I want to track the fields History that getting changed. i want the report that provide the old value of any field and also new value of that field. Lets i want to track the keyword custom field. if changed the keyword than it will show the new value and also its old value.

3 Answers 3

7

The history reports provide this functionality - if you enable field tracking for a standard/custom object (e.g. Case) then when you create a report you can choose the type 'Case History'. This will show who made the edit, when the edit was made, the name of the field and its old and new value. The only caveats to this that I'm aware of are:

(1) You can only report on fields that you have turned on history tracking for

(2) large text area fields don't have the old/new values retained, so those appear as '-'.

(3) You can't report on the change history of custom objects that are the detail in a master-detail relationship.

3
  • We need to track long area text fields and obviously this is not possible in Salesforce. The 255 character text fields are not long enough and we need to be able to report on whether the initial requirement has changed, therefore need a full history of the long text field. Has anyone come across this problem and if so, do you have a solution? Commented Oct 16, 2012 at 9:14
  • My solution below would solve that problem. Commented Oct 16, 2012 at 9:23
  • Steve's solution is exactly what I've used in the past for customers with this requirement. It does mean you need to apply changes twice - once to the real object and once to the shadow. If you have a lot of churn on your records you can quickly consume a lot of data storage space also. Commented Oct 16, 2012 at 10:46
3

I might be going out on a limb here, but I don't believe you can't use field history tracking in the way you described.

I would suggest keeping a 'shadow' custom object and use a before trigger to back up the fields to the shadow object. Then you should be able to write a report that uses both objects/sets of fields.

If you report requirements are slightly more complex however, you may need to write a VF page to do the appropriate 'report' generation.

6
  • ya i already used field history tracking and than i made the report but it only gave true and false value in report old and new value section fields. Commented Oct 16, 2012 at 5:23
  • Were you tracking a boolean field? Commented Oct 16, 2012 at 8:42
  • This does look like an over kill
    – Saariko
    Commented Oct 16, 2012 at 9:00
  • 1
    some fields don't have the old/new values retained,so those appear sometimes true or false. like check box. Commented Oct 16, 2012 at 9:17
  • 1
    ya.. but We need to track long area text fields and obviously this is not possible in Salesforce. The 255 character text fields are not long enough and we need to be able to report on whether the initial requirement has changed, therefore need a full history of the long text field. Has anyone come across this problem and if so, do you have a solution? Commented Oct 16, 2012 at 9:23
-1

Use New APp Which is Native.

Very Helpful for the Mater Detail History tracking on Custom Object. Which is not available. Report can be exported in PDF and Excel Formate

https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000Ex0LHUAZ

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .