Error: Compile Error: Invalid bind expression type of SOBJECT:AccountShare does not match domain of foreign key

Question

I'm attempting to create a list with accounts from user's territory. SYSTEMS__c is custom object, Account__c is a lookup to accounts. Here what I have gone so far...

List<AccountShare> list_AccountShare = [Select  AccountId from AccountShare 
                                         where ( UserOrGroupId IN : map_group OR  UserOrGroupId =:userId )
                                                AND RowCause IN ('Territory', 'TerritoryManual', 'TerritoryRule')];

List<SYSTEMS__c> list_Partners = [SELECT Account__c,Number__c,LEGACY_CUST_NUM__c 
                                    FROM SYSTEMS__c where Account__c IN: list_AccountShare];

But I get this error..

Error: Compile Error: Invalid bind expression type of SOBJECT:AccountShare does not match domain of foreign key

I guess the IN clause syntax is incorrect. Any suggestions? Thanks.

Answer 1

Inline lists can only bind to Id, not any other field. What you need is a subquery:

SELECT Account__c,Number__c,LEGACY_CUST_NUM__c 
FROM SYSTEMS__c where Account__c IN
(Select  AccountId from AccountShare 
where ( UserOrGroupId IN : map_group OR  UserOrGroupId =:userId )
AND RowCause IN ('Territory', 'TerritoryManual', 'TerritoryRule'))

If the sub-query is too complex, it may not let you, in which case you'll have to iterate through the list of shares you queried, and build the list manually.

Answer 2

The reason you are getting this error is here:

List<SYSTEMS__c> list_Partners = [SELECT Account__c,Number__c,LEGACY_CUST_NUM__c 
                                    FROM SYSTEMS__c where Account__c IN: list_AccountShare];

The list_accountShare is declared as List<AccountShare> and hence the ids used in this list of sObjects are lists of AccountShare ids. Yet, the SOQL is expecting a list of Account ids when you use a bind variable of list<Sobject>.

You'll need to take the output of the first SOQL and build up a list of AccountIds to use as the bind expression in the second SOQL

Answer 3

I tried this code in my execute anonymous block its working fine for me. Set<id> groupId = new Set<id>{'00540000001mA7bAAE','00540000001mA7bAAE'}; List<AccountShare> list_AccountShare = [Select AccountId from AccountShare where ((UserOrGroupId IN :groupID) OR (UserOrGroupId ='00540000001mV8iAAE')) AND (RowCause IN ('Rule','Owner'))]; System.debug(' AccountShare is '+ list_AccountShare); What I did is added the bracket for OR condition and AND condition. But I am not sure this is right or not but i got the output in anonymous block.

Thanks, IRaj.