Add search fields to auto-complete validations
Auto-completes can be configured to display additional filter fields in the Select window. These fields can be used to search other properties than the primary values in the list. Users can provide values in the filter fields, and then click Find to display only the values that match the search criteria.
Note: Filter fields offer a powerful way to efficiently locate specific values. As you add filter fields to an auto-complete validation, consider the following:
Ensure that the filter fields are functionally related to the listed values. For example, a validation that provides a list of request types can include a filter field for a specific Department associated with the request types.
Consider reusing (copying) an auto-complete validation and modifying the filter fields to display a subset of the list. Use the Displayed, Display Only, and Default fields in the Filter Field window, to configure the auto-complete values to automatically limit the results.
Performance can degrade if you join tables over database links.
Use this functionality only for complex fields.
To add a filter field to the auto-complete validation:
Click the Filter Fields tab.
The Field: New window opens.
Provide the required and any optional information for the following:
Name displayed for the field in the auto-complete Select window.
PPM product that uses the field.
Validation for the filter field. You can select any type of validation, except for auto-complete type validations.
Valid values are appended to the WHERE clause in the SQL query that determines the ultimate auto-complete display.
Opens the Validation window, where you can construct a new validation for the filter field. Note that you cannot use an auto-complete type validation for the filter field.
Opens the Validation window and displays the definition of the validation specified in the Validation field.
Token for the field value. The token value is appended to the WHERE clause in the SQL query that determines the ultimate auto-complete display.
Filter field description.
Component type for the filter field, determined by its validation.
Default value for the filter field, determined by its validation.
Determines whether the filter field is enabled.
Determines whether the filter field is visible to the user in the auto-complete's Select window.
Determines whether the filter field is updatable. When Display Only is set to Yes, the field can not be updated.
When the auto-complete user chooses a value for this field, append to WHERE clause:
AND clause appended to the portlet's WHERE clause if the user specifies a value in this filter field. The value in this field must start with 'AND'.
Each filter field appends its term to the portlet query if the user specifies a value in the Select window.
For example, if the filter field uses the CRT-Priority-Enabled validation and a filter field token of
P_PRIORITY, type the following:
AND R.PRIORITY_CODE = '[P.P_PRIORITY]'
View Full Query
Opens a window that displays the full query.
You are returned to the Validation window.
Continue adding filter fields.
When you are done, click Save.
Optionally continue with Configure the Filter Field Layout.