Operator |
Column type |
Example |
Matches |
|
Text |
Arg |
all entries containing 'Arg' |
space |
Text |
Arg Ser |
all entries containing 'Arg' and 'Ser' |
| |
Text |
Arg|Ser |
all entries containing 'Arg' or 'Ser' |
! |
Text |
!fs |
all entries not containing 'fs' |
^ |
Text |
^p.(Arg |
all entries beginning with 'p.(Arg' |
$ |
Text |
Ser)$ |
all entries ending with 'Ser)' |
="" |
Text |
="" |
all entries with this field empty |
="" |
Text |
="p.0" |
all entries exactly matching 'p.0' |
!="" |
Text |
!="" |
all entries with this field not empty |
!="" |
Text |
!="p.0" |
all entries not exactly matching 'p.0?' |
combination |
Text |
*|Ter !fs |
all entries containing '*' or 'Ter' but not containing 'fs' |
|
Date |
2020 |
all entries matching the year 2020 |
| |
Date |
2020-03|2020-04 |
all entries matching March or April, 2020 |
! |
Date |
!2020-03 |
all entries not matching March, 2020 |
< |
Date |
<2020 |
all entries before the year 2020 |
<= |
Date |
<=2020-06 |
all entries in or before June, 2020 |
> |
Date |
>2020-06 |
all entries after June, 2020 |
>= |
Date |
>=2020-06-15 |
all entries on or after June 15th, 2020 |
combination |
Date |
2019|2020 <2020-03 |
all entries in 2019 or 2020, and before March, 2020 |
|
Numeric |
23 |
all entries exactly matching 23 |
| |
Numeric |
23|24 |
all entries exactly matching 23 or 24 |
! |
Numeric |
!23 |
all entries not exactly matching 23 |
< |
Numeric |
<23 |
all entries lower than 23 |
<= |
Numeric |
<=23 |
all entries lower than, or equal to, 23 |
> |
Numeric |
>23 |
all entries higher than 23 |
>= |
Numeric |
>=23 |
all entries higher than, or equal to, 23 |
combination |
Numeric |
>=20 <30 !23 |
all entries with values from 20 to 29, but not equal to 23 |