Preface: this post is part of the SOQL: A Beginner’s Guide series.
You’ve probably already written SOQL, but you might not realize it yet!
Yup – you can write SOQL queries in Data Loader! And yes, you can bypass the UI and simply type your query in the box!
But there’s still a better place to write SOQL, and it’s all the rage these days. I’m talking about Salesforce’s new tool called Workbench.
To begin writing SOQL queries, simply login to Workbench and go here:
Queries >> SOQL Query
Pro tip: Use the sfdc99 login so you can try out the examples posted on this site!
Writing SOQL queries in Workbench or Data Loader is useful to test your queries (I use it almost every day!), but the real power of SOQL comes when you mix it in with Apex, like in a trigger. I’ll show you guys how to do this very soon, but first, you need to learn the basics of the SOQL language!
Next post: Example: How to write a simple SOQL query