Begin by navigating to the Records page.
Click the Reporting Tools link.Step 1
Click the Query Manager link.Step 2
Click the Create New Query link.Step 3
Use the Records page to select the records upon which to base the new query. Select the criteria to use when searching for records. You can search for existing records by entering appropriate keywords.Step 4
In this example, you want to create a query by using the ACAD_DEGR record.
Enter the desired information into the begins with field. Enter
Click the Search button.Step 6
Next, add the record and select the fields from the record that you want to add to the query.
Click an entry in the Add Record column.Step 7
The Query page appears, displaying several fields. Use this page to add fields to a query.Step 8
Click the EMPLID - EmplID option.Step 9
Click the vertical scrollbar.Step 10
The query name appears as New Unsaved Query until you save the query.
Click the Save button.Step 11
Use the Enter a name to save this query: page to specify a name and description for the new query you created.Step 12
Enter the desired information into the Query field. Enter
Click in the Description field.Step 14
Enter the desired information into the Description field. Enter
Use the Query Type field to specify the type of query as User, Process, or Role. Standard queries are defined as User types, and queries that use workflow are defined as Process or Role types. For this example, retain the default query type.Step 16
You can specify the query as either Private or Public by selecting an entry in the Owner field. A Private query can be accessed and modified by only the user who created the query. However, any user who has access to the query records can run, modify, or delete a Public query. For this example, retain the default value.Step 17
Click the OK button.Step 18
Next, view the query results.
Click the vertical scrollbar.Step 19
Click the Run tab.Step 20
Use the Run page to preview the query you have just created.Step 21
Notice that there are 45 rows in the query result, and some IDs are appearing multiple times.Step 22
Click the Fields tab.Step 23
Use the Fields page to view field properties, or to use field as criteria in query statement.Step 24
Navigate to the Query Properties page to change the query properties to make it distinct.
Click the Properties link.Step 25
Use the Query Properties page to enter query details such as query description, type, and owner.Step 26
Click the Distinct option.Step 27
Click the OK button.Step 28
Click the Save button.Step 29
Now, preview the query results.
Click the Run tab.Step 30
Notice that the page now has only 39 rows. The IDs that were appearing more than once have disappeared from the query results.Step 31
You successfully made a query distinct.
Table of Contents Start Topic