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 […]
Continue readingHow 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 […]
Continue readingHow 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 […]
Continue reading
How To Transfer Private PS Query From One User To Another
There is a general difference between public and private queries. As the name suggests, the public query is available for everyone whereas a private query can be used by the person who created it. But there could be a scenario, where you want to transfer the private query of one user to another. This could […]
Continue reading
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