Bookshelf Home | Contents | Index | PDF     

Siebel Search Administration Guide > Filter Search Specifications Syntax for Oracle Secure Enterprise Search > Filter Search Specification Syntax >

Comparison Operators

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

Table 16. 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 © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.