I want to export attachments of those Owners who belong to a certain Organisation.
SELECT BodyLength FROM Attachment WHERE OwnerId.Organisation_Name__r = 'ExampleCompanyName', but got the following error:
ERROR at Row:1:Column:41 Didn't understand the relationship 'OwnerId' in the field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
Can somebody help me out?