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.5) | Referencing a Column With Expression Filtering >> |