Folder search operators by field type

The following table lists the search operators available for each type of field supported by Content Manager OnDemand.

Field Type	Operators Available
String	Equal, Not Equal, Less Than, Less Than or Equal, Greater Than, Greater Than or Equal, In, Not In, Between, Not Between, Like, Not Like
Decimal, Integer, Small Int, Big Int	Equal, Not Equal, Less Than, Less Than or Equal, Greater Than, Greater Than or Equal, In, Not In, Between, Not Between
Date, Date/Time, Date/Time(TZ) Date (old style), Date/Time (old style), Date/Time (TZ) (old style)	When the database field is not a segment field: Equal, Not Equal, Less Than, Less Than or Equal, Greater Than, Greater Than or Equal, Between, Not Between When the database field is a segment field: Equal, Between
Time (old style)	Equal, Not Equal, Less Than, Less Than or Equal, Greater Than, Greater Than or Equal, Between, Not Between
Application Group, Segment, Text Search, Annotation Text Search, Annotation Color Search	Equal

Important: For any folder field that is mapped to an application group field whose display values are mapped to database values, specify only the Equal operator. The Content Manager OnDemand client ignores all other operators.