| Between |
● |
● |
|
Column row values between a minimum and maximum, inclusive. |
| Bottom |
● |
● |
|
A given number of smallest column row values. |
| Contains |
|
|
● |
Column rows that contain a value, as a substring. [Not Case Sensitive], [commas are valid search terms] |
| ContainsAll |
|
|
● |
Column rows that contain all of a list of values, as a substring. [Not Case Sensitive], [list is comma delimited and commas are NOT valid search terms] |
| ContainsAny |
|
|
● |
Column rows that contain any of a list of values, as a substring. [Not Case Sensitive], [list is comma delimited and commas are NOT valid search terms] |
| ContainsNot |
|
|
● |
Column rows that do not contain a single value as a sub string [Not Case Sensitive], [commas are valid search terms] |
| ContainsNone |
|
|
● |
Column rows that do not contain any of a list of values, as a substring. [Not Case Sensitive], [list is comma delimited and commas are NOT valid search terms] |
| ContainsOr |
|
|
● |
Column rows that contain any of a list of values, as a substring. Alias for “ContainsAny” [Not Case Sensitive], [list is comma delimited and commas are NOT valid search terms] |
| Equal |
● |
● |
● |
Column rows that equal exactly some value. [Case Sensitive] |
| EqualAny |
● |
● |
● |
Column rows that equal any of a list of values. [Case Sensitive] |
| EqualNone |
● |
● |
|
Column rows that do not equal any of a list of values. [Case Sensitive] |
| EqualNot |
● |
● |
● |
Column rows that do not equal a value exactly. [Case Sensitive] |
| Greater |
● |
● |
|
Column rows whose values are strictly greater than some value. |
| GreaterOR |
● |
● |
|
Column rows whose values are greater than or equal to some value. |
| Less |
● |
● |
|
Column rows whose values are strictly less than some value. |
| LessOR |
● |
● |
|
Column rows whose values are less than or equal to some value. |
| NotBetween |
● |
● |
|
Column row values not between a min and max, inclusive. |
| Top |
● |
● |
|
A given number of largest column row values. |
