SOQL

The lib main class for query construction.

of

Conctructs an SOQL.

Signature

SOQL of(SObjectType ofObject)

Example

SELECT Id FROM Account

SOQL.of(Account.SObjectType).toList();

select

with field

Signature

SOQL with(SObjectField field)

Example

SELECT Id, Name
FROM Account

SOQL.of(Account.SObjectType)
    .with(Account.Id)
    .with(Account.Name)
    .toList();

with fields

SELECT

SELECT statement that specifies the fields to query. The fieldList in the SELECT statement specifies the list of one or more fields, separated by commas, that you want to retrieve.

Signature

SOQL with(List<SObjectField> fields)

Example

SELECT Id, Name, Industry
FROM Account

SOQL.of(Account.SObjectType)
    .with(List<SObjectField>{
        Account.Id, Account.Name, Account.Industry
    }).toList();

with string fields

NOTE! Apex do not have reference to String fields. Use it only for corner cases.

Signature

SOQL with(String fields)

Example

SELECT Id, Name, Industry
FROM Account

SOQL.of(Account.SObjectType)
    .with('Id, Name, Industry')
    .toList();

SELECT

Allows to add parent field to a query.

Signature

SOQL with(String relationshipName, List<SObjectField> fields)

Example

SELECT CreatedBy.Id, CreatedBy.Name
FROM Account

SOQL.of(Account.SObjectType)
    .with('CreatedBy', List<SObjectField>{
        User.Id, User.Name
    }).toList();

with subquery

Using Relationship Queries

Use SOQL to query several relationship types.

For more details check SOQL.SubQuery class.

Signature

SOQL with(SOQL.SubQuery subQuery)

Example

SELECT Id, (
    SELECT Id, Name
    FROM Contacts
) FROM Account

SOQL.of(Account.SObjectType)
    .with(SOQL.SubQuery.of('Contacts')
        .with(new List<SObjectField>{
            Contact.Id, Contact.Name
        })
    ).toList();

count

COUNT()

COUNT() returns the number of rows that match the filtering conditions.

Signature

SOQL count()

Example

SELECT COUNT()
FROM Account

SOQL.of(Account.SObjectType)
    .count()
    .toInteger();

count field

Signature

count(SObjectField field)

Example

SELECT COUNT(Id), COUNT(CampaignId)
FROM Opportunity

 SOQL.of(Opportunity.SObjectType)
    .count(Opportunity.Id)
    .count(Opportunity.CampaignId)
    .toAggregated();

count with alias

Signature

count(SObjectField field, String alias)

Example

SELECT COUNT(Name) names FROM Account

SOQL.of(Account.SObjectType)
    .count(Account.Name, 'names')
    .toAggregated();

scope

USING SCOPE

delegatedScope

Filter for records delegated to another user for action. For example, a query could filter for only delegated Task records.

Signature

SOQL delegatedScope()

Example

SELECT Id
FROM Task
USING SCOPE DELEGATED

SOQL.of(Task.SObjectType)
    .delegatedScope()
    .toList();

mineScope

Filter for records owned by the user running the query.

Signature

SOQL mineScope()

Example

SELECT Id
FROM Task
USING SCOPE MINE

SOQL.of(Account.SObjectType)
    .mineScope()
    .toList();

mineAndMyGroupsScope

Filter for records assigned to the user running the query and the user’s queues. If a user is assigned to a queue, the user can access records in the queue. This filter applies only to the ProcessInstanceWorkItem object.

Signature

SOQL mineAndMyGroupsScope()

Example

SELECT Id
FROM Task
USING SCOPE MINE_AND_MY_GROUPS

SOQL.of(ProcessInstanceWorkItem.SObjectType)
    .mineAndMyGroupsScope()
    .toList();

myTerritoryScope

Filter for records in the territory of the user running the query. This option is available if territory management is enabled for your organization.

Signature

SOQL myTerritoryScope()

Example

SELECT Id
FROM Opportunity
USING SCOPE MY_TERRITORY

