Apex Code Development You need to sign in to do that
Don't have an account?
hamza akouayri INVALID_TYPE_FOR_OPERATION: entity type CombinedAttachment does not support query
I am using this query to query all accounts with won opp and don't have an attachment (CombinedAttachments) related to them but I got these error when I try to filer with CombinedAttachments
INVALID_TYPE_FOR_OPERATION: entity type CombinedAttachment does not support query
SELECT Id, L11_Account_ID__c,Name,(SELECT Id, StageName FROM Opportunities WHERE StageName = 'Closed Won'),(SELECT ParentId,Title FROM CombinedAttachments)
FROM Account
Where Id IN (SELECT AccountId FROM Opportunity WHERE StageName = 'Closed Won')
AND L11_Account_ID__c != null
AND Id NOT IN (SELECT ParentId FROM CombinedAttachment where record.Type ='Accounts')
any suggestion to work around this
INVALID_TYPE_FOR_OPERATION: entity type CombinedAttachment does not support query
SELECT Id, L11_Account_ID__c,Name,(SELECT Id, StageName FROM Opportunities WHERE StageName = 'Closed Won'),(SELECT ParentId,Title FROM CombinedAttachments)
FROM Account
Where Id IN (SELECT AccountId FROM Opportunity WHERE StageName = 'Closed Won')
AND L11_Account_ID__c != null
AND Id NOT IN (SELECT ParentId FROM CombinedAttachment where record.Type ='Accounts')
any suggestion to work around this