Apex Code Development You need to sign in to do that
Don't have an account?
pcroadkill SOOQL does not return results
I have a query against the Account object that returns all accounts for a specific business unit. If I modify the query to include the billingstate field as part of the criteria, no results are returned even though there are records that match the criteria.
We have checked the permissions on the billingstate field and is open to everyone. Any ideas on what else couldbe preventing us from being able to query using the billingstate as criteria.
Example queries:
SELECT Business_Unit__c, Name, billingstate, Id FROM Account where business_unit__c = 'Consumer' -- works and returns accounts.
SELECT Business_Unit__c, Name, billingstate, Id FROM Account where business_unit__c = 'Consumer' and BillingState = 'IL' -- does not work and the above query has multiple records from Illinois.
Thanks in advance for any help/hints that you can provide.
We have checked the permissions on the billingstate field and is open to everyone. Any ideas on what else couldbe preventing us from being able to query using the billingstate as criteria.
Example queries:
SELECT Business_Unit__c, Name, billingstate, Id FROM Account where business_unit__c = 'Consumer' -- works and returns accounts.
SELECT Business_Unit__c, Name, billingstate, Id FROM Account where business_unit__c = 'Consumer' and BillingState = 'IL' -- does not work and the above query has multiple records from Illinois.
Thanks in advance for any help/hints that you can provide.
Its look like an know issue. Check this link for more details - https://success.salesforce.com/issues_view?id=a1p300000008XGhAAM