Query

The options for a plot search are displayed in the main window 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 plots enter the restrictions in the fields for the query conditions and click on the button. The plots found in the database will be shown in the results list. To add plots with differing search conditions click on the button. To clear all entries in the query fields use the button. You can 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 can browse the next items with the button. To move back to the previous block of items click on the button. If you want 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. To select all entries in the list click on the button. With the resp. buttons you can change the order of the results between ascending and descending. To blind out the query options and get more space for the item list press on the left side of the buttons. To show them again press the button.

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
| search within a list of entries, separated by "|" 2000 | 2003 | 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 within a list of entries, separated by "|" 2000 | 2003 | 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 all entries ...
search for entries without hierarchy ...
search for entries with hierarchy ...
Δ search including childs in a hierarchy ... GER-berlin

For a search within a list (using the "|" operator) you can double click in the textfield to open a window to enter your values. To separate the values either use the "|" sign or a new line as shown in the image below.

After all query conditions are set, click on the button to start the query. In the result list all plots will be displayed which matches your query and the selected maximal number of results.