Making a Query Distinct


Concept


Steps:

  1. Begin by navigating to the Records page.

     

    Click the Reporting Tools link.

    Step 1
  2. Click the Query Manager link.

    Step 2
  3. Click the Create New Query link.

    Step 3
  4. 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
  5. 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

     a valid value
     e.g.
     "ACAD"
    .

    Step 5
  6. Click the Search button.

    Step 6
  7. 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
  8. The Query page appears, displaying several fields. Use this page to add fields to a query.

    Step 8
  9. Click the EMPLID - EmplID option.

    Step 9
  10. Click the vertical scrollbar.

    Step 10
  11. The query name appears as New Unsaved Query until you save the query.

     

    Click the Save button.

    Step 11
  12. Use the Enter a name to save this query: page to specify a name and description for the new query you created.

    Step 12
  13. Enter the desired information into the Query field. Enter

     a valid value
     e.g.
     "Student_Distinct"
    .

    Step 13
  14. Click in the Description field.

    Step 14
  15. Enter the desired information into the Description field. Enter

     a valid value
     e.g.
     "List of student IDs"
    .

    Step 15
  16. 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
  17. 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
  18. Click the OK button.

    Step 18
  19. Next, view the query results.

     

    Click the vertical scrollbar.

    Step 19
  20. Click the Run tab.

    Step 20
  21. Use the Run page to preview the query you have just created.

    Step 21
  22. Notice that there are 45 rows in the query result, and some IDs are appearing multiple times.

    Step 22
  23. Click the Fields tab.

    Step 23
  24. Use the Fields page to view field properties, or to use field as criteria in query statement.

    Step 24
  25. Navigate to the Query Properties page to change the query properties to make it distinct.

     

    Click the Properties link.

    Step 25
  26. Use the Query Properties page to enter query details such as query description, type, and owner.

    Step 26
  27. Click the Distinct option.

    Step 27
  28. Click the OK button.

    Step 28
  29. Click the Save button.

    Step 29
  30. Now, preview the query results.

     

    Click the Run tab.

    Step 30
  31. 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