This is a review of our most recent Query Instruction meetings both of which focused on using Joins in Query. This is also an overview of the content of the next classes which will be about using Expressions and Functions (including Wesleyan Functions). If you are unable to attend the classes, feel free to make […]
The three sections of PeopleSoft Query Instructions are updated and available for your use. You can take a look at the Overview or go to each section: Part I – Basic Query Concepts and Query Viewer Part II – Query Manager Part III – Advanced Concepts They are in the form of […]
Now available on the SFIS Blog – PeopleSoft Query Advanced Concepts documentation. This on-line instruction follows up on the training presented in the Introduction to PS Query course. It reviews and reinforces a number of topics previously presented and introduces additional subjects such as aggregate functions, having, outer joins, subqueries and union queries. You can […]
Since the introduction of the SFIS Blog last week, there have been three additions to the Query section that you should know about: First, there is a Query Tip Sheet that has hints, suggestions, and ideas. Among the topics discussed are joins, table ordering and criteria. This page will be added to as needed. […]
