Tag Archive

Tag Archives for " PSQuery "
3

How to use Join in PSQuery

Whenever you need to get data from 2 tables, you can use join on those tables using PSQuery. Joins retrieve data from more than one table, presenting the data as if it came from one table. PSQuery links the tables, based on common columns, and links the rows on the two tables by common values in […]

Continue reading

How to schedule a PeopleSoft PS Query?

PS Query is an important tool to get information from PeopleSoft tables. Mostly users run PS Query directly from Query Manager to get the output. But you can also schedule any PS Query to setup one or more runs of a query. Recurrence can be set to run query on daily, weekly, monthly basis or […]

Continue reading

PeopleSoft Query – Which Tables are Involved?

PeopleSoft Query is a great way to retrieve information from PeopleSoft without having to write the complex SQL queries. However, as a PeopleSoft admin – there may be situations when you need to seek information from the PeopleSoft Query tables. For example, find out the private queries of a PeopleSoft user; Convert all private queries […]

Continue reading

Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server.

One of the common errors encountered while running a PSQuery is: “Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server.“ As the error message suggests, this error has been caused due to huge result size, which the application server is unable to render […]

Continue reading

PSQuery Not Running

Came across a situation where the PSQuery does not run even after you click of ‘Run’ or ‘Run to Excel’ or ‘Run to HTML’. This post is to address such situations. On clicking these buttons/links nothing happens and the page(browser) remains AS-IS instead of launching new window to run the PS-Query where it would also […]

Continue reading