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