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 >>