Comparison Operators

All comparison operators are available in all versions. You can use comparison operators in the WHERE clause.

Equal to (=)

Section link for Equal to (=)

Copy to clipboard

SELECT id, user_name__v, security_profile__v
FROM users
WHERE user_locale__v = 'es_US'

Not Equal to (!=)

Section link for Not Equal to (!=)

Copy to clipboard

SELECT label__sys, due_date__sys
FROM active_workflow_task__sys
WHERE status__sys != 'available__sys'

Less than (<)

Section link for Less than (<)

Copy to clipboard

SELECT id, document_number__v
FROM documents
WHERE document_creation_date__v < '2016-04-23'

Greater than (>)

Section link for Greater than (>)

Copy to clipboard

SELECT id, site_status__v, location__v
FROM site__v
WHERE modified_date__v > '2016-04-23'

Less than or Equal to (<=)

Section link for Less than or Equal to (<=)

Copy to clipboard

SELECT id, document_number__v
FROM documents
WHERE version_modified_date__v <= '2016-04-23T07:30:00.000Z'