Use the Records page to select the records on which to base the new query.Step 1
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
Use the Show Fields link to display the fields that are included in the record.Step 3
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
The Primary Key Field icon indicates key fields.Step 5
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
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
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
The Col (column) field displays the current column number for each field listed.Step 9
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
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
Use the Edit button to display the Edit Field Properties page.Step 12
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
Use the Edit Field Ordering page to change the column and sort order for multiple fields.Step 14
The Record.Fieldname field displays the record alias and name for each field listed.Step 15
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
Use the Aggregate function to perform a computation on a set of values rather than on a single value.Step 17
Use the Edit Criteria Properties page to edit selection criteria properties for your query statement.Step 18
Use Expressions to calculate formulas that PeopleSoft Query returns as part of a query.Step 19
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
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