Query

Visibility

The query containing results and fields is positioned a the left of the window. To visibility of the query can be set in the menu: Query - Show query:

The query fields are displayed in the main form beneath the list of the result items. You can change this arrangement using the  /  button to place the query fields on the left side of the item list.

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.

Searching

To search for data, enter the restrictions in the fields for the search conditions and click on the  button. The agents found in the database will be shown in the list. To add agents with differing search conditions 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.

The option to provide a result list with many columns is described in chapter Many result columns.

To change the displayed fields for searching data click on the  button to change the query options. 

A window will open containing the command used to retrieve the data (see below).

To keep the values you entered for the query, you can click on the button. It will change to and when restarting the program your query values will be remembered

To speed up the query you may use the optimized version (Standard query: Optimized query: ). The optimized query in combination with the remembering option includes the functionality to preselect data depending on the query restrictions, e.g. if you search for an identification and enter a taxonomic name the first identification matching the restrictions will be preselected in the main window as shown below.

The set the option for optimized queries and the option to remember the query settings as default, choose Administration - Customize display... from the menu. In the tab Defaults and miscellaneous select the Optimized and Remember option. The buttons in the query will be hidden providing more space. 

Certain query fields provide the option to add up to 3 duplicates of themselves. Use the button to add and the button to remove duplicates. The restrictions can be combined with AND + and OR |. Just click on the + resp. | sign to change between the modes.

Within the query options you have several possibilities to specify your search restriction. Use the drop-down menu to switch between operators. The available operators are shown in the tables below.
Availability: t = text, n = numeric, d = date, h = hierarchy, x = XML, e = EXIF, g = geography, a = annotation, m = module
For an introduction see two short tutorials

Query operators

Operators for text

Operators for numeric data

Operators for date values

Oparators for hierachy

Operators for XML

Operators for geography

Use (via local files or manual creation) resp. (via DiversityGazetteer) button to set geography

For yes/no fields exists a checkbox with 3 options: = yes, = no, = undefined

For a search within a lists (using the |, ∈ or ∉ operator) you may double click in the text field to open a window where you can enter your values. To separate the values either use the "|" sign or a new line as shown in the image below.

Query modules

In the query for values linked to another module click on the button to open a window where you can search for values within the linked module. A click on the button will show a list of the selected items. For some modules you can choose the cache database as source (if you have the proper permissions). This option provides a faster query esp. if e.g. the data of a related module are accessed via a linked server.

Tutorial:

Operator	Meaning	Example
∈	Search for entries with a list	Rosa | Rosa caninia \
∉	Search for entries not within a list	Rosa | Rosa caninia | ...
+H	search for entry including lower ierarchy	Picea | Picea abies | ...
+S	search for entry including synonyms	Picea abies | Pinus abies | ...
+HS	search for entry including lower hierarchy and synonyms	Picea | Picea abies | Pinus abies | ...
	Change filter mode between link and text	http://tnt.diversityworkbench.de/TaxonNames_Plants/4269 <> Picea abies L.

Wildcards in SQL

There are 4 different possibilities for wildcards in SQL:

Many columns

The option to include several columns in the result list is only available for optimized queries . To display several columns in the result list, click on the button next to the order by column (see below). A window will open where you can select the next column for the sorting. Underneath the order by column the second column for the sorting will be added. To remove this sorting column you can click on the    button. By default the width for the columns is set to 10. You can change this according to content. To set the width to the maximal length of the current content, click on the button. To change the sorting of the added order column click on the button. The colums are separated via " | " as shown in the image below.