Fields in query
-
Take one field from the left and drag it to the template area (add item).
-
Click on the field in the template area to see the properties on the right.
The general properties of the field types are mostly the same, except for the Operations settings.
Hover the mouse on top of the number or click on it to see the details for the given group of fields.
Hover the mouse on top of the number or click on it to see the details for the given group of fields.
The operations differ per field type, all of them are listed in the following table:
Field type
|
Operations
|
A
|
Value is; Value is not; Value is undefined; Value is duplicated.
|
Alink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Value is; Value is not; Value is undefined; Value is duplicated.
|
C
|
Value is; Value is not; Value is undefined; Value is duplicated.
|
Clink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Value is; Value is not; Value is undefined; Value is duplicated.
|
D
|
'='; '<'; '<='; '>'; '>='; '≠'; Is in list: (ex: 2...5;18;41); Value is duplicated; Value is undefined.
|
Dlink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; '='; '<'; '<='; '>'; '>='; '≠'; Is in list: (ex: 2...5;18;41); Value is duplicated; Value is undefined.
|
E
|
Starts with...; Contains; Matches exactly; Value is duplicated; Value is undefined.
|
Elink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Starts with...; Contains; Matches exactly; Value is duplicated; Value is undefined.
|
F
|
Starts with...; Contains; Matches exactly; Value is duplicated; Value is undefined.
|
Flink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated.
|
G
|
-not available for the query-
|
Glink
|
-not available for the query-
|
H
|
Date is equal to; Is before; Is after; Is in the range; Year is; Month is; Day of month is; Value is duplicated; Value is undefined.
|
Hlink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Date is equal to; Is before; Is after; Is in the range; Year is; Month is; Day of month is; Value is duplicated; Value is undefined.
|
I
|
'='; '<'; '<='; '>'; '>='; '≠'; Is in list: (ex: 2...5;18;41); Value is duplicated; Value is undefined.
|
Ilink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; '='; '<'; '<='; '>'; '>='; '≠'; Is in list: (ex: 2...5;18;41); Value is duplicated; Value is undefined.
|
K
|
Value is similar (±5%) to; Value is similar (±10%) to; Value is similar (±20%) to; Value is duplicated; Value is undefined.
|
Klink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Value is similar (±5%) to; Value is similar (±10%) to; Value is similar (±20%) to; Value is duplicated; Value is undefined.
|
L
|
Value is; Value is duplicated; Value is undefined.
|
LLink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Value is; Value is duplicated; Value is undefined.
|
M
|
Min ≤ value ≤ Max; Min ≥; LP ≥; HP ≥; Max ≥; Min ≤; LP ≤; HP ≤; Max ≤; LP ≤ value ≤ HP; Value is duplicated; Value is undefined.
|
Mlink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Min ≤ value ≤ Max; Min ≥; LP ≥; HP ≥; Max ≥; Min ≤; LP ≤; HP ≤; Max ≤; LP ≤ value ≤ HP; Value is duplicated; Value is undefined.
|
N
|
Starts with...; Contains; Matches exactly; Value is duplicated; Value is undefined.
|
Nlink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Starts with...; Contains; Matches exactly; Value is duplicated; Value is undefined.
|
O
|
Name starts with ...; Starts with (+ children)...; Name contains; Contains (+ children); Name matches exactly; Matches exactly (+ children); Is root; Value is duplicated; Value is undefined.
|
Olink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Name starts with ...; Starts with (+ children)...; Name contains; Contains (+ children); Name matches exactly; Matches exactly (+ children); Is root; Value is duplicated; Value is undefined.
|
R
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated.
|
S
|
Min ≤ value ≤ Max; Min ≥; LP ≥; HP ≥; Max ≥; Min ≤; LP ≤; HP ≤; Max ≤; LP ≤ value ≤ HP; Value is duplicated; Value is undefined.
|
Slink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Min ≤ value ≤ Max; Min ≥; LP ≥; HP ≥; Max ≥; Min ≤; LP ≤; HP ≤; Max ≤; LP ≤ value ≤ HP; Value is duplicated; Value is undefined.
|
Syn
|
Name starts with...; Starts with (+ synonyms)...; Name contains; Contains (+ synonyms); Name matches exactly; Matches exactly (+ synonyms).
|
Synlink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; Name starts with...; Starts with (+ synonyms)...; Name contains; Contains (+ synonyms); Name matches exactly; Matches exactly (+ synonyms).
|
T
|
'='; '≠'; Value is duplicated.
|
Tlink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; '='; '≠'; Value is duplicated.
|
U
|
Starts with...; Contains; Matches exactly; Value is duplicated; Value is undefined.
|
V
|
'='; '≠'; Value is duplicated.
|
Vlink
|
Target record name starts with; Target record name contains; Target record name is; Target record name is undefined; Any text field of target record starts with; Any text field of target record contains; Any text field of target record is; Any text field of target record is undefined; Target record ID (or specific search) is; Link is empty; Link is duplicated; '='; '≠'; Value is duplicated.
|
W
|
-not available for the query-
|
Wlink
|
-not available for the query-
|
Y
|
-not available for the query-
|
| |
Starts with...; Contains; Matches exactly; Value is duplicated; Value is undefined.
| |
Record name
|
Starts with...; Contains; Matches exactly; Value is duplicated; Value is undefined.
|
Record ID
|
'='; '<'; '<='; '>'; '>='; '≠'; Is in list: (ex: 2...5;18;41);
|
Creator user name
|
User name starts with...; User name contains...; User name exact match; User property starts with...; User property contains...; User property exact match; User search; Current user.
|
Last change user name
|
User name starts with...; User name contains...; User name exact match; User property starts with...; User property contains...; User property exact match; User search; Current user.
|