Specifying Sort Criteria in the Filter Wizard

Windchill Risk and Reliability Desktop Help > Overview > Features > Filters > Filter How-Tos > Specifying Sort Criteria in the Filter Wizard

When a filter is to sort records, you must specify sort order criteria. In the Filter Wizard, this process begins with selecting a table type and data field on the Specify Sort Field page.

1. Complete the Specify Sort Field page, referring to the following table for option descriptions.

Option	Description
Select the table type	The table containing the data field by which to sort 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 active when the Filter Wizard is started, FRACAS Incidents is the default table. However, you can select System Tree Items, Problems, and possibly Configurations as the table type to select a field in any of these related tables. Only fields that appear in the System file for the chosen table are available for the sort criterion. • 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 choose the module for which to create a filter. All fields that can appear in the chosen table are listed Additional information about this procedure appears in Inserting a Filter in the Filter File.
[Field list]	The field by which to sort records from all those for the chosen table type.

Option

Description

Select the table type

The table containing the data field by which to sort 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 active when the Filter Wizard is started, FRACAS Incidents is the default table. However, you can select System Tree Items, Problems, and possibly Configurations as the table type to select a field in any of these related tables. Only fields that appear in the System file for the chosen table are available for the sort criterion.

• 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 choose the module for which to create a filter. All fields that can appear in the chosen table are listed Additional information about this procedure appears in Inserting a Filter in the Filter File.

[Field list]

The field by which to sort records from all those for the chosen table type.

2. Click Next. The Specify Sort Order page appears.

3. For Select the sort order here, select Ascending (default) or Descending; then, click Next. The Review Filter page appears. If the filter is to both select and sort records, the selection criteria also appear for your review.

4. Review the filter. To insert additional sorting criteria, select I want to add more conditions to the filter.

5. Click Next. One of three possible pages appears: Specify Sort Field, Save Filter, or Filter Name.

◦ The Specify Field page appears when the checkbox for adding more conditions is selected in the Review Filter page. Repeat all of the previous steps in this procedure for each sort criterion to add.

◦ The Save Filter page appears when the Filter Wizard is started from the System file. For more information, see Saving and/or Applying a Filter from the Filter Wizard.

◦ The Filter Name page appears when the Filter Wizard is started from the Filter file. For more information, see Inserting a Filter in the Filter File.