Diversity Sampling Plots

Query

Once you are connected to your database, you can search across all data. A wide range of search options is available.

All functions related to querying 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, titled “Query Results”.

Below this, you will find a section containing all the buttons relevant to the search.

Below the query buttons, you will find the “Query Conditions” section. This is where you can enter all available search criteria.

Perform a Query

Display the Entire Dataset

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

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

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

Below the query buttons, at the bottom of the query section, you will find the “Query Conditions”.

  1. Enter the filter criteria for your search. For example, you can select a project from the dropdown list.
  2. You can combine as many criteria as needed to narrow down your results.
  3. Start the query by clicking the “Filter” button .
  4. A list of results will be displayed in the “Query Results” section. The number of results is shown above the list, next to the “Query Results” label. If no results match the query, the list remains empty and the label “No match” is displayed.

Edit and Customise Query Conditions

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

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

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

Customise 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 the “Arrow” button .

Switch Between Vertical and Horizontal Arrangement

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

Edit the Result List

Add Results to the Existing List

You can add new results, based on different query conditions, to your current result list.

  1. Enter the new filter criteria for your additional search.
  2. Start the query and add the results to the existing list by clicking the button .
  3. The new results will be 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 remove.
  2. Click the button .

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

Many Result Columns

The option to display a result list with many columns is described in the chapter Many Columns.

Query Conditions

Remember the Last Query

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

Query Annotation

The query for annotations differs from a standard query (see below). In addition, you can specify the type of annotation (Annotation , Problem , Reference ) and the linked table (see Annotation).

Duplicates

Certain query condition fields allow you to add up to three duplicates of the same condition. For adding a ‘duplicate’ search criteria, click 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 switch between these modes, click the resp. + or | icon.

Query Modules

In the “Query Conditions” section, some values may be linked to other modules. For example, within the “Identification” group, the fields “Taxa” and “Terms” are linked to the “DiversityTaxonNames” and “DiversityScientificTerms” modules, respectively. You can also add “linked” values to your query condition.

  1. Select the operator that determines how the entries are used in the search. An explanation of all available operators can be found in the table below.
  2. To connect to the linked module, click the “Ammonite” button located to the right of the relevant query field.

  1. A query window for the linked module will open.
  2. Search for values within the linked module and click “Ok” to confirm your section.
  3. If you want to view a list of the selected items, click the Magnifying Glass button .

Info: There is also a detailed Video 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.

Videos

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

Wildcards in SQL

There are 4 different possibilities for wildcards in SQL:

Operator Description Example Result
%   any string consisting of no, one or many characters Pinus % will find anything like Pinus, Pinus sylvestris, Pinus strobus etc.
*  same effect as % (see above)
_  a single character Pinus s_lvestris will find Pinus sylvestris and Pinus silvestris etc.
[…] any character out of a given range like [abcde] or [a-e] Pinus s[iy]lvestris will find Pinus sylvestris and Pinus silvestris
[^…]   any character not in a given range like [^abcde] or [^a-e] Pinus s[^i]lvestris will find Pinus sylvestris but not Pinus silvestris

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: Video starten
  • Sortierung: Video starten

 

Oct 26, 2026

Subsections of Query

Tutorial Query

Tutorial - query

To search for data in the database, use the query section in the left part of the window. To select the query conditions, click on the button in the top panel. A window as shown below will open.

 

With the Maximal number of results, you can limit the paket size that should be retrieved from the server. For a slow connection to the database server choose a low value (e.g. 100 as set by default).

Select the desired entries, e.g.:

 

Click OK to close the window. Your query conditions will look like the image below.

Within the query options you have several possibilities to specify your search restriction. Use the drop down button to change between the operators.

If the hierarchy operator Δ is selected, you may choose a desired hierarchy node by clicking at the drop down box on the right. Then a tree view of the current hierachy pops up, where you can select a given node with the mouse:

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

Oct 26, 2026

Tutorial Query Results

Tutorial - query results

Pressing the Filter button will display all plots in the list box which matches the query conditions and the selected maximal number of results:

Query results

The kind of entries to be shown can be selected in the “order by” list box. They may be the plot identifiers, the plot descriptions or the plot hierarchy strings.

The data of the selected plot (identifier, description, ID, type, notes etc.) is displayed right of the query area. If a geography has been assigned, the place is shown on the map in the middle. The plot identifier is marked with yellow background, embedded in the hierarchy tree in the box below the map.

Query results