Field List Menu

The Field List menu is accessed from the Field List panel, and allows users to access and process various functions associated with the selected query field.

1. In the Field List panel, right-click the left-most cell of the selected row. The Field List menu appears.



2. Use the following table to enter data in the Field List menu.

Menu Item	Description
Add Calculated Field	Opens Expression Builder, allowing the user to the query source tables and parameters, and provides tools to aid in creating a calculated field.
Toggle Alias	Allows the user to manually assign an alias name to the selected field.
Unique Records	If enabled, changes the query to SELECT DISTINCT, removing duplicate rows from the result set, causing each row to be unique.
Toggle Totals	Toggles to display or hide the Totals column, used for totaling and grouping.
Add Field Descriptions as Alias	Creates aliases for each field in the query, using the field descriptions from the table schema.
Add Smart Parameter	Creates a smart parameter, and assigns it to the selected field.
Duplicate Field	Duplicates the selected field, and assigns a unique alias name.
Set as Summary Field (GEXQ)	Creates summary SQL code for the field.
Preview Field Data	Opens Result Viewer, displaying data for the selected field(s).
Move First/Up/Down/Last	Moves the selected field up or down one line, or to the first or last position. Alternatively, click and drag the selected field to the desired location.
Delete Fields	Deletes the selected field(s) from the query.