SOQL.of(Opportunity.SObjectType)
    .myTerritoryScope()
    .toList();

myTeamTerritoryScope

Filter for records in the territory of the team of the user running the query. This option is available if territory management is enabled for your organization.

Signature

SOQL myTeamTerritoryScope()

Example

SELECT Id
FROM Opportunity
USING SCOPE MY_TEAM_TERRITORY

SOQL.of(Opportunity.SObjectType)
    .myTeamTerritoryScope()
    .toList();

teamScope

Filter for records assigned to a team, such as an Account team.

Signature

SOQL teamScope()

Example

SELECT Id FROM Account USING SCOPE TEAM

SOQL.of(Account.SObjectType)
    .teamScope()
    .toList();

where

whereAre

WHERE

The condition expression in a WHERE clause of a SOQL query includes one or more field expressions. You can specify multiple field expressions in a condition expression by using logical operators.

For more details check SOQL.FilterGroup and SOQL.Filter

Signature

SOQL whereAre(FilterClause conditions)

Example

SELECT Id
FROM Account
WHERE Id = :accountId OR Name = '%MyAccount%'

SOQL.of(Account.SObjectType)
    .whereAre(SOQL.FilterGroup
        .add(SOQL.Filter.with(Account.Id).equal(accountId))
        .add(SOQL.Filter.with(Account.Name).contains('MyAccount'))
        .conditionLogic('1 OR 2')
    ).toList();

whereAre string

Execute conditions passed as String.

Signature

SOQL whereAre(String conditions)

Example

SELECT Id
FROM Account
WHERE NumberOfEmployees >=10 AND NumberOfEmployees <= 20

SOQL.of(Account.SObjectType)
    .whereAre('NumberOfEmployees >=10 AND NumberOfEmployees <= 20')
    .toList();

group by

GROUP BY

groupBy

You can use the GROUP BY option in a SOQL query to avoid iterating through individual query results. That is, you specify a group of records instead of processing many individual records.

Signature

SOQL groupBy(SObjectField field)

Example

SELECT LeadSource
FROM Lead
GROUP BY LeadSource

SOQL.of(Lead.SObjectType)
    .with(Lead.LeadSource)
    .groupBy(Lead.LeadSource)
    .toAggregated();

groupByRollup

Signature

SOQL groupByRollup(SObjectField field)

Example

SELECT LeadSource, COUNT(Name) cnt
FROM Lead
GROUP BY ROLLUP(LeadSource)

QS.of(Lead.SObjectType)
    .with(Lead.LeadSource)
    .count(Lead.Name, 'cnt')
    .groupByRollup(Lead.LeadSource)
    .toAggregated();

order by

ORDER BY

orderBy

Use the optional ORDER BY in a SELECT statement of a SOQL query to control the order of the query results.

Signature

SOQL orderBy(SObjectField field)

Example

SELECT Id
FROM Account
ORDER BY Name

SOQL.of(Account.SObjectType)
    .orderBy(Account.Name)
    .toList();

Order SOQL query by parent field.

Signature

SOQL orderBy(String relationshipName, SObjectField field)

Example

SELECT Id
FROM Contact
ORDER BY Account.Name

SOQL.of(Contact.SObjectType)
    .orderBy('Account', Account.Name)
    .toList();

sortDesc

Default order is ascending (ASC).

Signature

SOQL sortDesc()

Example

SELECT Id
FROM Account
ORDER BY Name DESC

SOQL.of(Account.SObjectType)
    .orderBy(Account.Name)
    .sortDesc()
    .toList();

nullsLast

By default, null values are sorted first (NULLS FIRST).

Signature

SOQL nullsLast()

Example

SELECT Id
FROM Account
ORDER BY Name NULLS LAST

SOQL.of(Account.SObjectType)
    .orderBy(Account.Industry)
    .nullsLast()
    .toList();

setLimit

LIMIT

LIMIT is an optional clause that can be added to a SELECT statement of a SOQL query to specify the maximum number of rows to return.

Signature

SOQL setLimit(Integer amount)

Example

