Understanding the Query Creation Process

A third-party application will create a PeopleSoft query using the same basic steps as an online PeopleSoft user. In the process of creating the query, you will need to integrate with the PeopleSoft system to access records and fields, as well as save the query in the PeopleSoft database. This table lists the steps to create and save the query.

Steps	Description
1. Select records.	QAS service operations are available to select the records from the PeopleSoft database. Query security is enforced and only records available to the user ID provided in the request will be returned.
2. Add fields to the query.	QAS service operations are available to select fields and field properties from the PeopleSoft database.
3. Create query expressions (optional).	The third-party application will create any expressions necessary for the query.
4. Create Prompts (optional).	The third-party application will create any prompts necessary for the query.
5. Define selection criteria (optional).	The third-party application will create the selection criteria necessary for the query. QAS provides service operations for accessing tree information that can be used in the selection criteria.
6. Define HAVING criteria (optional).	The third-party application will create any HAVING criteria necessary for the query.
7. Save the query.	Once the third-party has defined the query, the QAS service operation for saving the query is used to save the query in the PeopleSoft database.

Note:

Creating connected queries is not supported in QAS.

Note:

Updating queries is not supported in QAS.