How to query this table
All list views have search fields which can be used to search data.
You can search for a complete word or you can search for a part of a search term.
If you enclose two or more words in double quotes, LOVD will search for the combination of those words only exactly in the order you specify.
Note that search terms are case-insensitive and that wildcards such as * are treated as normal text!
For all options, like "and", "or", and "not" searches, or searching for prefixes or suffixes, see the table below.
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
Some more advanced examples:
Example
Matches
Asian
all entries containing 'Asian', 'asian', including 'Caucasian', 'caucasian', etc.
Asian !Caucasian
all entries containing 'Asian' but not containing 'Caucasian'
Asian|African !Caucasian
all entries containing 'Asian' or 'African', but not containing 'Caucasian'
"South Asian"
all entries containing 'South Asian', but not containing 'South East Asian'
To sort on a certain column, click on the column header or on the arrows.
If that column is already selected to sort on, the sort order will be swapped.
The column currently sorted on has a darker blue background color than the other columns.
The up and down arrows next to the column name indicate the current sorting direction.
When sorting on any field other than the default, LOVD will sort secondarily on the default sort column.
