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
Kristin FKristin F 

Help with SOQL query for FileExporter

I am using FileExporter (https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003Iz0jEAC) to export attachments from an org.  I need some help with a SOQL query because I do not want to download all attachments (this is the default).  My goal is to specify a set of parent IDs from which it will download all related attachments.

I have a SOQL query that works to download all attachments from a single ParentID (see below), but to save myself some time I would like to figure out how to specify multiple ParentIDs in the same query.

Can someone advise on the correct syntax for specifying multiple ParentIDs that will download all related attachments?  The ParentIDs may be from a cross-section of objects (i.e. account, contact, custom object).

<!ENTITY whereClause "ParentId = 'a00P0000002IwZ3IAO'">


Best Answer chosen by Kristin F
James LoghryJames Loghry
Try using the "IN" keyword.  For example:
<!ENTITY whereClause "ParentId in ('a00P0000002IwZ3IAO','id2')">

All Answers

James LoghryJames Loghry
Try using the "IN" keyword.  For example:
<!ENTITY whereClause "ParentId in ('a00P0000002IwZ3IAO','id2')">


This was selected as the best answer
Kristin FKristin F
Success!  Thank you James!