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
sushieatersushieater 

soql filter by file field

Trying to query an article type using soql. I'd like to return a list of all articles of that type that have a custom file field that is not null.

 

Anyone have any hints how to do this?

 

The field is named Documentation_link__c in the article type customization screen. I try to filter by that fieldname, but I get an error saying the field name does not exist.

 

Looking at the schema explorer, I see that the field is broken down into Documentation_Link__Name__s, Documentation_Link__Length__s, Documentation_Link__ContentType__s 

 

Unfourtunately, if I try to filter by any of those field, I get an error saying , "field X can not be filtered in a query call".

 

Thanks

Ankit AroraAnkit Arora

Can you please share the exact Label , API name and type of fields.

 

You can't have a long area text field (including rich text area) in a SOQL Where clause.

 

 

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page