Comparison Operators

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

Equal to (`=`)

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

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

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

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

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