I tried to run this SOQL in Data Loader and got the error no nested queries.
SELECT Name, ID, (SELECT ID.Name FROM Notes WHERE FileExtension = 'gif') FROM Account
I am looking for the IDs of all GIFs that are attachments on Accounts.
I don't have to do this in Data Loader. I can use any tool to get this done. Any suggestions welcome.
PS Just figured out nested queries aren't allowed in Workbench either.
PSS You also can't use a SF report to create a report of Notes created via "Notes & Attachments" related list.
PSS to reiterate. I am looking for the Attachments on the Account Related List Notes & Attachments where image has gif file type.
@Admin Addicts @* Sales Cloud - Best Practices * @Formulas - Help, Tips and Tricks @* Salesforce Developers * #Salesforce Developer #Sales Cloud #Data Management #Sales Cloud
