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>

Related Content you might be interested in

Current Title:

Small book image
Getting Started with SOQL
Magulan D
Apr, 2014 | 130 pages
No titles found
Table of Contents (14 chapters)
Getting Started with SOQL
Getting Started with SOQL
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Introduction to SOQL
Introduction to SOQL
What is SOQL?
Purpose of SOQL
SOQL syntax
Writing your first SOQL statement
Summary
2
Basic SOQL Statements
Basic SOQL Statements
The alias notation
The WHERE clause
The comparison operators
The IN operator
The logical operators
The ORDER BY clause
The INCLUDES and EXCLUDES operators
Summary
3
Advanced SOQL Statements
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
Functions in SOQL
Using the toLabel() method
Using the GROUP BY clause
Using the COUNT() method
Using the COUNT(Field_Name) method
Using the COUNT_DISTINCT() method
Using the MIN() method
Using the MAX() method
Using the SUM() method
Using the HAVING clause
Summary
5
Limitations and Best Practices
Limitations and Best Practices
Standards to be followed in SOQL
Best practices
Limitations in objects
Other limitations
Summary
6
Tools with Installation Guidelines
Tools with Installation Guidelines
Using the Force.com Explorer software
Workbench
Dataloader.io
The Apex Data Loader tool
Summary
Review Questions
Review Questions
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Index
Index

Getting Started with SOQL

Copyright © 2014 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: April 2014

Production Reference: 1090414

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-78328-735-2

www.packtpub.com

Cover Image by Neha Rajappan ()

Previous Section
Next Chapter