Appearance

Standardised Queries on Attribute Profiles ​

To carry out standardised queries, select a standardised query from the list "Query". An appropriate text with gaps appears in the input field of the selected query. Enter the required information (e.g. select name of the attribute profile/attribute) or select any value from the class/attribute/comparison operators lists.

Standardized queries are explained below:

  • Find all attributes of the class [Selection]. This query displays all attribute profiles of the selected class.

  • Find all attributes of the class [Selection] withattribute [Selection][comparison operator][entry]. This query displays all attribute profiles of the selected class with a specific attribute value.

Note: First select the class, then the attribute of the class and the comparison operator and enter the comparison value of the attribute.

  • Find all attributes of the class [Selection] withrecord attribute [Selection][comparison operator][Number]. This query displays all attribute profiles of the selected class, which contain in their given record attribute the number of entries (rows) you have defined.

Note: These standardised queries will only be displayed if record attributes are defined in your application library.

  • Find all attributes of the class [Selection] with record attribute [Selection] and withcolumn [Selection][comparison operator][entry]. This query displays all attribute profiles of the selected class, which contain in the given table and column a specific attribute value.

Note: These standardised queries will only be displayed if record attributes are defined in your application library.

You can carry out the completed standardised queries by clicking on the "Evaluate" button. The query results will be displayed in the ADOxx browser .

If you click on the "Add" button , the standardised query will be transformed into an AQL expression and shown in the "User defined query" field . From this query you can create a complex user-defined query by entering further AQL expression and by adding further standardised queries.

By clicking on the "Attribute" button you will define the attributes, which should be added to the name of the attribute profile found. If you select no attribute, the query results will be displayed without attribute.

Hint

Standardised queries will be saved after the completion of the query. When recalling the menu item "Queries" the standardised query will be shown as a user-defined query using AQL expression. This query remains saved until another standardised or user-defined query is entered or you close ADOxx.

Hint

If an AQL expression is registered in the "User defined query" field, you will carry out this user-defined query by clicking on the OK button, otherwise the current selected standardised query will be carried out.