Adding or modifying SpeedSearch Database Index conditions

Use the Add/Edit Index Condition window to add or modify a new index condition. Conditions are used to limit the data included in the index.

Note: The system administrator and users with the appropriate role can access these features. See What are Roles and Secured Actions?

To add or modify a condition:

Select Administration > SpeedSearch Managerin the navigation bar. The SpeedSearch Manager list view is displayed.
Click the Database Indexes tab and select a database index in the list.

Note: The Detail pane displays at the bottom of the list view with tabs containing detail information about the selected record. If the Detail pane is not displayed, click Detail.
Click the Conditions tab in the Detail pane.
Click the Add icon to add a condition. The Add/Edit Index Condition window is displayed.

Note: Select the required condition and click the Edit option to modify the condition.
Specify this information:

Field Name

The name of the field. Click the Find option and use the Select Index Field window to select a field. See Selecting a SpeedSearch Database Index Field
Note: This value cannot be modified after the condition is created and saved.

Operator

Click the drop down and select a condition operator from the list. See Query Builder statement operators
Note: The available operators are based on the field type of the selected field.

Value

The value of the condition.

Case sensitive compare

Select this check box if you require the capitalization of the value used as part of the condition.

Use value as literal

Select this check box if you have selected a date/time field, string, or integer field type and require using a customer parameter.
Note: This places text in the query as it displays in the Value Is field. In most cases, you must not select this option. However, in some instances, advanced users are required to specify text that must be specified directly to the SQL statement.
Use these options if there are multiple conditions to be grouped:
- Add NOT before condition: Select this check box to add NOT before the condition. If NOT is added before a group of conditional statements, the condition applies to all conditional statements in that group.
- Add Left parentheses before condition by any of these methods:
  - Click the Add icon for the first condition of the group.
    Note: There must be equal number of left and right parentheses.
  - To add nested parentheses, click the Add icon until all left parentheses are added.
  - Click the Remove icon to remove a left parenthesis.
- Add Right parentheses after condition by any of these methods:
  - Click the Add icon for the last condition of the group.
    Note: There must be equal number of left and right parentheses.
  - To add nested parentheses, click the Add icon until all right parentheses are added.
  - Click the Remove icon to remove a right parenthesis.
- AND/OR Click the dropdown and select one of these connector options:
  - AND: Select this option if you have more than one conditional statement and you require to select the record only if it meets the conditions in both statements.
  - OR: Select this option if you have more than one statement and you require to select the record if it meets any condition in any statement.
Click OK.