Document Viewer

« Back

Hands-On: Query Configuration

Query Configuration Hands-On

Define Menu Item

The creation of a new analysis query is defined through following steps:

  1. Create query
  2. Define input fields
  3. Define AQL-queries
  4. Define result attributes

For all of these steps there is a chapter in the dialog.

 

 

Before creating a new predefined query, it is necessary to put it manually together and test it in the ADOxx-Modelling Toolkit with the „Query/reports" function. By using this approach you get also the AQL code which is necessary in the later procedure.

 

Define Query Appearance

Mark the new query Switch to Chapter „Input fields"

 

Define input fields

Each query consists of an individual set of parts:

  • Text
  • Input Field
  • Enumeration Field
  • Attribute Value Field
  • Attribute Enumeration Field
  • Attribute Field
  • Class Field
  • Relation Field

 

The following types of fields are available:

  • Input fields: For Attributes of type Text (STRING, LONGSTRING), time (TIME), date (DATE), date and time (DATETIME), integer (INTEGER) und double (DOUBLE).
  • Enumeration value field: For attributes of Type enumeration (ENUMERATION) und enumerationlist (ENUMERATIONLIST).
  • Attribute value field: For the takeover of attribute values from attributes of different classes.
  • Enumerated attribute field: For the takover of attribute values from enumerated attributes of different classes.
  • Attribute field: For choosing of attributes from a list of all attributes of all classes.
  • Class field: For choosing of a class from a list of all classes of the active modeltype.

 

Define AQL-Queries

To make your query functional, it is necessary to deposit it as an AQL-query.

  1. Switch to the chapter "AQL expressions"
  2. Choose option "AQL Part"
  3. Copy manually designed AQL statement
  4. Add "References" to linkinput fields with query
  5. Follow proposal to placeinput fields into query statement

 

 

 

 

 

Detail view on AQL part:

Either manually type in the statement or click on the query. 

 

 

 

 

 

 

 

 

 

The shown AQL input support is from the construction same as the function "Query/reports" in the ADOxx-Modelling Toolkit.

In the next steps it is necessary to transform the query part:

  1. Contextmenu of the list entry "AQL part"
  2. Menu point "New"

 

 

 

 

Result Attributes

In the chapter "Result attribute" it is specified which objects and attributes should be displayed in the result representation.

  1. Switch to chapter "Result attributes"
  2. Choose Option "Attribute"
  3. Determine Position
  4. Confirm


   

 

 

New Menu Item

Besides the creation of queries, you can also create new menu items, for structuring the queries.

In the Query-choose window select a querygroup:

  1. Select option „Menu point"
  2. Select position
  3. Confirm
  4. Input title
  5. Choose modeltype
  6. Confirm

 

When creating new menu items note that:

  • every menu point is assigned to exactly one modeltype.
  • the menu items in the selection dialog correspond exactly to the ADOxx-based Toolkit.
  • after the creation of the menu item aquery must be added to it, because otherwise the menu item won‘t be saved.
  • Through input of tilde (~) in the menu name the following letter will be an accelerator (keyboard shortcut).

Downloads

Hands-On Slides