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