Understanding Query Execution

A third-party application will execute a PeopleSoft query using the same basic steps as a PeopleSoft online user. This table lists the steps to execute a query and retrieve query results.

Steps

Description

1. Select query.

QAS service operations are available to find and list existing queries.

2. Enter prompts.

QAS web services are available to retrieve query prompts and get translate values and prompt table values.

3. Filter fields.

A service operation is available to list all of the fields in a query.

4. Execute the query.

QAS service operations are available to execute a query synchronously or asynchronously.

5. Retrieve query results.

A service operation is available to retrieve the query results.

6. Cancel a query.

QAS provides a service operation to cancel query execution.

7. Retrieve query status.

QAS provides a service operation to retrieve the current query execution status.