BioloMICS logo
×
BioloMICS Web Menu

Fields in query

 
In the query of the template management, fields in the selected table can be added.
 
 
  • 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.
 
 
Fields in query
 
 
 
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-
 
Any text field
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.
 
 
 
1
1.
 
  • Field name: Define a name for the field.

        
     
2
2.
 
  • Operations: This varies per field type (see table Operations).

         
     
  • Default operation: Decide which operation is by default selected when (re)loading the page.
     
3
3.
  • Placeholder: Temporary text displayed when the value field is selected but no value is inserted yet.

        
     
  • Hint text: Text that will be displayed just under the value section to instruct the end user.
     
            
     
  • Tooltip: Create a tooltip to help the end user while navigating inside the website.
     
            
     
4
4.
 
This options is only available for link fields.
 
  • Filter template: The query template used as a filter for the auto-completion.
     
  • Search term minimum length: The minimum number of characters to type to trigger the auto-completion option.
     
5
5.
 
  • Include in advanced search: If checked, the advanced search option is enabled inside the website.

        
     
  • Visible by default: If checked, the field will be automatically visible in the advance query lines.
     
6
6.
 
  • Include in simple search: If checked, the simple search option is enabled inside the website.
        
     
  • Include in quick search: The criteria 'Any text field' has the option to be added to the quick search.