External Home
Introduction
Home Page
Calendar
Customs
New Movement
Tech Report
Aircraft Logs
Instructions
Logbook
Online Shop
Your Bills
Profile
Links
Documents
Help
Quick Search
History
Grid
Queries / Search
Integration
Queries / Search
Every query field above a list can contain a simply text to be searched on most if not all the fields, or a "complex" query in the form of: <field> <operator> <value>
The allowed operators are
| Operator | Effect |
|---|---|
| = | An exact match search |
| is | An exact match search |
| < | The value must be smaller than the searched one |
| <= | The value must be smaller or equal than the searched one |
| > | The value must be greater than the searched one |
| >= | The value must be greater equal than the searched one |
| <> | The value must not be the searched one |
| starts | The value must starts with the searched one |
| not starts | The value must not starts with the searched one |
| ends | The value must end with the searched one |
| not ends | The value must not end with the searched one |
| contains | The value must contains the searched one |
| not contains | The value must not contains the searched one |
| between <x> and <y> | The value must be within (inclusive) X and Y |
Multiple conditions can be linked via the operators <or> and <and>.
Parenthesis allow to define the order of operation for multiple conditions.