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

Comparison Operators


Table 17 describes the purpose of each comparison operator, and gives an example of how it is used.

Table 17. Comparison Operators
Operator
Purpose
Example

=

Equality Text

[Publish External] = "Y"

<>

Inequality text

[Role] <> LookupValue ("ROLE_TYPE", "Manager")

>

Greater than

[Start Date] > Today()

<

Less than

[End Date] < Today() + 4

>=

Greater than or equal to

[Start Date] >= Today()

<=

Less than or equal to

[End Date] <= Today() - 4

NOTE:  The last four operators are used only for Date fields.

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