In this topic you will learn how to create a new query.

In this example the query will display the employee's name, emplid, department, original hire date, and highest education level.

Adding Records:

The Records page is the first page that you will see when you click the Create New Query link on the Search page.

You will select the information for your query on the Records page.

The Records page displays the records (tables) available to query in alphabetical order.  The list of records available to the end-user is determined by his/her security rights (Operator ID).

The end-user may view existing records by selecting one of the following methods:

1. Click the Search button to view a list of records; or

2. Enter the appropriate search criteria (record name) into the

    Search by field. The end-user may enter the full record name or

    partial information in CAPS or lower case. Use the % (percent

    sign)  to act as a wildcard when searching.

In this example you will use fields from one record -- the EMPLOYEES record.

In order to find the record enter "employees" into the begins with field.

The EMPLOYEES record displays in the Search Results.

Click the Add Record link to select the record and view the fields in that record on the Query page.

If the record is effective dated, a message will appear stating the effective date criteria is automatically added.

Click the OK button if this message displays.

Selecting Fields:

The record and the fields in the record appear on the Query page. It is here that you will select fields to build the query by clicking the checkbox in front of the field.

Note: You may click the checkbox to deselect a field or click the Uncheck All Fields button to deselect all fields that are checked.

The Key symbol in front of the field indicates Key fields.

The Add Criteria symbol (funnel with a plus sign) allows you to add criteria from the record itself. Adding criteria will be covered in the Working with Criteria and Prompts section.

Note: The fields default in hierarchical order (i.e. the Key fields in the record appear at the top of the list).

Click the Sort fields alphabetically button to sort fields in alphabetical order.

You may return the fields to the hierarchical order by clicking the Sort fields alphabetically button again.

Click the EMPLID checkbox.

Click the NAME checkbox.

Click the HIGH_EDUC_LVL checkbox.

Click the ORIG_HIRE_DT checkbox.

Click the DEPTID checkbox.

The Fields page displays the fields used in the query. You may format your query layout on this page. This will be covered in Format a Query section.

On the fields page verify all the records needed for your results are listed.

If not, return to the query tab add select/deselect the appropriate fields.

The Run tab allows you to see the query results before saving your query.

Enter the *Query Name.

Note: The Query Name may be entered in CAPS or lowercase (once you click OK it will be converted to CAPS). The Query Name is limited to 30 characters. Spaces or special characters are not allowed. The end-user may opt to use the underscore (_) to separate the words

 Enter "EMPLIST".

Enter the Description. 

Note: The Description is limited to 30 characters and it may contain spaces or special characters. The Description may be entered in CAPS, lowercase or mixed case, but will appear the way it has been entered.

Enter "employee list".

Enter the Query Definition. 

Enter "list of employee and their highest education level".

This completes Create a New Query.

Adding Records:

The Records page is the first page that you will see when you click the Create New Query link on the Search page.

You will select the information for your query on the Records page.

In this example you will use fields from one record -- the EMPLOYEES record.

In order to find the record enter into the begins with fielda valid value e.g. "employees".

Enter the *Query Name.

Note: The Query Name may be entered in CAPS or lowercase (once you click OK it will be converted to CAPS). The Query Name is limited to 30 characters. Spaces or special characters are not allowed. The end-user may opt to use the underscore (_) to separate the words

 Enter a valid value e.g. "EMPLIST".

Enter the Description. 

Note: The Description is limited to 30 characters and it may contain spaces or special characters. The Description may be entered in CAPS, lowercase or mixed case, but will appear the way it has been entered.

Enter a valid value e.g. "employee list".

Enter the Query Definition. 

Enter a valid value e.g. "list of employee and their highest education level".