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.