Diversity Collection

Tutorial

Query

To search for data in the database, use the query area in the left panel (see the image below). You can query almost any field in the database. You can also customize the view and specify the query options you want.

Structure of the query panel

All fields belonging to the query are displayed in the query area in the left panel (see figure above).

  1. In the lower area (see point 1 in the image above), you can enter your query criteria, such as selecting a project and specifying an accession number. You can also specify which query fields are displayed (see section Customize your query conditions).

  2. In the middle area (see point 2 in the image above) you will find all buttons that trigger a search etc.

  3. The results are listed in the upper panel (see point 3 in the image above). If you select a result by clicking on it, all details are displayed in the panels to the right of the query.

For more detailed information, see the chapter Query.

Customize your query conditions

  1. To customize and set your query conditions click on the button in the top panel (see point 4 in the image above).

  2. A window will open as shown below.

     

With the Maximum number of results you may limit the package size which 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).

The Limit for drop-down lists restricts the maximum number of drop-down lists which should be created. For a slow connection to the database server choose a low value. The default is set to 0 which means no drop-down lists will be created.

Click on the Check none button to clear the previous selection. Then select the entries

  • Project → Project
  • Specimen → Accession number of specimen
  • Specimen → The user who created the data set
  • Specimen → The date when the data set was created
  • Event → Collection date
  • Organism → Organism present
  • Organism → Only observed
  • Storage → Material category
  • Image → Type

Click OK to close the window. Your query conditions will be displayed as in the image below.

Project → Project: Here you may choose from a list of possible entries. Select your current project.

Collection specimen → Acc. Nr.: From the operator drop-down list choose “~” and enter the first letters of your accession number. You may include wildcards. Other options are e.g. “-” for a range or “>” for a lower limit. The conditions will be interpreted as text! So 2 will be listed after 10 etc.

Collection specimen → Creat. by.: From the operator drop-down list choose “=” and choose your user name from the list.

Collection specimen → Cre. dat.: From the operator drop-down list choose “=” and choose the current date with the help of the calendar.

Collection event → Date: >From the operator drop-down list choose “=” and enter the current year in the last field.

Organism → Presence: From the operator drop-down list choose “•” which means that an organism is present.

Organism → Only obs: Uncheck the checkbox to find organisms which were not only observed.

Part of a specimen → Mat.cat.: Use the button on the right of the combobox to open the hierarchy and select “herbarium sheet”.

After all query conditions are set, click on the button to start the query. In the result list you should find the specimen created in this tutorial. If the remember query option is a activ, the last query will be saved and is availabel after a restart.