Rules

Rules

The rules are use to filter proper data. To create a rule, you can use base fields, properties and functions. You can combine rules to create more sophisticated filter.

Logical operators

• and
• or
• ! - not

Comparison operators

• *< - less than
• > - greater than
• <= - less than or equal to
• >= - greater than or equal to
• = - equal
• <> or != - not equal

Additional comparison operators

• in
• !in

Pattern matching operators (see)

• like - Like pattern
• !like - Does not like pattern
• similar - Similar to regular expression
• !similar - Does not similar to regular expression
• ~ - Matches regular expression, case sensitive
• !~ - Matches regular expression, case insensitive
• ~* - Does not match regular expression, case sensitive
• !~* - Does not match regular expression, case insensitive

Base fields

• id - (Numeric) data id
• tagId - (Numeric) tag id
• owner - (String) the user name that reserved data
• reserved - (Boolean) is data reserved or not
• properties - (JSON) properties defined by users
• createdAt - (Datetime) date and time of creation
• createdBy - (String) the user name that created data
• modifiedAt - (Datetime) date and time of the last modification
• modifiedBy - (String) the user name that last modified data

Properties

Data stored in the properties field. This are defined by users. Use JSON path to refer to the property. Examples:

• $.name - returns the "name" property from root node
• $.address.street - returns the "street" property from "address" subnode

Properties functions

• $.property.exists() - Whether the property exists
• $.property.notExists() - Whether the property not exists
• $.property.isNull() - Whether the property is null
• $.property.isNotNull() - Whether the property is not null
• $.property.length() - the number of elements in the array

Database functions (see)

Generally speaking, these are the functions available in PostgreSQL.

Examples