Cargando…
Getting started with SOQL : revolutionize the use of simple query strings to make them more efficient using SOQL /
This is a practical tutorial-based guide on using the new SOQL language, aimed at Force.com developers. Each topic is discussed with the help of standard SOQL queries. If you are a Salesforce.com developer or administrator, this book will help you to avoid hitting limits set by Salesforce.com. For t...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Pub.,
2014.
|
| Colección: | Community experience distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to SOQL; What is SOQL?; Purpose of SOQL; SOQL syntax; Writing your first SOQL statement; Summary; Chapter 2: Basic SOQL Statements; The alias notation; The WHERE clause; The comparison operators; The equals operator; The not equals operator; The less than or equal to operator; The less than operator; The greater than or equal to operator; The greater than operator; The LIKE operator; The IN operator; The NOT IN Operator; The logical operators.
- The AND operatorThe OR operator; The ORDER BY clause; The INCLUDES and EXCLUDES operators; Summary; Chapter 3: Advanced SOQL Statements; Relationship queries; Filtering multiselect picklist values; The INCLUDES operator; The EXCLUDES operator; 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; Chapter 4: Functions in SOQL.
- Using the toLabel() methodUsing 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; Chapter 5: Limitations and Best Practices; Standards to be followed in SOQL; Best practices; Limitations in objects; Other limitations; Governor limits; Understanding the limitations of the ORDER BY query; Understanding the limitations of the toLabel() query; Understanding the limitations of the COUNT() query.
- Understanding the limitations of the OFFSET clauseLimitations of the relationship queries; Notes and Attachments limitations; Summary; Chapter 6: Tools with Installation Guidelines; Using the Force.com Explorer software; Installing Force.com Explorer; Workbench; Dataloader.io; The Apex Data Loader tool; Downloading Data Loader without the Salesforce.com login; Summary; Appendix: Review Questions; Index.