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 readingThere 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 readingWhenever 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 readingThere 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 readingPS 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