Getting started with SOQL : revolutionize the use of simple query strings to make them more efficient using SOQL /: revolutionize the use of simple query strings to make them more efficient using SOQL. (2014)
- Record Type:
- Book
- Title:
- Getting started with SOQL : revolutionize the use of simple query strings to make them more efficient using SOQL /: revolutionize the use of simple query strings to make them more efficient using SOQL. (2014)
- Main Title:
- Getting started with SOQL : revolutionize the use of simple query strings to make them more efficient using SOQL
- Other Titles:
- Getting started with Salesforce Object Query Language
- Further Information:
- Note: Magulan D.
- Other Names:
- D., Magulan
- Contents:
- 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; BestCover; 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. … (more)
- Publisher Details:
- Birmingham, UK : Packt Pub
- Publication Date:
- 2014
- Extent:
- 1 online resource (1 volume), illustrations
- Subjects:
- 005.365
COMPUTERS -- Software Development & Engineering -- Project Management
Query languages (Computer science)
Salesforce (Online service)
Database management
Application software
Computer science
Web development
Database management
Query languages (Computer science)
Salesforce (Online service)
COMPUTERS -- Web -- Content Management Systems
Electronic books - Languages:
- English
- ISBNs:
- 9781783287369
1783287365
1783287357
9781783287352 - Related ISBNs:
- 9781783287352
- Notes:
- Note: Online resource; title from cover (Safari, viewed May 6, 2014).
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.87499
- Ingest File:
- 01_075.xml