SELECT Id
FROM Account
LIMIT 100

SOQL.of(Account.SObjectType)
    .setLimit(100)
    .toList();

offset

OFFSET

When expecting many records in a query’s results, you can display the results in multiple pages by using the OFFSET clause on a SOQL query.

Signature

SOQL offset(Integer startingRow)

Example

SELECT Id
FROM Account
OFFSET 10

SOQL.of(Account.SObjectType)
    .setOffset(10)
    .toList();

for

forReference

Use to notify Salesforce when a record is referenced from a custom interface, such as in a mobile application or from a custom page.

Signature

SOQL forReference()

Example

SELECT Id
FROM Contact
FOR REFERENCE

SOQL.of(Contact.SObjectType)
    .forReference()
    .toList();

forView

Use to update objects with information about when they were last viewed.

Signature

SOQL forView()

Example

SELECT Id
FROM Contact
FOR VIEW

SOQL.of(Contact.SObjectType)
    .forView()
    .toList();

forUpdate

Use to lock sObject records while they’re being updated in order to prevent race conditions and other thread safety problems.

Signature

SOQL forUpdate()

Example

SELECT Id
FROM Contact
FOR UPDATE

SOQL.of(Contact.SObjectType)
    .forUpdate()
    .toList();

allRows

SOQL statements can use the ALL ROWS keywords to query all records in an organization, including deleted records and archived activities.

Signature

SOQL allRows()

Example

SELECT COUNT()
FROM Contact
ALL ROWS

SOQL.of(Contact.SObjectType)
    .count()
    .allRows()
    .toList();

fls

AccessLevel Class

By default AccessLevel is set as USER_MODE.

systemMode

Execution mode in which the the object and field-level permissions of the current user are ignored, and the record sharing rules are controlled by the class sharing keywords.

Signature

SOQL systemMode()

Example

SOQL.of(Account.SObjectType)
    .systemMode()
    .toList();

Using the with sharing, without sharing, and inherited sharing Keywords

withSharing

Execute query with sharing.

Note! System mode needs to be enabled by .systemMode().

Signature

SOQL withSharing()

Example

SOQL.of(Account.SObjectType)
    .systemMode()
    .withSharing()
    .toList();

withoutSharing

Execute query without sharing.

Note! System mode needs to be enabled by .systemMode().

Signature

SOQL withoutSharing()

Example

SOQL.of(Account.SObjectType)
    .systemMode()
    .withoutSharing()
    .toList();

mocking

mockId

Query needs unique id that allows for mocking.

Signature

SOQL mockId(String queryIdentifier)

Example

SOQL.of(Account.SObjectType)
    .mockId('MyQuery')
    .toList();

// In Unit Test
SOQL.setMock('MyQuery', new List<Account>{
    new Account(Name = 'MyAccount 1'),
    new Account(Name = 'MyAccount 2')
});

record mock

Signature

SOQL setMock(String mockId, SObject record)

Example

SOQL.of(Account.sObjectType)
    .mockId('MyQuery')
    .toList();

// In Unit Test
SOQL.setMock('MyQuery', new Account(Name = 'MyAccount 1'));

list mock

Signature

SOQL setMock(String mockId, List<SObject> records)

Example

SOQL.of(Account.sObjectType)
    .mockId('MyQuery')
    .toList();

// In Unit Test
SOQL.setMock('MyQuery', new List<Account>{
    new Account(Name = 'MyAccount 1'),
    new Account(Name = 'MyAccount 2')
});

count mock

Signature

SOQL setCountMock(String mockId, Integer amount)

Example

SOQL.of(Account.sObjectType)
    .mockId('MyQuery')
    .count()
    .toInteger();

// In Unit Test
SOQL.setMock('MyQuery', 5);

static resource mock

Signature

SOQL setMock(String mockId, String staticResource)

Example

SOQL.of(Account.sObjectType)
    .mockId('MyQuery')
    .toList();

// In Unit Test
SOQL.setMock('MyQuery', 'MyStaticResource');

preview

Signature

SOQL preview()

Example

SOQL.of(Account.SObjectType)
    .preview()
    .toList();

Query preview will be available in debug logs:

============ Query Preview ============
SELECT Name, AccountNumber, BillingCity, BillingCountry, BillingCountryCode
FROM Account
WHERE ((Id = :v1 OR Name LIKE :v2))
=======================================

============ Query Binding ============
{
  "v2" : "%Test%",
  "v1" : "0013V00000WNCw4QAH"
}
=======================================

result

toObject

When no records found. Instead of List index out of bounds: 0 null will be returned.

Signature

sObject toObject()

Example

SOQL.of(Account.SObjectType).toObject();

toList

Signature

List<sObject> toList()

Example

SOQL.of(Account.SObjectType).toList();

toAggregated

Signature

List<AggregateResult> toAggregated()

Example

SELECT LeadSource
FROM Lead
GROUP BY LeadSource

SOQL.of(Lead.SObjectType)
    .with(Lead.LeadSource)
    .groupBy(Lead.LeadSource)
    .toAggregated()

toInteger

Signature

Integer toInteger()

Example

SELECT COUNT() FROM Account

QS.of(Account.SObjectType).count().toInteger();

toMap

Signature

Map<Id, SObject> toMap()

Example

SOQL.of(Account.SObjectType).toMap();

toQueryLocator

Signature

Database.QueryLocator toQueryLocator()

Example

SOQL.of(Account.SObjectType).toQueryLocator();

predefined

For all predefined methods SOQL instance is returned so you can still adjust query before execution. Add additional fields with .with.

byId

Signature

SOQL byId(Id recordId)

SOQL byId(SObject record)

Example

SELECT Id
FROM Account
WHERE Id = '1234'

SOQL.of(Account.SObjectType)
    .byId('1234')
    .toObject();

Account account = [SELECT Id FROM Account LIMIT 1];
SOQL.of(Account.SObjectType)
    .byId(account)
    .toList();

byIds

Signature

SOQL byIds(Set<Id> recordIds)

SOQL byIds(List<Id> recordIds)

SOQL byIds(List<SObject> records)

Example

SELECT Id
FROM Account
WHERE Id IN ('1234')

SOQL.of(Account.SObjectType)
    .byIds(new Set<Id>{ '1234' })
    .toList();

SOQL.of(Account.SObjectType)
    .byIds(new List<Id>{ '1234' })
    .toList();

List<Account> accounts = [SELECT Id FROM Account];
SOQL.of(Account.SObjectType)
    .byIds(accounts)
    .toList();

SOQL

of​

select​

with field​

with fields​

with string fields​

with related fields​

with subquery​

count​

count field​

count with alias​

scope​

delegatedScope​

mineScope​

mineAndMyGroupsScope​

myTerritoryScope​

myTeamTerritoryScope​

teamScope​

where​

whereAre​

whereAre string​

group by​

groupBy​

groupByRollup​

order by​

orderBy​

orderBy related​

sortDesc​

nullsLast​

setLimit​

offset​

for​

forReference​

forView​

forUpdate​

allRows​

fls​

systemMode​

sharing​

withSharing​

withoutSharing​

mocking​

mockId​

record mock​

list mock​

count mock​

static resource mock​

preview​

result​

toObject​

toList​

toAggregated​

toInteger​

toMap​

toQueryLocator​

predefined​

byId​

byIds​

of

select

with field

with fields

with string fields

with related fields

with subquery

count

count field

count with alias

scope

delegatedScope

mineScope

mineAndMyGroupsScope

myTerritoryScope

myTeamTerritoryScope

teamScope

where

whereAre

whereAre string

group by

groupBy

groupByRollup

order by

orderBy

orderBy related

sortDesc

nullsLast

setLimit

offset

for

forReference

forView

forUpdate

allRows

fls

systemMode

sharing

withSharing

withoutSharing

mocking

mockId

record mock

list mock

count mock

static resource mock

preview

result

toObject

toList

toAggregated

toInteger

toMap

toQueryLocator

predefined

byId

byIds