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

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