PS Query & SQL

Recently the Student Records team at Azusa Pacific University discovered a few advanced PeopleSoft Query tricks to do things that only seemed possible with other tools. This session will cover some of those expressions in depth, and show how APU uses them to their advantage. Examples will be from Student Records and Campus Community, although the tools can be applied to all areas.

There will be a look at custom GROUP BY/PARTITION BY logic for Aggregate and Analytical functions. Next, a close look will be taken at two expressions: LISTAGG and NTH_VALUE, and how they've saved APU a ton of unnecessary work in Excel, BI Publisher, and Connected Query.

https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=fcc8c68f-6ca5-4496-bd73-558a0f1c7fc1