The options for a search are displayed in the main form
beneath the list of the items. You can change this arrangement using the /
button to place the query
options on the left side of the item list.
To search for projects
enter the restrictions in the
fields for the search conditions and click
on the
button. The projects found in the database
will be shown in the specimen list.
To add projects with differing search
conditions click on the
button. To clear all entries in the query fields use the
button. You may save and load the
queries you define using the
and
buttons.
If the list of items is longer than your maximal number of
returned items,
you may browse the next items with the
button. To move back to the previous block of items click on the
button. If you wish to remove entries from the selected list,
choose them and click on the
button.
This will not delete the data from the
database, but remove them from your
query result. With the
and
buttons
you may change the order of the
results between ascending and
descending
To speed up the query you may use the optimized version (Standard query: Optimized query:
)
Within the query options you have several possibilities to specify your search restriction. Use the drop down button to change between the operators. The available operators are shown in the table below.
Operator | Meaning | Example |
---|---|---|
Text | ||
∼ | search for an entry like ... | Pinus s[iy]lvestris % (you can use wildcards) |
= | search for an entry exactly equal to ... |
Pinus silvestris L. |
≠ | search for an entry not like ... | Pinus s[iy]lvestris % (you can use wildcards) |
∅ | search for an entry where a value is missing ... | |
| search for an entry where a value is present ... | |
- | search for an entry between ... and ... | 2000 - 2005 |
Numeric | ||
= | search for an entry exactly equal to ... | 2006 |
< | search for an entry lower than ... | 2006 |
> | search for an entry bigger than ... | 2006 |
- | search for an entry between ... and ... | 2000 - 2005 |
∅ | search for an entry where a value is missing ... | |
| search for an entry where a value is present ... | |
Date | ||
= | search for an entry exactly equal to ... | 20.3.2006 |
< | search for an entry lower than ... | 20.3.2006 |
> | search for an entry bigger than ... | 20.3.2006 |
∅ | search for an entry where the date is missing ... | |
| search for an entry where the date is present and complete ... | |
Hierachy | ||
= | search for an entry exactly equal to ... | M-Fungi |
≠ | search for an entry that is not equal to ... | M-Fungi |
∅ | search for missing entry ... | |
| search for present entry ... | |
Δ | search including childs in a hierarchy ... | M-Fungi |
XML | ||
/ | Search for entries containing a given XML node | settings |
¬ | Search for entries not containing a given XML node | settings |
∅ | search for missing entry ... | |
| search for present entry ... |
To hide the area containing the search fields
click on the button. If the search
area is hidden and you want to start a new search, just click on the
button.
To change the displayed fields for searching specimen click on the
button to change the query options .