Referencing a Column With Expression Filtering
You can filter out the records of a column based on a conditional expression. Use ''?” as the delimiter between the filtering expression and the column name.
Note: Although Expression Filtering can achieve the same result as Field Filtering, use Field Filtering wherever possible, since it is better optimized.
For example, consider the table described previously (Referencing a Query Column). To extract all the customers whose customerIDs are between 20 and 30, adapt the formula as follows:
q['company_name?customer_id > 20 && customer_id < 30'];
See Also
Referencing a Query Column With Field Filtering, for optimized filtering of the result set.
| << Referencing a Query Column With Field Filtering | © 1996-2013 InetSoft Technology Corporation (v11.4) | Referencing a Column with Positional (Index) Filtering >> |