Query.apex

  • Docs
  • Tutorials
Docs Menu
  • Query class
    • Constructor
    • Result
    • Field Selection
    • Condition
    • Subquery
    • Aggregate Functions

Field Selection Guide

Field selection methods in Query

selectField

public Query selectField(String field)

Select a specific field.

field: API name of the field. Can also be a field of a parent, e.g. 'Owner.Name'.

Query query =
    new Query('Account').
    selectField('Name').
    selectField('Owner.Name');

public Query selectField(Schema.SObjectField field)

Select a specific field.

field: A Schema.SObjectField.

Query query =
    new Query(Account.getSObjectType()).
    selectField(Account.Name).
    selectField(Account.OwnerId);

public Query selectField(String field, String alias)

Select a specific field and set an alias to it.

This method is only available when using aggregate functions.

field: API name of the field. Can also be a field of a parent, e.g. 'Owner.Name'.

alias: Name of the alias.

Query query =
    new Query('Account').
    selectField('Name', 'myName').
    groupBy('Name');

public Query selectField(Schema.SObjectField field, String alias)

Select a specific field and set an alias to it.

This method is only available when using aggregate functions.

field: A Schema.SObjectField.

alias: Name of the alias.

Query query =
    new Query(Account.getSObjectType()).
    selectField(Account.Name, 'myName').
    groupBy('Name');

selectFields

Select specific fields.

public Query selectFields(String field)

field: API name of the field, or multiple field names separated by ','.

Query query =
    new Query('Account').
    selectFields('Name').
    selectFields('OwnerId, CreatedById');

public Query selectFields(List fieldList)

fieldList: A list of field API names.

Query query =
    new Query('Account').
    selectFields(new List{'OwnerId', 'CreatedById'});

public Query selectFields(Set fieldSet)

fieldSet: A Set of field API names.

Query query =
    new Query('Account').
    selectFields(new Set{'OwnerId', 'CreatedById'});

public Query selectFields(Schema.SObjectField field)

Alias of selectField(Schema.SObjectField field)

field: A Schema.SObjectField

Query query =
    new Query(Account.getSObjectType()).
    selectField(Account.Name).
    selectField(Account.OwnerId);

public Query selectFields(Set fields)

fields: A Set of Schema.SObjectField

Query query =
    new Query(Account.getSObjectType()).
    selectFields(new Set{Account.Name, Account.OwnerId});

public Query selectFields(List fields)

fields: A List of Schema.SObjectField

Query query =
    new Query(Account.getSObjectType()).
    selectFields(new List{Account.Name, Account.OwnerId});

selectAllFields

public Query selectAllFields()

Select all accessible fields in the current object

Query query =
    new Query('Account').
    selectAllFields();

public Query selectAllFields(String parentField)

Select all accessible fields in the parent field


Query query =
    new Query('Account').
    selectAllFields('Owner');

Contribute on Github! Edit this section.