SOQL Tasks

This is a repository of sample tasks using SOQL that you can complete in Code Builder or VS Code using the Salesforce Extensions. We’ll keep adding to this list, so make sure you visit this topic often.

Use the SOQL Query Editor Create a Query To List Accounts with a New York State Address

1. From the Command Palette, run SFDX: Create Query in SOQL Builder to open SOQL Query Builder.
2. Click File > Save to save the query. Make sure to retain the .soql file extension.
3. Click the Switch Between SOQL Builder and Text Editors icon () to reopen the SOQL Query Builder.
4. In the From field, search for the object, and then select the Account object.
5. In Fields, select Name, BillingState, and BillingCountry.
6. In the Filter field, select AND, and set: BillingCountry = USA AND BillingState = NY
7. Click Run Query.

A Query Result tab pops up. You can then save the result in csv or json formats.

Resources

Guides:

• Example SELECT Clauses
• Salesforce Object Query Language (SOQL)

Trailhead:

• Write SOQL Queries

Feedback or Bugs | Edit this Article