Understanding Common Query Elements


Concept


Steps:

  1. Use the Records page to select the records on which to base the new query.

    Step 1
  2. Use the Add Record link to access the Query page, where you can add fields to the query content or add additional records.

    Step 2
  3. Use the Show Fields link to display the fields that are included in the record.

    Step 3
  4. Use the Query page to add  fields to the query content.

     

    You can also use this page to add additional records by performing joins.

    Step 4
  5. The Primary Key Field icon indicates key fields.

    Step 5
  6. Use the Folder button to view the fields for the selected record if they are not already displayed.

     

    When you click this button, Query Manager expands the record so that you can see the fields and confirm that this record has the content that you want.

     

    Click the Folder button again to hide the fields for a record.

    Step 6
  7. Use the Fields page to view how fields are selected for output; view the properties of each field; and change headings, order-by numbers, and aggregate values.

    Step 7
  8. The Query Name field appears on all of the Create New Query pages.

     

    The New Unsaved Query status appears in this read-only field until you save the query using the Query Properties page.

    Step 8
  9. The Col (column) field displays the current column number for each field listed.

    Step 9
  10. Use the Reorder/ Sort button to display the Edit Field Ordering page, which enables you to change the column order and/or sort order for multiple fields.

    Step 10
  11. Use the Use as Criteria/Add Criteria button to access the Edit Criteria Properties page, where you can determine how this field is used as a criterion for the current query.

    Step 11
  12. Use the Edit button to display the Edit Field Properties page.

    Step 12
  13. Use the Delete button to delete the row.

     

    After you click this button, a confirmation message appears. Click the Yes button to proceed with the deletion. Click the No button to cancel the deletion.

    Step 13
  14. Use the Edit Field Ordering page to change the column and sort order for multiple fields.

    Step 14
  15. The Record.Fieldname field displays the record alias and name for each field listed.

    Step 15
  16. Use the Edit Field Properties page to format the query output; for example, to change column headings or display translate table values in place of codes.

    Step 16
  17. Use the Aggregate function to perform a computation on a set of values rather than on a single value.

    Step 17
  18. Use the Edit Criteria Properties page to edit selection criteria properties for your query statement.

    Step 18
  19. Use Expressions to calculate formulas that PeopleSoft Query returns as part of a query.

    Step 19
  20. Use the Query Properties page to view and edit data about the current query, such as the query name and description.

     

    Also use this page to record information about your query so that you can use it again in the future.

    Step 20
  21. Use the Distinct option to remove duplicate rows of data in your queries.

    Step 21

You have successfully reviewed the Understanding Common Query Elements topic.

Table of Contents  Start Topic