Common Elements Used to Create and Run Simple Queries
Field or Control |
Definition |
---|---|
Add Record |
Click this link to access the Query page, where you can add fields to the query content or add additional records. |
Show Fields |
Click this link to display the fields included in the record. |
Col (column) |
Displays the current column number for each field listed. |
Query Name |
New Unsaved Query appears in this read-only field until you change it on the Properties page. This field appears on all of the Create New Query pages. |
Record.Fieldname |
Displays the record alias and name for each field listed. Note: You can select and add up to 676 records for each query. The record alias goes from A to Z for record number 1 to record number 26. When you add record number 27 and after, the record alias starts at AA and follows the pattern AB, AC, AD, and so on. The record alias doesn't include AS and TO, and ends with ZX, ZY, ZZ. |
The Key icon indicates key fields. |
|
Click the Delete button to delete the row. A confirmation message appears. Click the Yes button to proceed with the deletion. Click the No button to cancel the deletion. |
|
Click the Use as Criteria or Add Criteria button to open the Edit Criteria Properties page, where you can determine how this field will be used as a criterion for the current query. |
|
From the Query tab, click the Folder button to view the fields for the chosen record, if they are not already displayed. Query Manager expands the record so that you can see the fields and make sure that this record has the content that you want. Click the Folder button again to hide the fields for a record. A key is displayed to the left of key fields. |
|
Hover over to view the feeds of this query. |
|
Save |
Click to save a query at any time after you have selected one record and at least one field for it. |
Save As |
Click to access the Query Properties page where you can enter basic information about the query and save it. |
New Query |
Click to access the PeopleSoft Query Manager where you can start creating a new query. See Creating New Queries. |
Preference |
Click to access the Preference page where you can specify query preferences. |
Properties |
Click to access the Query Properties page where you can view and edit data about the current query, such as the query name and description. You can also record information about your query so that you can use it again in the future. In addition, you can define how images are displayed in the query results. |
Public As Feed |
This link is available only when query was not published as feed. Click to access the PSQuery Data Type - Publish Feed Definition page where you can define feed properties such as the feed title, security, and other options. |
Manage Feed |
This link is available only when query was published as feed. Click to access the PSQuery Data Type - Publish as Feed page where you can define feed properties such as the feed title, security, and other options. |
Publish as Pivot Grid |
Click to display all existing Pivot Grid models that use the current query as the data source. You also have the options to either edit the existing Pivot Grid models or add new ones. If you add a new model, a unique title name must be provided. Similar to the Pivot Grid Wizard, this feature enables you to open and edit the Pivot Grid models for which you are granted permission. The security access for using this feature is the same as using Pivot Grid Wizard. |
New Union |
This link is available only when query does not have union. Click to create an union of multiple queries. See Working with Unions. |
Delete Union |
This link is available only when a query has a union attached. Click to delete an existing union of multiple queries. See Working with Unions. |
Return to Search |
Click to return to the Query Manager search page where you can create new queries, modify existing queries, schedule queries, and organize queries. See Modifying Queries, Scheduling Queries , Organizing Queries. |