CONNX Data Integration Suite 14.8.0 | InfoNaut - The Query Tool | Query Builder | Selecting Output Fields
 
Selecting Output Fields
There are several ways to add a field to the query output field list:
*Select the field name in the Query Building Area. To include all the fields of the object, select the list item with an asterisk in the field name area.
*Select a field name from the Expression column drop-down list in the Columns Pane.
*Enter a valid expression in the Expression column in the Columns Pane.
There are two ways to remove a field from the list of query output fields:
*Clear the checkbox at the left of the field name in the Query Building Area.
*Clear the Output column checkbox.
Using the drop-down menu, you can remove lines from the Columns Pane or re-order output by right clicking on the leftmost gray column.
Define any output field aliases in the Alias column of the Columns Pane.The Columns pane contains information about which queries will be output, expressions and aliases. You can edit aliases in this window.