Last updated: 5/15/2025
Queries
Each module provides a set of preconfigured queries based on a set of terms. The queries return objects and the terms are attributes of the object.
Search Operators
The query will provide one or more fields that are combined into a logical expression. The fields apply one of the following search operators.
| Operator | Description |
|---|---|
| = | equal to |
| > | greater than |
| < | smaller than |
| >= | greater or equal to |
| <= | smaller or equal to |
| STARTSWITH | string value start with |
| LIKE | like equal to but case insensitive |
Wild cards
The search fields can use wild cards.
| Wild card | Description |
|---|---|
| * | matches one or more characters in the string |
| ? | matches one one character in the string |
For example: "Work package order advanced search" in the "Work package order" module as shown below uses a logical combination of the Work package order advanced fields shown in a search.
The query logic can be expressed as shown in the table below.
| AND/OR | AND/OR | Field | Operator | |
|---|---|---|---|---|
| id | LIKE | |||
| OR | name | LIKE | ||
| OR | status | LIKE |
This format will be used to document queries in the modules.
Note
As a user you can copy these query definitions and configure them according to your requirements.