What is SOQL for Salesforce Admins?<\/h2>\n\n\n\n
SOQL is a query language for reading Salesforce data. A query names the fields you want, the object to read and optional filters. SOQL only reads data. It never changes records, so it is safe to practise.<\/p>\n\n\n\n
Think of a librarian’s search card. You write “Books by Ruskin Bond, published after 2000, sorted by title.” The librarian returns exactly that list. A SOQL query is that card, and Salesforce is the librarian.<\/p>\n\n\n\n
Why SOQL for Salesforce Admins Matters<\/h2>\n\n\n\n
Reports are great for business users. However, admins often need fast, one-off answers. SOQL for Salesforce Admins gives those answers quickly. Here is how it helps at Bright Path Tutors.<\/p>\n\n\n\n
- \n
- First, find courses with a blank fee before a data load.<\/li>\n\n
- Also, list users who have not logged in for 90 days.<\/li>\n\n
- Next, check the exact API names of fields for a Data Loader mapping.<\/li>\n\n
- Count enrolments per course to spot duplicates.<\/li>\n\n
- Finally, see which users have a permission set assigned.<\/li>\n<\/ul>\n\n\n\n
So SOQL saves time on clean-up, audits and troubleshooting.<\/p>\n\n\n\n
How SOQL for Salesforce Admins Works<\/h2>\n\n\n\n
SOQL for Salesforce Admins follows a simple pattern. First, you open a query tool, such as the Developer Console. Next, you write SELECT, then the field API names. Then you write FROM and the object API name. After that, you add WHERE filters, ORDER BY and LIMIT. Finally, you run it and read or export the results.<\/p>\n\n\n\n
![\"SOQL](\"https:\/\/swapnilzambare.com\/blog\/wp-content\/uploads\/2026\/10\/soql-for-salesforce-admins-workbench-inspector-diagram-1-1024x640.png\")
How an admin writes and runs a SOQL query.<\/figcaption><\/figure>\n\n\n\n SELECT and FROM<\/h3>\n\n\n\n
SELECT lists the fields, and FROM names the object. Always use API names, such as Fee__c, not labels.<\/p>\n\n\n\n
WHERE<\/h3>\n\n\n\n
WHERE filters records, such as WHERE Level__c = ‘Beginner’. Text values go in single quotes. Numbers and dates do not.<\/p>\n\n\n\n
ORDER BY and LIMIT<\/h3>\n\n\n\n
ORDER BY sorts results, and LIMIT caps how many rows return. Use LIMIT while testing, so you do not pull huge lists.<\/p>\n\n\n\n
Relationship Fields<\/h3>\n\n\n\n
You can read parent fields with a dot, such as Owner.Name. So one query can show a course and the name of its owner.<\/p>\n\n\n\n
Developer Console vs Workbench vs Inspector<\/h2>\n\n\n\n
The table below compares the three popular query tools.<\/p>\n\n\n\n
Feature<\/th> Developer Console<\/th> Workbench<\/th> Salesforce Inspector<\/th><\/tr><\/thead> Provided by<\/td> Salesforce, built in<\/td> Community web tool<\/td> Community browser extension<\/td><\/tr> Install needed<\/td> No<\/td> No<\/td> Yes, browser extension<\/td><\/tr> Query editor<\/td> Yes<\/td> Yes<\/td> Yes, with autocomplete<\/td><\/tr> Export results<\/td> Copy only<\/td> CSV export<\/td> Copy or CSV export<\/td><\/tr> Data changes<\/td> Limited<\/td> Yes, use with care<\/td> Yes, use with care<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n When to use which depends on your company rules. The Developer Console is always available. Workbench and Inspector are faster for exports, but check your security team’s policy first.<\/p>\n\n\n\n
![\"SOQL](\"https:\/\/swapnilzambare.com\/blog\/wp-content\/uploads\/2026\/10\/soql-for-salesforce-admins-workbench-inspector-diagram-2-1024x640.png\")
Developer Console vs Workbench vs Salesforce Inspector.<\/figcaption><\/figure>\n\n\n\n SOQL for Salesforce Admins: Real Queries Step by Step<\/h2>\n\n\n\n
Let’s run SOQL for Salesforce Admins at Bright Path Tutors in the Developer Console.<\/p>\n\n\n\n
Step 1: Open the Query Editor<\/h3>\n\n\n\n
- \n
- Click the gear icon and choose Developer Console.<\/li>\n\n
- Next, click the Query Editor tab at the bottom.<\/li>\n\n
- Type a query and click Execute.<\/li>\n<\/ol>\n\n\n\n
Step 2: Find Courses with No Fee<\/h3>\n\n\n\n
SELECT Id, Name, Level__c, Start_Date__c\nFROM Course__c\nWHERE Fee__c = null\nORDER BY Start_Date__c\nLIMIT 50<\/code><\/pre>\n\n\n\nThis query lists courses with a blank fee, earliest start date first. Fix these before any price update.<\/p>\n\n\n\n
Step 3: Find Inactive Users<\/h3>\n\n\n\n
SELECT Name, Username, LastLoginDate, Profile.Name\nFROM User\nWHERE IsActive = true AND LastLoginDate < LAST_N_DAYS:90\nORDER BY LastLoginDate<\/code><\/pre>\n\n\n\nThis lists active users who have not logged in for 90 days. They may need to be frozen to save licences and reduce risk. Profile.Name reads a field from the related profile.<\/p>\n\n\n\n
Step 4: Count Enrolments per Course<\/h3>\n\n\n\n
SELECT Course__r.Name, COUNT(Id) total\nFROM Enrolment__c\nGROUP BY Course__r.Name\nORDER BY COUNT(Id) DESC<\/code><\/pre>\n\n\n\nThis groups enrolments by course and counts them. Courses with surprisingly high counts may contain duplicates.<\/p>\n\n\n\n
Step 5: Check Permission Set Assignments<\/h3>\n\n\n\n
SELECT Assignee.Name, PermissionSet.Label\nFROM PermissionSetAssignment\nWHERE PermissionSet.Name = 'Finance_Team'<\/code><\/pre>\n\n\n\nThis shows everyone who has the Finance Team permission set. Audits like this are where SOQL for Salesforce Admins shines, because it is much faster than clicking through each user.<\/p>\n\n\n\n
The table below shows the result of Step 4 for a few courses.<\/p>\n\n\n\n
Course Name<\/th> total<\/th><\/tr><\/thead> Apex Basics<\/td> 182<\/td><\/tr> LWC Basics<\/td> 96<\/td><\/tr> Admin Bootcamp<\/td> 240<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Date Literals Admins Use Most<\/h2>\n\n\n\n
SOQL has handy date words, so you do not type exact dates. These are a big part of SOQL for Salesforce Admins. TODAY, YESTERDAY, THIS_MONTH, LAST_N_DAYS:30 and NEXT_N_DAYS:7 are the most useful. For example, WHERE CreatedDate = THIS_MONTH finds all records created this month.<\/p>\n\n\n\n
Using Workbench and Inspector Safely<\/h2>\n\n\n\n
Many people learn SOQL for Salesforce Admins with Workbench and Salesforce Inspector. However, these are community tools, not official Salesforce products. Both connect with your Salesforce login. So install Inspector only from the official browser store, and ask your security team before using either tool in production. Also, both tools can update or delete data. Practise in a sandbox first, and double-check any update before you click.<\/p>\n\n\n\n
Common Mistakes with SOQL for Salesforce Admins<\/h2>\n\n\n\n
- \n
- Using field labels instead of API names.<\/li>\n\n
- Forgetting single quotes around text values.<\/li>\n\n
- Running queries with no LIMIT on large objects.<\/li>\n\n
- Updating data in Workbench without testing in a sandbox.<\/li>\n\n
- Forgetting that queries only return records you can see.<\/li>\n<\/ul>\n\n\n\n
Best Practices for SOQL for Salesforce Admins<\/h2>\n\n\n\n
- \n
- Start every new query with LIMIT 10, then remove it when it works.<\/li>\n\n
- Save your favourite queries in a text file or note.<\/li>\n\n
- Use relationship fields instead of exporting two objects and matching them.<\/li>\n\n
- Follow your company’s rules on community tools.<\/li>\n\n
- Use reports for business users and SOQL for admin checks.<\/li>\n<\/ul>\n\n\n\n
Practice Task<\/h2>\n\n\n\n
Write a query that lists online courses starting in the next 30 days, sorted by start date. Hint: filter on Is_Online__c = true and use NEXT_N_DAYS:30.<\/p>\n\n\n\n
Most Asked Interview Questions on SOQL for Salesforce Admins<\/h2>\n\n\n\n
Admin interviews now often include simple SOQL questions. Here are the ones asked most.<\/p>\n\n\n\n
Basic Questions on SOQL for Salesforce Admins<\/h3>\n\n\n\n
Q1. What is SOQL?<\/strong><\/p>\n\n\n\n
It is the Salesforce Object Query Language. It reads records from Salesforce objects using SELECT, FROM and optional filters.<\/p>\n\n\n\n
Q2. Can SOQL change data?<\/strong><\/p>\n\n\n\n
No. SOQL only reads data. Changes need DML, Data Loader or tools that update records.<\/p>\n\n\n\n
Q3. Where can an admin run SOQL?<\/strong><\/p>\n\n\n\n
In the Developer Console Query Editor, Workbench, Salesforce Inspector or VS Code.<\/p>\n\n\n\n
Q4. What is a date literal?<\/strong><\/p>\n\n\n\n
It is a word like TODAY or LAST_N_DAYS:30 that stands for a date range, so you do not type exact dates.<\/p>\n\n\n\n
Practical Questions on SOQL for Salesforce Admins<\/h3>\n\n\n\n
Q5. How do you find users who have not logged in recently?<\/strong><\/p>\n\n\n\n
Query User with IsActive = true and LastLoginDate < LAST_N_DAYS:90, then review the list.<\/p>\n\n\n\n
Q6. How do you read a parent field in SOQL?<\/strong><\/p>\n\n\n\n
Use dot notation, such as Owner.Name or Course__r.Name for a custom lookup.<\/p>\n\n\n\n
Q7. How do you check who has a permission set?<\/strong><\/p>\n\n\n\n
Query PermissionSetAssignment and filter on PermissionSet.Name.<\/p>\n\n\n\n
Q8. A query returns fewer records than expected. Why?<\/strong><\/p>\n\n\n\n
The running user may not have access to all records, or the filter may be wrong. Check sharing and test the filter step by step.<\/p>\n\n\n\n
Official Resources<\/h2>\n\n\n\n