Questions tagged [field-history]

You can select certain fields to track, and display the field history in the History related list of an object. You can track the field history of custom objects, as well as the history of the following standard objects:

Filter by
Sorted by
Tagged with
0 votes
1 answer
33 views

Field Audit Trail not populating changes

I have added the field audit trail component to a lightning page and enabled history tracking on the object and relevant field, however field history isn't showing up on the related tab (the grid ...
0 votes
1 answer
76 views

What is the best practice for cleaning up unused fields or fields that haven't been used in a long time? [duplicate]

I have been tasked with cleaning up fields across our org that are not in use or haven't been used in some time period. For each field of an object, I want to know when the last time its value was ...
  • 1
1 vote
0 answers
52 views

I am see records before 18 months without field audit trail in salesforce?

I am a little confused with salesforce documentation here: https://a.sfdcstatic.com/content/dam/www/ocms/assets/pdf/misc/Platform_FieldAuditTrail_Datasheet.pdf. As per the link, standard Field History ...
1 vote
0 answers
38 views

Using a package to deploy a change removed field tracking on custom field

One of our engineers deployed a change to Salesforce using the package system - namely a new field on the Lead object. However, a field that was part of the same package on the account object: CSM ...
0 votes
1 answer
278 views

Flow based on an Objects History

Is it possible to build a flow based on an objects history. For instance, if I wanted a fields to update whenever another field is changed by one specific user. How would I go about this I cannot seem ...
0 votes
2 answers
186 views

How to track formula field which is related with different objects?

I have one formula field on Opportunity which is the calculation of the Revenue from the SubscriptionFee__c object + Rate from the Rate__c object. In Opportunity, we want to track the history of this ...
1 vote
0 answers
475 views

SFDX not pulling field history tracking for Person Account (__pc fields)

Enabling Person Account creates these fields ending with "__pc" in their API name. That happens when we create a contact field - Salesforce automatically creates the __pc equivalent of the ...
  • 1,023
0 votes
2 answers
503 views

User Info on Case History

I am trying to pull the user (person who made the change) via SOQL query on cases. This is not a "standard" field in the API Developers guide for CaseHistory but it is available for standard ...
1 vote
1 answer
181 views

Field History prior to enabling History Tracking

'Salesforce starts tracking field history from the date and time that you enable it on a field. Changes made before this date and time aren’t included and didn’t create an entry in the History related ...
1 vote
1 answer
125 views

How can i retrieve how many time a field with datatype (Lookup / Long Text Area ) being changed using SOQL on Case History?

Using this Soql : SELECT count(case.subject) FROM CaseHistory where field ='subject' i was able to retrieve number of time Subject field has changed Since we can not filter by OldValue / NewValue , ...
  • 29
0 votes
2 answers
123 views

How to get all the past values of a field in salesforce? [closed]

I want to write a trigger on opportunity and whenever opportunity stage is updated to Closed Won, check if the stage was updated to Closed Won in the past. If stage was updated to Closed Won in past, ...
1 vote
1 answer
310 views

Filters may not have any gaps within the composite key querying FieldHistoryArchive

Given this query: SELECT Id FROM FieldHistoryArchive WHERE FieldHistoryType = :fhType AND parentId = :parentIds ORDER BY Id LIMIT 10 I get the runtime error: Filters may not have any ...
  • 63.8k
3 votes
0 answers
596 views

Are Standard Field History Tracking deployable through SFDX?

My Standard field (Account) on a Standard object (Asset) looks like this: <?xml version="1.0" encoding="UTF-8"?> <CustomField xmlns="http://soap.sforce.com/2006/04/...
1 vote
1 answer
78 views

Apex SOQL All Distinct Histories of a Field?

I am trying to query every state of Transaction_Property__c where the field Status__c is distinct. I've tried the following but it only gives me the latest record and not all versions. List<...
  • 153
0 votes
1 answer
135 views

How to test a batch that executes based on CaseHistory records? [duplicate]

I have written a batch class that updates a field on Case object with the owner name which is assigned by Case assignment rule. When I try to test this batch class, a part of the code which runs after ...
1 vote
1 answer
159 views

