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
1
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 […]
Continue readingDatetime 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 […]
Continue readingPeopleSoft 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