Tag Archives: PS Query

Delete PS Queries assigned to a User

Quick post after a very long time… 🙂 Here’s a code snippet that you can use to Delete PS Queries that are assigned to a particular user. Hope this helps! 🙂   Advertisements

Posted in Code, Oracle, PeopleSoft, SQL | Tagged , , , , | Leave a comment

Populating Tree Selector Tables in PeopleSoft

Hello All, If you’re using Tree Selector tables for Department, Business Unit security, once you make changes to the Tree , the tree values in tree selector tables are deleted – while you can use nVision to populate the Tree Selector … Continue reading

Posted in Code, PeopleSoft, PeopleSoft HCM | Tagged , , , | Leave a comment

PS Query Statistics

All, Here’s a quick code snippet that you can run to get details on how many times a PS Query has been run, the most recent date time it was run and so on –  the table to use is PSQRYSTATS. … Continue reading

Posted in Code, Oracle, PeopleSoft, Uncategorized | Tagged , , | Leave a comment

Using Colon in an Expression result in PeopleSoft PS Query

Here’s a quick PS Query snippet : If you’ve ever wanted to use a colon in an expression – say something like displaying a colon between HH(hours) and MM(minutes), PeopleSoft PS Query would throw an error – because the Query … Continue reading

Posted in Code, PeopleSoft | Tagged , , , , , , | Leave a comment

Less than or equal to PeopleSoft PS Query

Have you ever wondered how to add less than or equal to (<=) or greater than or equal to (>=) in a PeopleSoft PS  Query? When you add a custom criteria, from the drop down select Not greater than for … Continue reading

Posted in Uncategorized | Tagged , | 2 Comments