Valid Conditions for Each Field Type

Windchill Risk and Reliability Desktop Help > Overview > Features > Filters > Filter File Panes > Valid Conditions for Each Field Type

The conditions that are valid depend on the type of field for which you are specifying criterion. The following table shows the valid conditions for each field type. For more information, see Data Field Types. If you are using an Oracle database, see ‘Contains’ Condition in Unicode-Enabled Oracle Databases.

Condition	Text	Memo	Text or Memo with List Attached	Date	Numeric	Currency	Yes/No
is equal to	X	X	X	X	X	X	X
is greater than			X	X	X	X
is less than			X	X	X	X
is greater than or equal to			X	X	X	X
is less than or equal to			X	X	X
is not equal to	X	X	X	X	X	X	X
starts with	X	X
contains	X	X
ends with	X	X
does not start with	X	X
does not contain	X	X
does not end with	X	X
is empty	X	X	X	X	X	X
is not empty	X	X	X	X	X	X
is in the last 2 hours				X
is in the last 7 days				X
is in the last 30 days				X
is in the last 120 days				X
is in the next 7 days				X
is in the next 30 days				X
is in the current week				X
is in the current month				X
is in the last X days				X
is in the next X days*				X