I know I am not seeing the forest for the trees on ths one. I can query custom records that have files attached plus all that dont, and I can query just those that have a contentversion ID. I can't seem to get all records that dont have a File.Query's only records that have files attached to the custom objectSelect Id, LinkedEntityId, LinkedEntity.name, ContentDocumentId , ContentDocument.title from ContentDocumentLink WHERE LinkedEntityId in (SELECT Id FROM Job__c)Query's all records and also includes those records that have attachments showing the Content Document.SELECT Name, (SELECT ContentDocumentId, ContentDocument.Title, ContentDocument.ContentSize FROM ContentDocumentLinks) FROM Job__c where SpecialHandling__c = 'WVC'Want:Query all custom records (Job__c) that do not have a ContentDocumentID. If it already has a related File, I dont care about it.What am I missing?
