Student Faculty Information System

Jul. 6, 2010 by Carolyn Pike

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 review the material at your own convenience and observe some of the demonstrated queries in Query Manager.

Please feel free to contact me with any questions about these subjects or if you have a specific query you would like to discuss.

The topics covered are

Improving Query Performance

Selecting Tables by Size
Sorting Criteria by Selection of Data

Joins

Tables and Views
Record Hierarchy
Related Record
Auto Join
Manual Joins/Un-joins

Expressions Review

Main points about Expressions
Reasons to use expressions
Concatenation
Aliases
Literals
Case
Maintaining Expressions

Wes Function Review

Examples

More About Prompts

Restricting User Input with Table Edits
- Prompt Table Edit
- Translate Table Edit
- The Yes/No Table Edit
Unrestricted User Input

Aggregate Functions and Having Criteria (using Summary Calculations)

Using Aggregate Functions
Having Criteria
Using Predefined Aggregate Functions
Using Having Criteria in Queries

Mastering Outer Joins

Selecting criteria that belongs to On Clause
Outer Join using (+)

Subqueries

Purpose of Subqueries
Test for Existence and Non-existence
Compare a Field to a List

Union Queries

Described
Using Literals in Unions

Tags: Criteria, Demonstration, Expression, Outer Join, Prompts, Query - Advanced, Subquery, Summarizing, Table Ordering, Union

Posted in Query - Advanced, Query - Getting Started

Comments are closed.

PeopleSoft Query – Advanced Concepts