Option
|
Description
|
||
---|---|---|---|
Select the table type
|
The table containing the data field by which to select records. You can select other tables only if they are related to the default table.
• When the Filter Wizard is started from the System file, the default table is the active table in the System file. For example, if the FRACAS Incidents table is selected when the Filter Wizard is started, FRACAS Incidents is the default table type. However, you can select Configurations (if enabled) Problems, or System Tree Items as the table type to select a field in any of these related tables. Only fields that are shown in the System file for the table are available for selection.
• When the Filter Wizard is started from a Filter file, the default table is the first table in alphabetic order for the module in use. If multiple modules are in use, after displaying the Specify Filter Features page, the Filter Wizard displays the Module Selection page so that you can select the module for which to create a filter. All fields that can be shown in the table are listed. Additional information about this procedure appears in Inserting a Filter in the Filter File.
|
||
[Field list]
|
The field by which to select records from all those for the table type. The subsequent steps assume that you select a field from this table. In this case, when you click Next, the Specify Condition page appears.
|
Option
|
Description
|
---|---|
Select whether you want to use a fixed value or a parameter here
|
Indicates whether the field value is a fixed value or a parameter supplied at the time the filter is applied. Choices are:
• Use a fixed value (specify the value below). When selected (default), the field value specified in the field below is used.
• Use a parameter (you will specify the value when the filter is applied). When selected, the field below becomes unavailable because a value is not specified until the filter is applied. Generating what is known as a parameterized query, this choice provides greater flexibility because you can change the criterion at run time. For more information, see Supplying Parameter Values at Run Time.
|
Specify the value for ‘X’ here
|
For a fixed value, the value by which to select records. The name of the selected field is shown for the ‘X’ variable. Depending on the field type, a selection control might be available. For example, if the field is a date, the calendar control is available. If the field is attached to a list, a browse button is available. Clicking it would open a window in which you select the list values to include in the filter criterion. For more information, see Selection Window for List Values.
|