Referencing a Query Column With Field Filtering

You can filter out records of a field (column) based on the values of other fields in the result set. To do this, use '@' as the delimiter between the column name and the filtering expression and ':' to introduce the values to filter.

For example, consider the formula table described previously (Referencing a Query Column). To extract all the companies within a certain state (NJ), you can adapt the formula as follows:

q['company_name@state:NJ'];

 

Note: To retrieve a sub-table rather than an array, add an initial asterisk: q['*@state:NJ'];

To filter based on multiple fields, use ';' as the delimiter between the filtering expressions. For example, to find all the companies within a certain city (New Brunswick) and state (NJ), adapt the formula as follows:

q['company_name@state:NJ;city:New Brunswick'];

If the filtering expression is based on a derived field, place '=' in front of the expression. For example, to find all the companies within a certain 'state, zip' pair (see Deriving a Result Set from Query Columns), adapt the formula as follows:

q['company_name@=state + ", " + zip:NJ, 08854'];

If the column name contains a space, use the rowValue operator:

q['company_name@=rowValue["US State"] + ", " + zip:NJ, 08854'];

<< Deriving a Result Set from Query Columns © 1996-2013 InetSoft Technology Corporation (v11.4) Referencing a Column With Expression Filtering >>