Diversity Agents

Query

Once you are connected to your database, you can search across all data. You have a wide range of options for this search.

Everything related to the query can be found on the left-hand side of the main window.

The upper part of the query section contains the list of all results “Query results”.

Below this you will find a section with all the buttons that are relevant for the search.

Under the query buttons you will find the “Query conditions”. You can enter all possible search criteria here.

Perform a query

Display the entire data set

To display the entire data set, start a search without specifying any criteria in the “Query conditions” section:

1. In the middle of the query section on the left side of the main window, click on the “filter” button.

2. A list of the results is displayed in the “Query results” section. The number of results is displayed above the list next to the “Query results” label.

Filter a search

Unter the query buttons, at the bottom of the query section, you will find the “Query conditions”.

1. Enter the filter criteria for your search. E.g. you can select a project from the dropdown list.
2. You can combine as many criteria as you want to limit your results.
3. Start the query by clicking on the filter button .
4. A list of the results is displayed in the “Query results” section. The number of results is displayed above the list next to the “Query results” label. If no result matches the query, the list is empty and the label “No match” is displayed.

Edit and customize query conditions

You can choose which query conditions are displayed in the main window. You can change this at any time.

1. At the top left above the query results list, click on the “checkbox” button .

2. Select any query conditions you want to use for your searches by selecting the respective checkboxes in the treeview.

Customize the interface

Hide/show the entire query section

In the main window go to the menu item Query → Show Query.

Hide the “Query conditions” section

On the left side of the “query buttons” in the middle of the query section, click on the “arrow” button .

Switch vertical/horizontal arrangement

You can change the arrangement of the query elements from vertical to horizontal and vice versa. To do this, click on the button below the main menu bar:

Edit the result list

Add results to the existing list

You can add new results with different query conditions to your current result list.

1. Enter the new filter criteria for your additional search.
2. Start and add these query results to the existing result list by clicking on the button .
3. The new results are appended to the existing list.

Remove result items from the list

You can remove entries from your current result list.

1. Select the entries you want to delete.
2. Click on the button .

Important This will not delete the data from the database. It only affects the current display in the results list.

Many result columns

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

Query conditions

Remember the last query

By default the values you entered for the query will be remembered. Your query criteria will be pre-filled when the program starts. To change this behaviour, click on the button .

Query annotation

The query for annotations deviates from the standard query (see below). Additionally, you may specify a type of the annotation (Annotation , Problem , Reference ) and the linked table (see Annotation).

Duplicates

Certain query condition fields provide the option to add up to 3 duplicates of themselves. For adding a ‘duplicate’ search criteria, click on the green “Plus” button . Remove a ‘duplicate’ search condition with a click on the red “Minus” button . The restrictions can be combined with AND + and OR |. To change between the modes click on the + resp. | icon.

Query modules

In the “Query conditions” section, some values might be linked to other modules. E.g. within the “Identification” group the fields “Taxa” and “Terms” are linked to the “DiversityTaxonNames” and “DiversityScientificTerms” modules. You can also add “linked” values to your query condition.

1. Select the operator that determines how the entries are integrated into the search. See an explanation of all available operators in the table below.
2. To connect to the linked module, click on the “Ammonite” button at the right of the respective query field.

2. A query window for the linked module will open.
3. Search for values within the linked module and click ok.
4. If you want to see a list of the selected items, click on the magnifying glass button .

Info: There is also a detailed available, which explains all possible operators and how to use them.

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 hierarchy	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.

Query any fields

The query for any fields will search in several fields, e.g. withholding reasons in specimen, images etc. There are two versions: The first version (e.g. Notes) will search in all tables but not in collection event tables while the second version (e.g. Any notes) will search in any table (see image below).

Videos

• Introduction how to use the query conditions:
• How to use special query conditions:
• Tutorial on how to query modules:
• Tutorial on how to save a query: .

Wildcards in SQL

There are 4 different possibilities for wildcards in SQL:

Many colunns

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.

For an introduction see the videos:

• Mehrspaltige Suche:
• Sortierung: