What is the Maximum Number of Characters that can be Queried in a Report?
|Knowledge Article Number||000170897|
|Description||Only the first 254 characters in a rich text area or a long text area field are able to be queried within in a report on Salesforce.
This means that it will only display up to 254 characters and it can only filter on the first 254 characters as well.
|Resolution||Standard Long Text Area fields have a limit of 999 characters when called on the report whereas Custom Long Text Area has a limit of 254 characters.
However, when Reports are exported as Excel or CSV files, then the field will display all the characters indicated in the field past the 254 / 999 character mark.