Adding Selection Criteria

The next step is to enter the attribute names and values to be used in the SQL query. These can be added using the 'Add Criteria' link on the second page of the wizard.

For dynamic selection queries the values will only be used for validation purposes. Validation of a selection query will be discussed in the next section. For fixed selection queries the values entered will be the actual values used when executing the query as the audit coordinator will not have the option to enter their own values. 'Name' should contain the attribute as it appears in the WHERE clause of the SQL statement. The 'Display Name' and 'Display Value' should be acceptable representations of 'Name' and 'Value' that can be displayed to an audit coordinator.