Available Filter Operators

Filter operators are used to designate a subset of data for analysis and modeling.

The following is a list of available filter operators for reference. Additional operators may be added in future versions of Izenda.

Comparison

Allow Parameters : FALSE

Name :Blank
- Label : =
- Allow Parameters : FALSE
Name :Not Blank
- Label : =
- Allow Parameters : FALSE
Name :Between (Date)
- Label : Between (Date)
- Allow Parameters : FALSE
Name :Between (Date & Time)
- Label : Between (Date & Time)
- Allow Parameters : FALSE
Name :Between (Time)
- Label : Between (Time)
- Allow Parameters : FALSE
Name :Not Between (Date)
- Label : Not Between (Date)
- Allow Parameters : FALSE
Name :Not Between (Date & Time)
- Label : Not Between (Date & Time)
- Allow Parameters : FALSE
Name :Not Between (Time)
- Label : Not Between (Time)
- Allow Parameters : FALSE
Name :Equals (Date)
- Label : =
- Allow Parameters : FALSE
Name :Equals (Date & Time)
- Label : =
- Allow Parameters : TRUE
Name :Equals (Time)
- Label : =
- Allow Parameters : FALSE
Name :Not Equal (Date)
- Label : <>
- Allow Parameters : FALSE
Name :Not Equal (Date & Time)
- Label : <>
- Allow Parameters : FALSE
Name :Not Equal (Time)
- Label : <>
- Allow Parameters : FALSE
Name :In Time Period
- Label : =
- Allow Parameters : FALSE
Name :Less Than Days Old
- Label : <
- Allow Parameters : FALSE
Name :Greater Than Days Old
- Label : >
- Allow Parameters : FALSE
Name :Equals Days Old
- Label : =
- Allow Parameters : FALSE

Name :Blank
- Label : =
- Allow Parameters : FALSE
Name :Not Blank
- Label : =
- Allow Parameters : FALSE
Name :Equals (Manual Entry)
- Label : =
- Allow Parameters : TRUE
Name :Equals (Selection)
- Label : =
- Allow Parameters : TRUE
Name :Equals (Popup)
- Label : =
- Allow Parameters : FALSE
Name :Equals (Tree)
- Label : =
- Allow Parameters : FALSE
Name :Equals (Checkbox)
- Label : =
- Allow Parameters : FALSE
Name :Not Equal (Manual Entry)
- Label : <>
- Allow Parameters : FALSE
Name :Not Equal (Selection)
- Label : <>
- Allow Parameters : FALSE
Name :Not Equal (Popup)
- Label : <>
- Allow Parameters : FALSE
Name :Not Equal (Checkbox)
- Label : <>
- Allow Parameters : FALSE
Name :Not Equal (Tree)
- Label : <>
- Allow Parameters : FALSE
Name :Equals (Manual Entry No Auto-Complete)
- Label : Equals (Manual Entry No Auto-Complete)
- Allow Parameters : TRUE
Name :Null
- Label : Null
- Allow Parameters : FALSE
Name :Not Null
- Label : Not Null
- Allow Parameters : FALSE