How to Create a Simple Query

Steps

1. Go to Query List and press the New Simple button.

   The following screen appears with three tabs showing common information like the query category and description. This information is optional. The Simple Query tab is the place where you define the query and the View tab where you define the configuration how to display the results of the query.

   

   Clicking on the Simple Query tab displays the Query definition page. The page is divided into:

   • a Table/View dropdown menu you use to choose a database table or view to predefine your query

   • the Field List where all the fields that you are interested in are listed as a row

   • a Filter List for defining filter conditions for your query

   • the Row Limit textbox to restrict the number of result entries for your query.

   

   The single steps how to construct a simple query are outlined as follows.

2. Select a table from the table list.

   

3. Define the fields you want to see.

   

   The Field Function describes the functionality used for the field. The following table lists the supported values of Field Function.

   Function	Description
   VALUE	Use the current value of the field
   SUM	Accumulate the values of the field
   COUNT	Count the number of values of the field
   MIN	Get the minimum value of the field
   MAX	Get the maximum value of the field
   AVG	Get the average value of the field

   • The Field Name is a field in the selected table.

   • The User Defined Name allows the results to display a more meaningful name.

   • Sort allows to define the sorting order for every field if needed.

4. (Optional) Define Filters.

   You must specify at least one field before you can define filters.

   

   • AND/OR is needed for any filter except the first. This is the logical connection to the previous filter condition.

   • The Field Name is the name of the field to be filtered. If a field has a user-defined name, it is shown in the selection list. Otherwise a generated name is shown.

   • The Condition field specifies the operators that are used to filter the values from the database. The following table lists the supported operators.

   Filter	Symbol	Description	Number of Requirements
   Equal	=	The value must equal the Requirement	1
   Not Equal	<>, !=	The value must not equal the Requirement	1
   Less Than	<	The value must be less than the Requirement	1
   Less Than or Equal	<=, ≤	The value must be less or equal the Requirement	1
   Greater Than	>	The value must be greater than the Requirement	1
   Greater Than or Equal	>=, ≥	The value must be greater or equal the Requirement	1
   Null		The value must be null	0
   Not Null		The value must not be null	0
   Between		The value must be in a specified interval	2
   In		The value must be equal to an element of a specified list	1 or more
   Like		The value must contain the given Requirement	1

   The Requirement field contains a value that is used for filtering the values returned by the query. The following list contains some examples of things that might go into the Requirement field.

   1 AND 100

   For a between condition.

   d%

   For a like condition.

   %d%

   For a like condition.

   %d%e%

   For a like condition.

   Wert-1', Wert-2', ... , 'Wert-n

   For an in condition.

5. (Optional) Limit the number of data sets.

   If you want to limit the number of data sets, select the Limit Query To First check box. Then enter the number of data sets you want returned.

   

6. Click Save to save the query.

   

   The following figure displays the Save this Query As screen. Use the Query Name field to give your query a name, and then click Ok.

   

   After you save your query, you return to a modified version of the Simple Query screen.