The Query Designer screen is where you will define a query against your database. The screen consists of the following elements:
1 - Ribbon Bar
Functions to Save, Exit, Run, and Data Model Optimizations exist here.
Save - Save the Query.
Exit - Close the Query and return to the Main Menu.
Run Query - Executes the Query against the database and displays the results in the Query Grid.
Data Model Optimize - Filters out unused tables from the Query. Only used for very large Data Models.
Data Model Save - Saves the optimized Data Model to the database.
Data Model Restore - Reverts the Data Model to its original design.
2 - Entities
This section lists all of the different tables contained within your Data Model. This panel is used as a visual representation of all entities (tables) and their attributes (columns), which we can use to build queries. It can be used to add entity attributes to a Columns Panel (and they will be displayed in the result) or to a Conditions Panel (in order to actually set the query conditions).
A - Listing of Entities / Tables. Clicking the +/- signs will expand or collapse the table.
B - Listing of Attributes / Columns. Clicking the Checkbox will select the attribute for inclusion.
C - Select All
D - Deselect All
E - Add Checked / Selected Attributes to the Columns listing.
F - Add Checked / Selected Attributes to the Conditions listing.
3 - Columns
The section lists all of the different columns you have selected to be displayed in your query results. You have a list of lines, each of them represents a column in the query results (in the Results Panel). Every line consists of Expression, which is an attribute, a Title, which serves as a column title in the Results Panel, and buttons – for sorting (on the left), aggregating and deleting (on the right).
A - Command Button - Clicking this displays options specific to the selected column.
B - Table & Column Name - The orignal table and name of the column selected from the Entities panel.
C - Display Name - The name you wish to have the column appear within the results grid. Clicking on this text will allow you to change the title.
D - Sort Order - Ascending or Descending options. Note: This can be overridden within the Query Grid display.
4 - Conditions
This sections lists all of the filtering conditions for data selection. The result of your query will include only the data that satisfy those conditions. Every line in the Conditions Panel corresponds to a single query condition. Every condition consists of 3 elements – an expression (some entity attribute), an operator, and value(s) (one or more).
A - Condition Connectors - Options for All or Or
B - Enable / Disable Checkbox - Check or Uncheck to include this condition when running the query.
C - Command Button - Clicking this displays options for the Condition.
D - Attribute - The selected column the condition applies to.
E - Operator - Type of filter against the Attribute.
F - Value - Value to check against.
We have mentioned attributes above (e.g., ‘Invoice Balance Amount' and 'Customer #’). Together with values, operators set certain limitations regarding data which is stored under a given attribute. For example, “(Invoice Balance Amount) is not equal to $0,” “(Customer) is either 10200, 10300, or 41500.”
5 - SQL
This area displays the SQL code used to run against the database. This is display for debugging purposes only and will most likely not be used except by Administrators and Aeros Customer Care.
6 - Properties
This sections lists different configuration options specific to the Query.
7 - Results
This section displays the results of the query in an Excel-like type grid format. For further documentation and usage of the grid, please view the Query Grid page.