Return to Answer

added 2 characters in body

edited Jan 12, 2017 at 21:09

Apart from not bulkifying your code, it looks like you are not referencing the account in your where clause. Try the below.

List<Contact> lstCon = [SELECT Id, Admin_User__c, Account_Expiration__c FROM Contact WHERE AccountAccountId = :acc.Id AND Admin_User__c = true];

Apart from not bulkifying your code, it looks like you are not referencing the account in your where clause. Try the below.

List<Contact> lstCon = [SELECT Id, Admin_User__c, Account_Expiration__c FROM Contact WHERE Account = :acc.Id AND Admin_User__c = true];

Apart from not bulkifying your code, it looks like you are not referencing the account in your where clause. Try the below.

List<Contact> lstCon = [SELECT Id, Admin_User__c, Account_Expiration__c FROM Contact WHERE AccountId = :acc.Id AND Admin_User__c = true];

answered Jan 12, 2017 at 20:45

Apart from not bulkifying your code, it looks like you are not referencing the account in your where clause. Try the below.

List<Contact> lstCon = [SELECT Id, Admin_User__c, Account_Expiration__c FROM Contact WHERE Account = :acc.Id AND Admin_User__c = true];