Child pages
  • Defining a Data Model

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Each key pair expression is evaluated using a single operator. Certain operators are only applicable to certain data types. Below is a list of all available operators and the data types for which they are applicable.

Operator

Description

Data Types

=

Equals

Text, Integer, Number, Datetime, UUID, Array (in)

>

Greater Than

Text, Integer, Number, Datetime

<

Less Than

Text, Integer, Number, Datetime

>=

Greater Than or Equal To

Text, Integer, Number, Datetime

<=

Less Than or Equal To

Text, Integer, Number, Datetime

!=

NOT Equal To

Text, Integer, Number, Datetime, UUID, Array (not in)

like

SQL Like use with '%' wildcards

Text

not like

SQL Not Like use with '%' wildcards

Text

Operator modifiers

Modifiers can be defined for an operator, multiple modifiers can be combined for a relation item.

Modifier

Description

case-insensitive

case-Insensitive comparison

or-is-null

allow null values in the value (will result in sql <cond> or column is null)

remove-when-null

remove the condition when the value is null, this is usually used

for

icw a global variable holding an array of values



Note

Text-Based Expressions

Expressions which contain the SQL Like or SQL NOT Like operators should be used in conjunction with values that contain wildcards (%).

Code Block
customers.city like New% 	// Starts with: i.e. New York, New Orleans
customers.city like %Villa% 	// Contains: i.e. Villa Nova, La Villa Linda
customers.city like %s      	// Ends with: i.e. Athens, Los Angeles


...