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
- Name :Blank
- Label : =
- Allow Parameters : FALSE
- Name :Not Blank
- Label : =
- Allow Parameters : FALSE
- Name :Is Less Than
- Label : <
- Allow Parameters : FALSE
- Name :Is Greater Than
- Label : >
- Allow Parameters : FALSE
- Name :Between
- Label : Between
- Allow Parameters : FALSE
- Name :Not Less Than
- Label : >=
- Allow Parameters : FALSE
- Name :Not Greater Than
- Label : <=
- Allow Parameters : FALSE
- Name :Not Between
- Label : Not Between
- Allow Parameters : FALSE
Boolean
- Name :Blank
- Label : =
- Allow Parameters : FALSE
- Name :Not Blank
- Label : =
- Allow Parameters : FALSE
- Name :TRUE
- Label : =
- Allow Parameters : TRUE
- Name :FALSE
- Label : =
- Allow Parameters : TRUE
Date & Time
- 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
Equivalence
- 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
Field Comparison
- Name :Blank
- Label : =
- Allow Parameters : FALSE
- Name :Not Blank
- Label : =
- Allow Parameters : FALSE
- Name :Is Less Than (Field)
- Label : <
- Allow Parameters : FALSE
- Name :Is Greater Than (Field)
- Label : >
- Allow Parameters : FALSE
- Name :Equals (Field)
- Label : =
- Allow Parameters : FALSE
- Name :Not Equal (Field)
- Label : <>
- Allow Parameters : FALSE
String
- Name :Blank
- Label : =
- Allow Parameters : FALSE
- Name :Not Blank
- Label : =
- Allow Parameters : FALSE
- Name :Like
- Label : Like
- Allow Parameters : FALSE
- Name :Begins With
- Label : Begins With
- Allow Parameters : FALSE
- Name :Ends With
- Label : Ends With
- Allow Parameters : FALSE
- Name :Not Like
- Label : Not Like
- Allow Parameters : FALSE