Search syntax

Introduction

Simple search syntax for search filters is a plain character string including, if required, search SQL-like wildcards:

Date fields search filter syntax is YYYY-MM-DD

Date time fields search filter syntax is YYYY-MM-DD hh:mm:ss

An advanced syntax is also available for most field types to proceed with more complex searches: its syntax uses SQL-like statements (see bellow).

Simple or advanced filters can be used in all search features:

Advanced syntax

Advanced syntax is a combination of the following comparators that do requires simple quotes to enclose all textual values (not required for number values)

Comparators can be combined with logical operators:

Parenthesis can be used for complex combinations, e.g.: ='value1' or (like 'value2%' and is not null).