Changing the default search filter operator for Alpha fields

For Alpha fields the current default search filter operator is "contains." A "contains" search has the potential advantage of retrieving more records but this can negatively affect performance if it is a list in a large business class that is being searched. For this reason, an administrator can change the default search filter operator to a different value, such as "starts with" or "equals." Users can still opt to use "contains" when specifying the filter on a list if necessary.

The default search filter operator can be set at the product line and the list level. A list setting takes precedence over the product line setting. Setting the default search filter operator on specific lists can provide the most appropriate operator for those specific cases. For example, searching on Vendor Name would be appropriate for a "contains" search, but for the Invoice Number an “equals” operator is more appropriate.

  1. In the Configuration Console Web UI, select Configuration > Create.
  2. Depending on the type of component you plan to change the default search filter operator for, select List or Configure Product Line.
  3. For a list, select the specific list and then click Edit. For a product line, click Edit. You can only edit the product line you are currently logged into.
  4. Add the following line to set the default search filter operator, where valid values for lists for searchOperator are contains, starts with, and equals, and for product lines are contains and starts with. 
    default Alpha filter operator is searchOperator
  5. When finished editing a component, click Submit