Siebel Search Administration Guide > Syntax for Filter Search Specifications > Filter Search Specification Syntax >

Filter Search Specification Syntax in Backus-Naur Format


Users can perform filter searching through the user interface controls (exposed through a special filter applet), or specified in the filter search Specification property of the Search Definition category. The syntax is slightly different when done through the user interface, but in all cases the syntax is simple BNF (Backus-Naur Format).

Examples

Search Statement

  • : condition
  • : expression

condition

  • : comparison
  • : condition [AND | OR] condition

comparison

  • : expression [= | < | > | <= | >= | [NOT] LIKE] expression

expression

  • : constant
  • : identifier
  • : function

constant

  • : string (double quoted)
  • : date (double quoted)"MM/DD/YY" (separator must be a forward slash/)

identifier

  • : [filter field name]

NOTE:  Searches on filter fields from the UI do not support the logical operators AND or OR.

Siebel Search Administration Guide Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices.