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.
Continue reading
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 readingHow 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 […]
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
1
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 […]
Continue reading