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
2answers
28 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 ...
0
votes
0answers
14 views

History objects for currency fields in a mutli currency org

We are seeing that when we change an objects currency, on a multi currency org, all currency fields with existing values seem to get new history objects even though the fields values dont change. Is ...
1
vote
1answer
25 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
1answer
43 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 , ...
0
votes
2answers
23 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
1answer
54 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 ...
1
vote
0answers
107 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
1answer
56 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<...
0
votes
1answer
39 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
1answer
64 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, ...
0
votes
2answers
84 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
1answer
226 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
vote
0answers
67 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
1answer
39 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 : ...
0
votes
1answer
183 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
0answers
46 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
1answer
797 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
2answers
123 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 ...
4
votes
0answers
151 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 ...
2
votes
1answer
160 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
1answer
342 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
0answers
77 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:...
1
vote
0answers
15 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
1answer
37 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
1answer
1k 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
1answer
729 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 ...
3
votes
2answers
314 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 ...
-1
votes
1answer
198 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
1answer
229 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
1answer
946 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
1answer
270 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 ...
1
vote
1answer
307 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 ...
0
votes
2answers
3k 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
3answers
1k 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
1answer
824 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 ...
0
votes
0answers
34 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 ...
1
vote
1answer
64 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 ...
0
votes
0answers
142 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
4answers
3k 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 ...
0
votes
1answer
851 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
2
votes
1answer
258 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 ...
1
vote
1answer
103 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
1answer
89 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
0answers
62 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 >...
2
votes
2answers
466 views

How to Find History Tracking or Audit Log field in Custom object

I have a custom object and I have enabled the checkbox Tract Field History my question is, how can you show your tracking field histroy in Visualforce Page? I need a way to show the customer what has ...
3
votes
1answer
322 views

How can I add Custom Fields that I need to be included in Opportunity Field History when they are changed/updated?

Right now I have Budget fields, say Budget Field 1, 2, and 3. When I update these budget fields, Opportunity Field History does not capture the updated information that was input into these fields. ...
0
votes
1answer
379 views

Field History tracking limit

I know that we could track 20 standard and custom fields from custom objects. I thought we cannot track more than 20 fields per object. But in sandbox, i have a custom object where there are more ...
1
vote
1answer
117 views

How to get value of : First user who accepted the ownership of Lead from particular queue

In my sandbox when a new lead is created its assigned to a TCC queue. Then someone from TCC team queue will accept the ownership of queue. Now i want to see report of : who accepted how many Leads ...
2
votes
1answer
2k views

What is the difference between trackHistory and trackFeedHistory?

If we look at the XML for a specific Object and inspect a random field, there is both trackHistory and trackFeedHistory <fields> <fullName>AccountId</fullName> <trackHistory&...
0
votes
1answer
1k views

History tracking for Formula fields

Formula fields can't be enabled for history tracking. There's a workaround where a new date/time field has to be created for every formula field with formula as now() which would be updated via a ...