Book Image

Learning Force.com Application Development

By : Chamil Madusanka
Book Image

Learning Force.com Application Development

By: Chamil Madusanka

Overview of this book

Table of Contents (21 chapters)
Learning Force.com Application Development
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Force.com platform query languages


The query languages are used to access data for data manipulation. There are two query languages in the Force.com platform:

  1. Salesforce.com Object Query Language (SOQL)

  2. Salesforce.com Object Search Language (SOSL)

Both of these languages are used to retrieve a set of data from the Force.com platform.

Salesforce.com Object Query Language (SOQL)

We assume that you are already familiar with query language such as SQL, which is the universal standard for interacting with relational databases. In the Force.com platform, we considered the data repository of the Force.com platform as the relational database. Therefore, we use SOQL instead of SQL for data-retrieving purposes. There are similarities as well as differences in SOQL and SQL.

Similarities

Differences

Most of the syntax

SOQL can only retrieve data (query-only language) while SQL can both read and write data.

Some overlapping functionalities

SOQL uses relationships but not Joins, while SQL implements relationships...