Configuring the Advanced Search Filter Criteria

You can configure filter criteria for all the searchable attributes in your case class. This allows you to filter the list of case data in your search to display specific case data.

1. From the Case Class Information box, select the case data model whose case classes you want to define search criteria for. The case classes that are available for the case model display.
   Advanced searches can only specify one case class at a time. In other words, you cannot add more than one case class to a search condition. If you want to search another case class, you can add a new advanced search or change to another case class. If you change to another case class, a warning displays indicating that the currently selected conditions will be cleared if you do this.
2. Select the case class.
   The searchable attributes defined for the case class display.
3. Select the searchable attribute.
   If the searchable attribute is an array, you can also specify filter criteria for the array. See Filtering Array Attributes in Searches.
4. Double-click the attribute to add the condition.
5. Specify a logical operator for the condition. Depending on the data type of the attribute you selected, you can select one of the following:

   Option	Description
   EQ	Equal to value. If value contains any unescaped wildcard symbols ('_' or '?' for single character, '%' or '*' for anything - any of which can be escaped by prefixing with '\'), this will result in a 'like' comparison. For example: apple = "apple" banana% = "banana%" cherry% = like cherry% damson\*? = like damson\*?
   NEQ	Not equal to the value.
   GT	Greater than value.
   GTE	Greater than or equal to value.
   LT	Lower than value.
   LTE	Lower than or equal to value.
   IN	Equal to one of the values in an array. For example, IN('abc', 'bcd', 'def').
   NOT_IN	Not equal to any of the values.
   BETWEEN	Between value#1 and value#2 (inclusive).
   NOT_BETWEEN	Not between value#1 and value#2 (inclusive).
   NULL	Object reference is null.
   NOT_NULL	Object reference is not null.
   TYPE_OF	Object referenced is of a particular type (where value is fully qualified class name) or a sub-type of that type.

6. Specify a value for the attribute. The value must be the same data type as the data type of the attribute. See "BOM Native Types" in the Business Data Services Guide for more information.
7. You can select another attribute to create more complex expressions. When adding additional attributes, you are essentially combining logical ANDs and ORs in a single expression. An attribute that is added underneath another attribute is effectively enclosed in parentheses. This means that the second attribute is evaluated separately, and then its result is used to evaluate the parent attribute. You can add as many attributes as you want. To select another attribute, double-click the attribute.
8. Depending on your requirements, click the arrow icon ( ) next to the condition if you want it to be included into a single expression.
9. Select one of the following:

   Option	Description
   AND	Select AND if you want the search critieria to match more than one attribute.
   OR	Select OR if you want the search criteria to search against more than one attribute.

   Follow Step 5 - Step 6 to complete the search condition. The Description displays your completed condition.
10. You can remove a condition at any time by clicking the Remove icon ()