function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
A G NagarajA G Nagaraj 

anytype apex types in reports formula field

Hi, I am unable to see the field OldValue & NewValue in the reports for putting in Formula field? These two fields are from history object and whose apex types are anytype.
AbhishekAbhishek (Salesforce Developers) 
Your query is answered here,

https://salesforce.stackexchange.com/questions/138606/is-it-possible-to-filter-off-old-value-or-new-value-in-a-history-report


If it helps you and close your query by marking it as the Best answer so that it can help others in the future.

Thanks.
Malika Pathak 9Malika Pathak 9
Hi A G Nagaraj,


There is currently no way to filter on Old Value/New Value. But I really like this idea.
Here is what Salesforce is proposing you :
Currently, there is no ability to filter on the Old Value or New Value in a history report, however there are 2 work arounds.
  • Use the Analytic Snapshot aka reporting snapshot and create the report off of the Target Object.
  • Please see "Prepare Reporting Snapshots" in Help and Training to learn how to setup up an Analytic Snapshot.
  • When you get to Step 3: Create fields on the target object, create two text fields called "Old Value" and the other "New Value".
  • After the snapshot has run, create a report off of the Target Object and then add a criteria for the "Old Value" and "New Value" into your new report.
NOTE: This only applies to new data and will not report on previous data. Also, 2000 records is the maximum returned per snapshot.
Export the report into Excel to filter on the Old Value or New Values.
https://help.salesforce.com/HTViewSolution?id=000005966&language=en_US

If it helps you and close your query by marking it as the Best answer so that it can help others in the future.
Deer altanDeer altan
I am unable to peer the sector OldValue & NewValue within the reviews for putting in Formula subject? These two fields are from history item and whose apex kinds are anytype for parimatch casino (https://parimatch-betting.in/casino/).
hgfdg gfdgfdhgfdg gfdgfd
Is this good idea to use the scirpt for filter features? I'm working for Bike Passion (https://bikespassion.com/) project and review the best bike. I want to add some filter options in my website.