NEWHEUG August Workshops and HEUG Query Webinar
Jul. 20, 2017 by Carolyn Pike
Below are updates about the upcoming NEWHEUG Conference and the recently presented HEUG Webinar on Query Manager.
NEWHEUG Conference Workshops
NEWHEUG (New England Regional User Group) has announced four workshops at the NEWHEUG Alliance 2017 Conference. The workshops will be offered on Monday, August 14 prior to the main conference.
Click here to see details about the workshops.
Two of the workshops will be looking at:
3Cs Communication Generation Step by Step by Step (Speaker: Christopher Tatro, Tufts University)
In this workshop we will dive deep into the setup of 3Cs Communications, covering all steps necessary to produce either letters or emails. We will look at some of the common problems or issues in Communications and resources to solve them.
Intro to PS Query Workshop (Speakers: Gregg Jenczyk and Criss Laidlaw, Williams College)
This two-hour workshop will introduce attendees to PeopleSoft’s Query application, once of the most widely-used reporting tools in the PeopleSoft environment.
Attendees will learn how to create simple queries, select and sort query results, join tables together, define expressions and prompts, and generate results in several formats using the web version of PeopleSoft Query.
This workshop will be most helpful for novice Query users who want to understand the basics.
July 13 HEUG Webinar Available for Download
The webinar Taking PS Query Manager to the Limit is now available for download on HEUG. Click on the link and log in to the HEUG website.
Have you ever run into a roadblock using 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 will find value in this presentation of lesser-known PS Query capabilities. We will explore query criteria and prompts that allow you and your users to filter by a pasted list of desired values. We will 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.
(During the webinar, a recommendation was made to view an Alliance presentation that contains a lot of very useful material on working with query expressions. HEUG sent a link to that presentation to the participants which you might want to take look at: Expressions In Query: An In-Depth Exploration Into Function Statements. You will also see examples from this Alliance offering in the SFIS Blog: Query – EXPRESSIONS / FUNCTIONS.)