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:
96
questions
0
votes
1
answer
69
views
Querying History Object in update trigger, not showing the new History Object record?
I have a custom object (TestObject1__c) wherein I am tracking some field changes. I also have related list under this object (TestObject1__History). The problem is the trigger I created isn't querying ...
0
votes
1
answer
68
views
Batch Class Test with History Object to Production problem
I'm a new salesforce developer, and i'm facin my first real world problem in my company.
We have a custom object named "Solicitudes__c", is the detail side of a master relationship of ...
0
votes
1
answer
64
views
ObjectHistory sort is not working correctly (UI as well as in SOQL)
Hoping someone has in idea into what is going wrong with history object record entry and sorting. Here is the soql query i'm running:
SELECT Id,Field,OldValue,NewValue, CreatedDate FROM "...
- 27
0
votes
0
answers
187
views
How to get Sales Cloud field tracking data into Marketing Cloud?
The problem: we want to have a journey that triggers on leads getting a certain status. All leads that currently already have that status, should not be submitted to the journey. So we thought: just ...
- 3,848
-1
votes
1
answer
305
views
how to see previous value of a field in salesforce edited by mistake
I edited by mistake the value of a field. The track history of the custom object isn't enable.
Can i do something to see the the old value? Maybe with a query.
1
vote
1
answer
98
views
Is there a way to differentiate user from user-initiated systematic field value changes in field history?
I'm working in an org that is highly regulated and has multiple systematic field changes that happen as a result of a user making a single field change.
For example, when an opportunity stage switches ...
- 2,039
0
votes
1
answer
231
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
895
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
143
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 ...
- 27
1
vote
0
answers
133
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 ...
- 11
0
votes
2
answers
1k
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
325
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 ...
2
votes
0
answers
937
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,068
0
votes
2
answers
1k
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
732
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 ...
- 815
1
vote
1
answer
215
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 , ...
- 27
0
votes
2
answers
561
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
766
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 ...
- 69.1k
3
votes
0
answers
1k
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/...
- 577
1
vote
1
answer
108
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
257
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 ...
- 3
1
vote
1
answer
288
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,692
0
votes
2
answers
484
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
2k
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,135
1
vote
0
answers
250
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 ...
- 445
0
votes
1
answer
224
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,836
1
vote
1
answer
900
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 ...
- 397
2
votes
0
answers
1k
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 ...
- 111
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
285
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,135
4
votes
0
answers
401
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 ...
- 69.1k
2
votes
1
answer
1k
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 ...
- 4,202
2
votes
1
answer
993
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,395
2
votes
0
answers
150
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:...
- 69.1k
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 ...
- 711
1
vote
1
answer
113
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, ...
- 651
4
votes
1
answer
3k
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 ...
- 69
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 ...
- 179
3
votes
2
answers
866
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
261
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 ...
- 99
1
vote
1
answer
672
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 ...
- 4,897
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.
- 3
0
votes
1
answer
556
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
431
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 ...
- 2,039
0
votes
2
answers
6k
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 ...
- 944
2
votes
3
answers
3k
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,...
- 303
-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 ...
- 65
0
votes
0
answers
99
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,684
1
vote
1
answer
75
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 ...
- 511
1
vote
0
answers
379
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 ...
- 12.3k