There are some fields in Salesforce that are of the datatype “anyType” . An example of this are the New/OldValue fields on the AccountHistory Object in Salesforce.
While you can report on these fields, you are not able to use them as filters despite them showing up as text fields. Instead, they appear to function more as Rich Text.
Continuing this example, the object also includes a DataType picklist, so you can restrict the records being shown to only include entries where the anyType = String.
Use Case: Gainsight has yet to roll out any meaningful OOB history tracking, and while you can use Real Time Rules and custom change tables, duplicating the entire process in Gainsight is not particularly realistic nor as reliable. It would also be a massive redundancy. It would be great to just be able to pull in AccountHistory reporting and be able to filter on these New/OldValue fields, even if it is limited to when the data is certain datatypes.
You might be able to get around this by creating a Data Design and a transformation step, but it would be ideal not to have to duplicate data in the first place.
Credit to
