Selecting output fields

There are several ways to add a field to the query output field list:

  • In the Query Building Area select the field name. To include all the fields of the object, select the list item with an asterisk in the field name area.

  • In the Columns Pane, select a field name from the  Expression column drop-down list.

  • in the Columns Pane, enter a valid expression in the Expression column .

 

There are two way to remove a field from the list of query output fields:

  • In the Query Building Area, clear the checkbox at the left of the field name  

  • 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 left most gray column.

 

image28.jpg

  

Define any output field aliases in the Alias column of the Columns Pane.

 

image34.gif