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
ykovarskiyykovarskiy 

Accessing LongTextArea fields

Is there any way to query data in LongTextArea fields (such Description field in Account entity)?
 
Specifically, I would like to know whether ceratin accounts contain more than certain number of characters in that field.
 
Thanks.
adamgadamg
Those fields are available just like any other via the API, the exception is that you cannot use the "like" operator for wildcard queries.  The "like" operator seems like what you need to use to do what you wish, but...

Message Edited by DevAngel on 11-13-2006 09:33 AM
Yuriy KovarskiyYuriy Kovarskiy

Thanks for your reply.

1) Is it possible to use char_length or length operator in a query?

2) Is there a third party tool that would allow me to perform such query against my data in Salesforce?