![]() |
|||
|
|||
Select PaneThe Select pane is show below. Select Icon DefinitionsThe Select pane icons and their functions are described below:
Selecting Document ColumnsTo add columns to the document click the Select Document Columns icon ![]() Place the cursor over the column icon to display a tool tip with the column type. By default, the RBT Designer will create SQL queries with inner joins. If you wish to create an outer join, click on the table icon to display the Select Join Type pane and select the desired join type. Editing Column Select ParametersOnce selected, columns will appear in the Select pane table and the column parameters can be edited. To remove a select column click the Formatting Numeric and Date ColumnsTo set the formatting on a number or date column click mask
icon Applying an Aggregate Function to ColumnThe Function dropdown displays standard SQL aggregate functions applicable to the current column type. For numeric types this includes count, avg, max, min, sum. For date types it includes count, max and min and for string types it includes count. If an aggregate function is selected the RBT Designer will generate SQL with appropriate group by syntax. ![]() Setting Column Sort PositionThe sort position of a column can be set by entering the desired position in the Sort Pos. column. Some care should be taken with this entry. There are no checks for duplicate entries or that the number entered is reasonable. By default the sort will be in ascending order, check the Sort Desc. check box to sort in descending order. Document SQL StatementClick the Show SQL Select icon Adding a Custom ColumnThe RBT Designer provides the capability to add free form custom columns to the
document query. Click the Add Custom Column icon The resulting output will be similar to the following. A custom column appears in the select design pane as shown below. Click the Custom Column Edit Document SettingsClick the Edit Document Settings icon Running Current DocumentClick the Run icon Saving DocumentClick the Save Document icon |
|||
|