Skip to Main Content
Development with the Force.com Platform: Building Business Applications in the Cloud, Third Edition
book

Development with the Force.com Platform: Building Business Applications in the Cloud, Third Edition

by Jason Ouellette
December 2013
Intermediate to advanced content levelIntermediate to advanced
448 pages
13h 44m
English
Addison-Wesley Professional
Content preview from Development with the Force.com Platform: Building Business Applications in the Cloud, Third Edition

Query Language

Force.com has two query languages. One is called Salesforce Object Query Language (SOQL) and is used for structured queries. The other language, Salesforce Object Search Language (SOSL), is used for searching the full text of one or more objects.

SOQL

Don’t let the name confuse you. Despite some similarities in syntax, SOQL is very different from SQL. It has more in common with a reporting or object-traversal language than its more mathematically grounded ancestor.

Listing 2.3 shows a sample SOQL query on a custom object. It returns the names, statuses, and expected revenue amounts for the top-ten largest uninvoiced projects started in the last quarter, in descending order by pending revenue.

Listing 2.3 Sample SOQL Query

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Development with the Force.com Platform: Building Business Applications in the Cloud, Second Edition

Development with the Force.com Platform: Building Business Applications in the Cloud, Second Edition

Jason Ouellette

Publisher Resources

ISBN: 9780133511611Purchase book