JoinQuery
of
Conctructs an JoinQuery
.
Signature
static JoinQuery of(sObjectType ofObject)
Example
SOQL.InnerJoin.of(Account.sObjectType)
SOQL.InnerJoin.of(Contact.sObjectType)
field
SELECT
statement that specifies the fields to query.
Signature
static JoinQuery with(sObjectField field)
Example
SOQL.InnerJoin.of(Contact.sObjectType).with(Contact.Account.Id)
whereAre
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 QB.FiltersGroup
and QB.Filter
Signature
static JoinQuery whereAre(FiltersGroup conditions)
Example
SOQL.InnerJoin.of(Contact.sObjectType)
.whereAre(SOQL.Filter.with(Contact.Name).equal('My Contact'))