Skip to main content

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:

    3. 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 (see Create a Totals Query for more information).

    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 (see Smart Parms in Query Designer for more information).

    Duplicate Field

    Duplicates the selected field, and assigns a unique alias name.

    Set as Summary Field (GEXQ)

    Creates summary SQL code for the field (see Create the GEXQ Field for more information).

    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.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk