Query

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