Updating fields under history tracking through unlocked package release

We have one unlocked package that originally had some fields under history tracking and was released in production correctly. After a while we decided to add some more fields under history tracking, ...
  • 1,642
0 votes
2 answers
282 views

Field History Tracking on BillingAddress which is null

I need to do Field History Tracking on BillingCountryCode and BillingPostalCode on Account. I only can chose the field BillingAddress in the Tracking setup. But whereas BillingCountryCode and ...
2 votes
1 answer
926 views

Field History Tracking - control access to history?

re: the Field History Tracking feature, which you can turn on for specific objects and then specific fields within those objects: Is there any way to control access to the Field History? Apart from ...
  • 1,100
1 vote
0 answers
135 views

Field History Tracking for Territory Field on Opportunity object

I want to enable field history tracking for Territory field (API Name Territory2) on Opportunity Object. However on field history tracking page, I cannot find that field, so I am not really sure if ...
0 votes
1 answer
77 views

How to query on trackhistory property of an object?

I am attempting to produce a report which would show all of the objects which have Field Tracking History enabled, as well as the fields which are been tracked. I see here that it is a property : ...
  • 3,760
1 vote
1 answer
581 views

History objects values for Lookup fields

When you track a lookup field, the old and new values are ids. Is there any way to find out what the name of the lookup object is from that id on the history object? Trying to avoid having to get ...
1 vote
0 answers
527 views

Easy way to tell what has field history tracking enabled

I am looking for an easy way to verify what all has field history tracking enabled(and their retention policies). I was able to find this SOQL query SELECT QualifiedApiName FROM FieldDefinition ...
0 votes
1 answer
1k views

Custom related list Lightning component for History table related list - delay in fetching

I created a Custom related list (Component A) that fetches history table and displays. It has a button to refresh the history list. In the same page, I have another lightning component (Component B) ...
0 votes
2 answers
200 views

ContentVersionHistory does not record NewValue

As per this Salesforce article: history tracking on ContentVersion description field records NewValue only field history for the Content is only available by querying the object ...
  • 3,595
4 votes
0 answers
279 views

Why is Account.Name represented in AccountHistory.Field as TextName and not Name?

Given Enable field history tracking on Name fields: Account.Name, Opportunity.Name, and CustomObject__c.Name Create a new Account, Opportunity, and CustomObject__c providing a value Original. Change ...
  • 63.8k
2 votes
1 answer
531 views

Can I turn off read access to field history for some users?

All users should be able to see Cases, generally. Some of my users should see CaseHistory on the Case layout, and some (same profile) shouldn't. Is there any way to remove View permissions on ...
2 votes
1 answer
658 views

How to track Account Description field changes in Field history Tracking?

I'm trying to track history of Account Description field. Related list just shows it has changed, but seems no value changes being tracked. Tried to query using SOQL, but it doesn't give any value ...
2 votes
0 answers
113 views

Field History object - value of column "Field" when tracked field is lookup (standard v custom)

I'm trying to selectively delete an SObject's field histories based on the members of an sobject's fieldset (think PII deletion - feature available V42). Example: OOTB Order with field set containing:...
  • 63.8k
1 vote
0 answers
16 views

Having trouble accessing updated Contact.Histories in unit test [duplicate]

I have a custom object to manage patient (Contact) status changes, which affect product shipments. I'm adding a process to roll back changes based on receiving a cancelled form, based on a common ...
1 vote
1 answer
81 views

Use Field History Reports For Daily Values When No Change Occurrs

I'm trying to use Field History reporting to provide daily, weekly, monthly counts of a field for a record which gets updated every day but the field in question may not get updated the whole time, ...
4 votes
1 answer
2k views

Are there any limits on field history tracking?

If I have a record that is updated every 5 minutes, and I have field history enabled on the field changing, will I run into any field history tracking limits? Ex. Does Salesforce only store X number ...
2 votes
1 answer
1k views

How to query on tracked field data?

I would like to know how I can query on tracked fields in all objects? I have org with 50 objects that have tracked fields. Now I wanted to know how much data used as tracking history for particular ...
  • 139
