Book Image

Getting Started with SOQL

By : Magulan D
Book Image

Getting Started with SOQL

By: Magulan D

Overview of this book

<p>This practical guide will tell you everything you need to know about SOQL statements. You will learn the optimum way to write complex SOQL statements with this easy-to-understand guide. Beginning with basic SOQL statements, you will progress quickly onto more advanced statements, such as how to filter multiselect picklist values to escape sequences.</p> <p>This book will teach you how to sort records with more than one field, sorting with more than one field–one in ascending order and another field in descending order—and sorting null records in the first or in the last. You will learn about all the features provided while you are writing SOQL statements. This book will make you a SOQL expert by teaching you how to write SOQL statements in an optimized and effective way.</p>
Table of Contents (14 chapters)
Getting Started with SOQL
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Dataloader.io


Use Dataloader.io to import, export, and delete data from Salesforce. Everything is online in Data Loader. There will be no software hassle if we use Dataloader.io. A browser and an Internet connection are more than enough to use this feature provided by a third party. It is not a Salesforce tool.

To use Dataloader.io, perform the following steps:

  1. Go to https://dataloader.io/.

  2. Click on the Login with Salesforce button.

  3. Select an Environment option and click on the Login button as shown in the following screenshot:

  4. Enter your username and password and click on the Log in to Salesforce button as shown in the following screenshot:

  5. Select Export under New Task as shown in the following screenshot:

  6. Select Object and click on the Next button as shown in the following screenshot:

  7. Select the fields and build your SOQL query; click on the Verify button to verify your query and then click on the Next button as shown in the following screenshot:

  8. Schedule or run the query to be exported. Refer...