UAConnect: Query Manager Component Tabs

The pages in Query Manager enable you to tailor queries to retrieve data that is specific to your business needs.  This table lists the name and purpose of the Query Manager pages.

Page

Purpose

Required/Optional

Records

Select the records/tables to use in the query.

You must select at least one record before you can create and save a query.

Required

Query

Select the fields you need for the query.

You must select at least one record and field before you can create and save a query.

Required

Expressions

Creat formulas to use with the query.

Optional

Prompts

Create runtime prompts.

Optional

Fields

View, edit, sort and reorder fields that appear in the query. 

Optional

Criteria

Filter data to retrieve only those rows that you need to see. 

Optional

Having

Creat criteria for fields that use aggregate functions.

Optional

View SQL

View the SQL that is generated when the query is created. 

Optional

Run

View the results of the query. 

Optional

Updated 01/01/2016


Was this helpful?

Yes    No

IT Services