Presto Analytics : RAQL Queries : Where Techniques
Where Techniques
Clause
Condition Expression
Example
where
simple-condition
For a simple filter condition, see Load Data with <directinvoke> and Filter Rows.
complex-condition
To use multiple conditions, arithmetic or logical operators, see Where Complex Conditions.
column-namelike text-pattern
To use text matching, see Where Text Like Patterns.
column-namein (value1, value2[,...])
To match to an enumerated set of values, see Where in Sets.
column-namebetween range-startand range-end
To match within a range of values.
dynamic condition
To provide dynamic values to filter conditions, see Parameters in Where Clauses.
function(column-name) in condition
To use functions on column values in filters, see Plain Functions in Where.
Copyright © 2006-2015 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback