You need to sign in to do that
Don't have an account?
billkat
SOQL / data loader, query Long Text Area for NULL or ''
I'm trying to extract records from Contacts, where a custom field is populated.
i.e. I'm wanting to do an equivalent of SQLs WHERE LENGTH(field) > 0
The field is a Long Text Area of 1000 chars.
I've tried WHERE field='' and various other things, but Data Loader tells me the field can't be filtered on ...Am I just getting syntax wrong or can I really not filter on a text area field? That seems odd so guessing my syntax is duff.
Any guidance would be much appreciated.
We don't allow filtering on long text area fields. Can you use a regular text or text area field (i.e. how big is your filterable data actually going to get?)?
Can't change the field, but got round it via Reports, using a filter there.