function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Inbox OutboxInbox Outbox 

I need help with this code; a bit in a rush please help

Write a SOQL statement that returns the Id and name of 25 accounts from Canada in alphabetical order.
 
Sharma SukritiSharma Sukriti
SELECT Id, Name FROM Account WHERE BillingCounty = 'Canada' LIMIT 25 ORDER BY Name ASC
Sai PraveenSai Praveen (Salesforce Developers) 
Hi ,

There is some know issue which is stopping to filter based on Billing Country I guess.

Can you check the below know issue (https://trailblazer.salesforce.com/issues_view?id=a1p300000008XGhAAM&title=unable-to-filter-search-results-with-billing-country-when-state-country-picklist-is-enabled) for the same



If this solution helps, Please mark it as best answer.

Thanks,