![]() |
|||||
|
|||||
Filter PaneThe Filter pane provides an interface to setup data filtering and runtime parameter entry. Filter Icon DefinitionsThe Filter Pane icons are described below:
Selecting Filter ColumnsClick the Select Filter Columns icon Place the cursor over the column icon to display a tool tip with the column type. To remove a filter column click the red Selecting Filter ParametersThe RBT Designer defaults logical operations to and. To change the operation, click the Logical Operator dropdown and select the desired operator. The parenthesis dropdowns allow the user to create parenthetical operations such as column1 = value1 and (column2 = value2 or column2 = value3). Click the Comparison Operator dropdown to select a standard SQL comparison.
Entering Comparison ValuesSimple comparisons can be entered in the Comparison Value field You can also enter more complex SQL comparisons If the Comparison Value type is a Date or a Timestamp the Date Select icon will display and the date/timestamp is be selected using the Select Date pane. Specifying a Custom Where ValueBy default, date, time, timestamp and numeric where value entries are controlled at the input field to ensure that the user enters a valid parameter. Dates,
Times and Timestamps must be selected with the Date Select pane and numeric entries will only accept numeric characters. A question mark is a valid entry as
described in the next section. At times this limitation is too restrictive. In RBT, the designer can create a custom where clause that accepts free form text. It should be noted
that there are no edit checks applied to the free form where clause entry - it will be submitted to the DBMS as entered. That said, if the designer is familiar with the DBMS-specific
SQL syntax, this functionality provides a flexible means of creating complex filter logic. To add a custom where clause click the Custom Where icon A custom where entry will display with a "[custom]" prefix in the filter pane Creating Runtime Parameter EntriesA designer can create filter comparisons that will prompt the user for input at document runtime. Runtime entries can be created in 2 ways. If a question mark (?) is entered in the Comparison Value field, a parameter entry window will display at document runtime to allow user entry. By default, when a runtime parameter entry field is created the column display name is displayed. To display a user-friendly input prompt, enter it in the User Prompt field
A user can also create runtime parameter input select lists. The first step in this process is to create a document to load the desired data from the database - See the Welcome Pane for information on creating a new document The first field must be a unique id field and the second is the display field. Now you can create a lookup parameter selection using the new document. Click the Lookup
icon A Comparison Value field with a lookup assigned will display as shown below. Now when the document runs a dropdown select will display for user input. You can create a multi-select runtime parameter input by checking the Allow Multi-Select checkbox.
Enter the desired number of display rows in the Rows input field. When the document is run a
multi-select input parameter list will be displayed. When a multi select lookup is chosen the Comparison
Operator will be set to in and will be read-only. To edit or remove a lookup just click on the Lookup icon Displaying Document SQL StatementTo see the SQL that the current design will generate, click the Show SQL Select
icon Edit Document SettingsClick the Edit Document Settings icon Running Current DocumentClick the Run icon Saving DocumentClick the Save Document icon |
|||||
|