Book description
Revolutionize the use of simple query strings to make them more efficient using SOQL
In Detail
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.
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.
What You Will Learn
- Discover how to write effective SOQL statements
- Find out about the standards to be followed while writing SOQL statements
- Understand the effective use of advanced SOQL statements
- Fetch records from multiple objects
- Sort records with multiple fields
- Get to know about the tools that support the execution of SOQL statements and their installation guidelines
- Understand the functional areas within SOQL queries
- Implement mechanisms to manage SOQL on Salesforce
Table of contents
-
Getting Started with SOQL
- Table of Contents
- Getting Started with SOQL
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Introduction to SOQL
- 2. Basic SOQL Statements
-
3. Advanced SOQL Statements
- Relationship queries
- Filtering multiselect picklist values
- The escape sequences
- The date formats
- The date literals
- Querying with the date fields
- Sorting in both the ascending and descending orders
- Using the GROUP BY ROLLUP clause
- Using the FOR REFERENCE clause
- Using the FOR VIEW clause
- Using the GROUP BY CUBE clause
- Using the OFFSET clause
- Summary
- 4. Functions in SOQL
- 5. Limitations and Best Practices
- 6. Tools with Installation Guidelines
- A. Review Questions
- Index
Product information
- Title: Getting Started with SOQL
- Author(s):
- Release date: April 2014
- Publisher(s): Packt Publishing
- ISBN: 9781783287352
You might also like
book
Python Crash Course, 2nd Edition
This is the second edition of the best selling Python book in the world. Python Crash …
video
Salesforce for Developers
7+ Hours of Video Instruction Salesforce for Developers LiveLessons provides developers with a practical introduction to …
book
Developing Data Migrations and Integrations with Salesforce: Patterns and Best Practices
Migrate your data to Salesforce and build low-maintenance and high-performing data integrations to get the most …
book
Kubernetes: Up and Running, 2nd Edition
Kubernetes radically changes the way applications are built and deployed in the cloud. Since its introduction …