Selecting Additional Fields

See Creating and Saving Queries to Search for Data.

In the Query Manager side panel, you can select a comparison type for each field or query-by-example (QBE) column and specify the comparison value for the query. To do this, click on the form fields or QBE columns you wish to use as search criteria. Only the form fields and QBE columns with a plus sign are available for selection. (Tools Release 9.2.9.3) The Column field is only applicable (visible) for the following operators across all four data types: =, !=, >, >=, <, <=. The data type mapped to the right operand must match the data type of the left operand. Additionally, for the Number data type, columns with a different display decimal are excluded.

Alternatively, you can use the Additional Fields Selection section to select the form fields or QBE columns. This section displays only the business view (BSVW) columns that are included on the form including the hidden columns. For example, if BSVW includes the columns A, B and C; A is displayed on the form, B is hidden and C is not included, then the Additional Fields Selection section displays A and B columns.