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 […]
Since the implementation of SFIS to PeopleSoft Version 9.0, a list of Wesleyan Functions has been made available for viewing from within PeopleSoft. This is the list that formerly was available through STOWE, but is no longer there. This list contains only Wesleyan Functions that contain the word “GET” and includes a number of Functions that […]
This article highlights the use of runtime prompts when creating criteria in Query. One key benefit of prompts is that when you run the query, you can change the criteria as necessary, in various combinations as required, to achieve the desired results. An excerpt from PeopleBook: PeopleSoft Query explains the use of prompts as follows: Adding a […]
