Comparisons

Prev Next
This content is currently unavailable in English. You are viewing the default (French) version.

Attributes, properties, quantities, calculated values can all be queried by using comparators.

For all data types



Symbol


Description


Full syntax


=

Equal to

[FEATURE] = [LITERAL]

!=

Not equal to

[FEATURE] != [LITERAL]

IN

In a list of values

[FEATURE] IN (LITERAL1, LITERAL2, LITERALX…)


For numeric values

Symbol


Description


Full syntax


Notes



Symbol


Description


Full syntax


Notes


>

Larger than

[FEATURE] > [LITERAL]

 

>=

Larger than or equal to

[FEATURE] >= [LITERAL]

 

<

Smaller than

[FEATURE] < [LITERAL]

 

<=

Smaller than or equal to

[FEATURE] <= [LITERAL]

 

BETWEEN

Value is between to values

[FEATURE] BETWEEN(LITERAL1, LITERAL2)

Inclusive start, Exclusive end


For string values

All string operations are by default case insensitive. To enforce case sensitive comparisons, you can prefix any string based operator with CS (also =, != and IN can be prefixed with CS)



Symbol


Description


Full syntax


CONTAINS

Whether the feature value contains the given substring.

[FEATURE] CONTAINS [STRING LITERAL]

STARTS_WITH

Whether the feature values starts with the given value.

[FEATURE] STARTS_WITH [STRING LITERAL]

ENDS_WITH

Whether the feature values ends with the given values.

[FEATURE] ENDS_WITH [STRING LITERAL]

MATCHES_REGEX

Whether the feature value matches with the given regular expression.

[FEATURE] MATCHES_REGEX [STRING LITERAL]

LENGTH

Whether the feature value’s string length compares