3 votes
2 answers
580 views

Deleting ActivityHistory and FieldHistoryArchive

I Am trying to delete both ActivityHistory and FieldHistory archive but have run into the below errors: DML operation Delete not allowed on List<ActivityHistory> DML requires SObject or ...
  • 31
-1 votes
1 answer
237 views

How to show Knowledge article list History in Search Bar [closed]

I have created list of Knowledge articles in articles management standard object. i need to show that articles list in search bar when i am searching for related questions/data that time i need to ...
1 vote
1 answer
397 views

Account history does not show Created event

For some reason, the accounts that are created by our custom form on our Lightning Community does not show the "Created" entry on the Account History section. It shows the account was created by the ...
0 votes
1 answer
1k views

Does Salesforce Shield Field Audit trail allow field history tracking on detail objects in master details [closed]

Need to know about field audit trail, Salesforce shield.
0 votes
1 answer
490 views

Custom field history tracking on partial update?

I would like to track more than 20 fields on my custom objects, so built a logic almost same as What is the best workaround for the 20 field history tracking cap?. This works most of the time if you ...
  • 5
1 vote
1 answer
393 views

Tracking Address Changes - 10+ Years

I am reviewing a request to track changes performed on the address field and some other custom fields on the contact object for long periods of time. I have evaluated Field Tracking History and Field ...
  • 1,899
0 votes
2 answers
4k views

Can't track changes on a Rich Text Area field with Field History Tracking enabled

I have a scenario, where I would like to track the changes on a Rich Text Area field. Step 1 After enabling the field history tracking on the Opportunity(that is my target object), I check the ...
2 votes
3 answers
2k views

Tracking History of changes in Custom fields of custom objects

I want to track the history of 5 fields in custom object. I have selected the Track History checkbox against the corresponding fields in Custom Fields & Relationships section of the object.Still,...
-2 votes
1 answer
1k views

Edit stage history fields

In lightning I need a way to custom the 'stage history' fields. The stage history present the 'amount' field, and I need to replace it with 'other_custom_opportunity_amount'. I can't locate the ...
  • 55
0 votes
0 answers
66 views

When are history records created

Two types of transactions work on a set of records. First type selects records that don't have a flag set and sets it. The second transaction selects those records that have a flag set and removes the ...
  • 3,625
1 vote
1 answer
74 views

Field History tracking analysis

I am trying to provide some analysis to identify how times in a given time frame the account key fields changes. I know that there is a native sfdc report that provides you that information, however ...
  • 501
1 vote
0 answers
267 views

Is it possible to use history tracking with object fields in a report?

For example, record has a number field with a value that can vary a lot, and I want the history of that field on my report. The object is related to the Account and Product objects, so I'd like to ...
9 votes
4 answers
4k views

Field history tracking - data retention

The field history is important to our organisation and I need to retain it indefinitely. According to the field history tracking documentation, the field history is automatically deleted after 18 ...
  • 2,753
0 votes
1 answer
1k views

History tracking of object

I have custom object on which history traking in enabled on number of fields. How can at run time i can get number of fields in objects on which history tracking in enabled from apex soql
  • 1,275
2 votes
1 answer
323 views

Can the tooling API turn off field tracking history?

Can the tooling API turn off/on field tracking history? Seeing as we can't delete history record I want to be able to turn it off before a process runs to prevent history records being created. The ...
  • 5,215
1 vote
1 answer
121 views

History tracking

What's the difference between Field History Tracking, which needs to be activated and works only for 20 fields per object and History tables like AccountHistory, CustomObject__History ? Why would I ...
1 vote
1 answer
130 views

Is the query on object history slower than the query on the object itself?

The object which has the history tracking enabled in my organization is being modified 3 to 4 times a day, so we end up with 112 history records per month. I have a page that queries the history and ...
1 vote
0 answers
76 views

Object Feed Tab Default - Details Tab Instead - Chatter Feed Tracking

Does unchecking "Enable Feed Tracking" effectively make it so when you visit a record on (example) Account, it now defaults to the DETAILS tab instead of the FEED tab? Where:   Setup >> Chatter >...
  • 4,594