WHERE conditionExpression

conditionExpression

The conditionExpression of the WHERE clause uses the following syntax:

fieldExpression [logicalOperatorfieldExpression2 ... ]

You can add multiple field expressions to a condition expression by using logical operators.

• You can use parentheses to define the order in which fieldExpressions are evaluated. For example, the following expression is true if fieldExpression1 is true and either fieldExpression2 or fieldExpression3 are true:

  fieldExpression1 AND (fieldExpression2 OR fieldExpression3)

• However, the following expression is true if either fieldExpression3 is true or both fieldExpression1 and fieldExpression2 are true.

  (fieldExpression1 AND fieldExpression2) OR fieldExpression3

• Client applications must specify parentheses when nesting operators. However, multiple operators of the same type do not need to be nested.

fieldExpression

A fieldExpression uses the following syntax:

fieldName comparisonOperator value
                    

where:

Comparison Operators

The following table lists the comparisonOperator values that are used in fieldExpression syntax. Note that comparisons on strings are case-insensitive.

SELECT AccountId, FirstName, lastname
FROM Contact
WHERE lastname LIKE 'appl_%'

SELECT Name FROM Account
WHERE BillingState IN ('California', 'New York')

SELECT Name FROM Account
WHERE BillingState NOT IN ('California', 'New York')

Logical Operators

The following table lists the logical operator values that are used in fieldExpression syntax:

SELECT Id FROM Contact WHERE LastName = 'foo' or Account.Name = 'bar'

Quoted String Escape Sequences

You can use the following escape sequences with SOSL:

If you use a backslash character in any other context, an error occurs.

Example WHERE Clauses

FIND {test}
    RETURNING Account (id WHERE createddate = THIS_FISCAL_QUARTER) 

FIND {test}
    RETURNING Account (id WHERE cf__c includes('AAA')) 

FIND {test}
    RETURNING Account (id), User(Field1,Field2 WHERE Field1 = 'test' order by id ASC, Name DESC) 

FIND {test} IN ALL FIELDS
    RETURNING Contact(Salutation, FirstName, LastName, AccountId WHERE Name = 'test'),
        User(FirstName, LastName),
        Account(id WHERE BillingState IN ('California', 'New York')) 

FIND {test}
    RETURNING Account (id WHERE (Name  = 'New Account' and ((not Id = null) or Id != null))
        or (Id = '001z00000008Vq7'
        and Name = 'Account Insert Test')
        or (NumberOfEmployees < 100 or NumberOfEmployees = null)
        ORDER BY NumberOfEmployees)

FIND {tourism}
    RETURNING KnowledgeArticleVersion (Id, Title WHERE id = 'ka0D0000000025eIAA')

FIND {tourism}
    RETURNING KnowledgeArticleVersion
        (Id, Title WHERE id IN ('ka0D0000000025eIAA', 'ka0D000000002HCIAY'))