Overview: Graphical Query Builder

i_warning_ex_yellow_sm.jpg

Using the Query Builder circumvents all form-level security and allows users to see all data in all tables in the Object List.

Objects

An Object is a set of data in the system, usually represented in a table, view or synonym to another object.  Available objects depend on the FAST application, the kind of access you have, and the data your institution uses. Objects can start with TBL for tables, VW for views, or SYN for synonyms.

The fields (or columns within the table) are listed when you open the object.  Click an object to open it and display the list of columns in the right hand display box. You can open more than one object, however, when you open more than one object in a query, they must be joined.

Object Alias and Name

When an object is opened, the letter in the upper left of the box is the object (or table) alias, the object name is inserted at the top.

Field/Column Name

In each open object, there is a listing of field (or column) names with check boxes for each field.

Selected columns from Objects

When columns (or fields) are selected and added to the query, they appear in the listing below the object listing. Column names are added and include the table name. In this section you can set a sort order, apply an alias to the column, and set criteria (where clause data).

Using Objects from External Schemas

The schema (application) that is displayed is the object owner.  It is possible to access external objects with the appropriate security grants in place to appear within a given application.  For example, if you are building a query in FASTFINANCE and require an object from FASTAR, it is possible to be granted access.  At this point, access to external objects is set up manually by Millennium staff, which means that if you need to query a table in the Accounts Receivable application from within the Finance Reporting application, submit a support ticket to Millennium and we will grant access for the FASTAR object to show up in FASTFINANCE.

SQL Code

SQL Code is added as you add columns to the query. You can also type code in this box.

Execute Query

When you click the Execute Query button, all columns you selected from the object and data are listed.

Refresh button

Click after you make any changes to the SQL code.

Related topics

 

 

footer_logo.gif