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 Analytics Center.
Comparison¶
- NameBlank
Label : =
Allow Parameters : FALSE
- NameNot Blank
Label : =
Allow Parameters : FALSE
- NameIs Less Than
Label : <
Allow Parameters : FALSE
- NameIs Greater Than
Label : >
Allow Parameters : FALSE
- NameBetween
Label : Between
Allow Parameters : FALSE
- NameNot Less Than
Label : >=
Allow Parameters : FALSE
- NameNot Greater Than
Label : <=
Allow Parameters : FALSE
- NameNot Between
Label : Not Between
Allow Parameters : FALSE
Boolean¶
- NameBlank
Label : =
Allow Parameters : FALSE
- NameNot Blank
Label : =
Allow Parameters : FALSE
- NameTRUE
Label : =
Allow Parameters : TRUE
- NameFALSE
Label : =
Allow Parameters : TRUE
Date & Time¶
- NameBlank
Label : =
Allow Parameters : FALSE
- NameNot Blank
Label : =
Allow Parameters : FALSE
- NameBetween (Date)
Label : Between (Date)
Allow Parameters : FALSE
- NameBetween (Date & Time)
Label : Between (Date & Time)
Allow Parameters : FALSE
- NameBetween (Time)
Label : Between (Time)
Allow Parameters : FALSE
- NameNot Between (Date)
Label : Not Between (Date)
Allow Parameters : FALSE
- NameNot Between (Date & Time)
Label : Not Between (Date & Time)
Allow Parameters : FALSE
- NameNot Between (Time)
Label : Not Between (Time)
Allow Parameters : FALSE
- NameEquals (Date)
Label : =
Allow Parameters : FALSE
- NameEquals (Date & Time)
Label : =
Allow Parameters : TRUE
- NameEquals (Time)
Label : =
Allow Parameters : FALSE
- NameNot Equal (Date)
Label : <>
Allow Parameters : FALSE
- NameNot Equal (Date & Time)
Label : <>
Allow Parameters : FALSE
- NameNot Equal (Time)
Label : <>
Allow Parameters : FALSE
- NameIn Time Period
Label : =
Allow Parameters : FALSE
- NameLess Than Days Old
Label : <
Allow Parameters : FALSE
- NameGreater Than Days Old
Label : >
Allow Parameters : FALSE
- NameEquals Days Old
Label : =
Allow Parameters : FALSE
Equivalence¶
- NameBlank
Label : =
Allow Parameters : FALSE
- NameNot Blank
Label : =
Allow Parameters : FALSE
- NameEquals (Manual Entry)
Label : =
Allow Parameters : TRUE
- NameEquals (Selection)
Label : =
Allow Parameters : TRUE
- NameEquals (Popup)
Label : =
Allow Parameters : FALSE
- NameEquals (Tree)
Label : =
Allow Parameters : FALSE
- NameEquals (Checkbox)
Label : =
Allow Parameters : FALSE
- NameNot Equal (Manual Entry)
Label : <>
Allow Parameters : FALSE
- NameNot Equal (Selection)
Label : <>
Allow Parameters : FALSE
- NameNot Equal (Popup)
Label : <>
Allow Parameters : FALSE
- NameNot Equal (Checkbox)
Label : <>
Allow Parameters : FALSE
- NameNot Equal (Tree)
Label : <>
Allow Parameters : FALSE
- NameEquals (Manual Entry No Auto-Complete)
Label : Equals (Manual Entry No Auto-Complete)
Allow Parameters : TRUE
- NameNull
Label : Null
Allow Parameters : FALSE
- NameNot Null
Label : Not Null
Allow Parameters : FALSE
Field Comparison¶
- NameBlank
Label : =
Allow Parameters : FALSE
- NameNot Blank
Label : =
Allow Parameters : FALSE
- NameIs Less Than (Field)
Label : <
Allow Parameters : FALSE
- NameIs Greater Than (Field)
Label : >
Allow Parameters : FALSE
- NameEquals (Field)
Label : =
Allow Parameters : FALSE
- NameNot Equal (Field)
Label : <>
Allow Parameters : FALSE
String¶
- NameBlank
Label : =
Allow Parameters : FALSE
- NameNot Blank
Label : =
Allow Parameters : FALSE
- NameLike
Label : Like
Allow Parameters : FALSE
- NameBegins With
Label : Begins With
Allow Parameters : FALSE
- NameEnds With
Label : Ends With
Allow Parameters : FALSE
- NameNot Like
Label : Not Like
Allow Parameters : FALSE