PSQuery – PeopleSoft Tutorial

Tag Archive

Tag Archives for " PSQuery "

BI Publisher New Features in PeopleTools 8.57

BI Publisher reporting tool for PeopleSoft has couple of new features with PeopleTools 8.57 such as using Composite query as a data source type and psxp_cq_report_viewer property.

PUM: Finding PUM maintenance info using PS Query

PUM has changed the way how you apply bugs and get new features for PeopleSoft 9.2 applications. Critical part of PUM process is the PeopleSoft Image which is cumulative and contains thousands of bugs, patches and enhancement. These bugs (or new features) can be extracted from PUM Image (SOURCE) and then applied to your TARGET […]

How to access SQL for a Private PS query of another user

PS query is a powerful tool for end users to fetch data from PeopleSoft application and users can create public and private queries. Although public queries can be viewed by anyone having access to Query Viewer or Query Manager but private queries can only be seen by the user who created them. But there could […]

How to copy or share private ps query with another user

So you created an awesome private query and now you want to share it with another user. Since it’s a private query only the user id who created the query will have access to it. One way is to change the ps query from private to public. By making it public, everyone who has access […]

How to transfer private ps query from one user to another

There is a general difference between public and private query. As the name suggests, public query is available for everyone whereas private query can be used by the person who created it. But there could be a scenario, where you want to transfer private query of one user to another. This could happen when someone […]

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 […]

How to use Trees as filter criteria in PS Query?

There can be scenario where you want to filter your PS Query results based on a Tree node. There is an option “in tree” in the criteria condition that can be used to select a tree or a specific node of a tree to filter out data based on this criteria. In this video you […]

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 […]

Datetime field format error

This is a quick short post for resolution of the datestamp error while running a PS Query. Datestamp errors are quite common when running a PS Query. When you run a PS Query and are prompted to enter the datetime value – many a times you will end up entering a wrong format and you […]

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 […]

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 […]

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 […]

Transfer Private PS Queries From One User To Another

If any user leave the department and there are many Private queries which needs to be transferred to any new user, then there are 2 ways to do this. Option1: Log in as the user who owns the query, go to Query Manager in PeopleSoft and change the queries from Private to Public. Now new […]