Using Connected Query Viewer
Connected Query Viewer is a read-only version of Connected Query Manager. It enables security administrators to limit users with a role of Connected Query User (permission list PTPT2800) to search for and view connected queries that have a status of Active.
Use the Connected Query Viewer page (PSCONQRSSRCH) to view the results of a running connected query: preview the XML, schedule a connected query to run immediately with results displayed in a separate window, or schedule the connected query to run at a later time.
Navigation
Image: Connected Query Viewer page
This example illustrates the fields and controls on the Connected Query Viewer page. Definitions for the fields and controls appear following the example.
|
Field or Control |
Definition |
|---|---|
| Search |
Click to search for a connected query using the basic search function. Combined with only the begins with condition, the basic search enables you to select the following Search by criteria: Connected Query Description, Connected Query Name, Connected Query Status, and Owner. |
| Advanced Search |
Click the Advanced Search link to search for a connected query using the advanced search function. The advanced search enables you to perform a narrower search by using one or more Search by criteria and selections of conditions for each Search by criterion. You can select the following Search by criteria: Connected Query name, Description, Status, Ownership Type, and Case Sensitive Search. |
| Preview - Max Rows For Query |
Enter a number of rows to be returned from each query in a preview mode. You should limit the number of rows that are being returned. The default value is 6. If you enter 0 or clear this text box, no row limits will be imposed for a resulted XML, which can cause a significant delay in getting results; and because the application runs in a synchronized mode using application server, you may get browser time-out or tuxedo time-out errors. |
| Preview XML |
Click a Preview XML link for the selected connected query to view its results in a new browser window. Note: The Preview XML action uses the Application Server to generate and configure XML data, thus you have to wait for XML data to be available. To keep working while system generates and configures XML data, use the Run to Window link, which does not limit number of rows returned from each query. If the connected query has prompts, a prompt window appears after you click the Preview XML button. |
| Run to Windows |
Click a Run To Windows link for the selected connected query to schedule that query to be run immediately using PeopleSoft Process Scheduler, and then view its XML results in a new browser window. |
| Schedule |
From the Connected Query Viewer search results page, click the Schedule link that is associated with the connected query. Connected Query Viewer interacts with PeopleSoft Process Scheduler to enable you to schedule connected queries. You can submit requests to schedule a connected query, check the status of your request using Process Monitor, and view connected query results using Report Manager. See Understanding Process Monitor, Viewing the Status of Processes, Administering Report Manager. |
| Lookup References |
Click this link to display the Definitional References to Connected Query window where you can view all PeopleSoft definitional objects that use this particular connected query as the data source. The results show the definition ID, definition type, and definition sub-types if they are available. See Performing Definitional Reference Lookups in Connected Queries in Using Connected Query Manager. |