Filter Methods

Character or String

• Equality Operator: Equal To
• Full Text Operators: At Least One of the Words, All of the Words, Without the Words, Proximity of the Words
• Like Operators: Like, Equal To, Not Equal To, Starting With, Containing, Not Starting With, Regular Expression
• Number and Text Operators: Equal To, Greater Than, Less Than, Greater Than or Equal To, Less Than or Equal To, Between

Full Text Operators enables users to issue full-text searches on data for the property. Full-text search allows fast and flexible indexing for keyword-based query of text data. Note that full-text search capabilities has to be enabled in your database. Please refer to your database vendor specifications on how to enable full-text search capabilities.

Date

• Date Operators. Equal To, Greater Than, Less Than, Greater Than or Equal To, Less Than or Equal To, Between
• Equality Operator: Equal To
• Relative Time Operators. Provides the user with the functionality to enter a search criterion expressing a date relative to the current date, for example, last week.

Date and Time

• Date Operators. Equal To, Greater Than, Less Than, Greater Than or Equal To, Less Than or Equal To, Between
• Date and Time Operators. Equal To, Greater Than, Less Than, Greater Than or Equal To, Less Than or Equal To, Between
• Equality Operator: Equal To
• Relative Time Operators

Float

• Equality Operator: Equal To
• Number and Text Operators: Equal To, Greater Than, Less Than, Greater Than or Equal To, Less Than or Equal To, Between

Integer

• Boolean Operator (data must be coded as 1 (Yes) and 0 (No): Yes, No
• Equality Operator: Equal To
• Number and Text Operators: Equal To, Greater Than, Less Than, Greater Than or Equal To, Less Than or Equal To, Between