Query Expressions

The COMAND query languages (cPath, cQL, cQuery) share some common syntax to reference fields and perform operations.

Dot-Notation

Dot notation is used to reference object field values. A chain of fields can be specified to traverse an object field hierarchy. Each object field in the chain is separated by a dot.

For example, the following cQL uses dot-notation to reference the Name field of an object in the State field of an object in the Address field of a Contact object.

SELECT Address.State.Name FROM Contact

Collection Indexes

• [x] - 0 based index
• [-x] - Index from end
• [x..y] - Range

Operations

See cQL WHERE documentation and source code for list of support operations.

Comparison Operators

• = - Equal
• != - Not equal
• < - Less than
• <= - Less than or equal
• > - Greater than
• >= - Greater than or equal

Logic Operators

• AND - Logical AND
• OR - Logical OR
• NOT - Logical NOT

Arithmetic Operators

• + - Addition
• - - Subtraction
• * - Multiplication
• / - Division
• % or MOD - Modulo

Bit Operators

Functions

See source code for list supported functions.

• < cQuery
• Scripts >