...
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.
...