PS Query & SQL

Have you ever run into a road block using PeopleSoft Query Manager and wondered if you could get the job done without direct SQL access? Are you transitioning away from Crystal Reports and want to utilize PS Query as much as possible? Do you enjoy using creativity to push a tool to its limit? If so, you’ll find value in this presentation of lesser-known PS Query capabilities. We’ll explore query criteria and prompts that allow you and your users to filter by a pasted list of desired values. We’ll dive deep into subqueries to filter out a variety of duplicate data. An array of expression functions will be discussed, including ones that can flatten your output data.

https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=670f0949-6783-43e1-8a4b-40224ea76081