Autoplay
Autocomplete
Previous Lesson
Complete and Continue
PeopleSoft Query
Welcome
Welcome
1. Introduction to PeopleSoft Query
Course Structure
Introduction to PeopleSoft Query (4:16)
Query Manager Search Page (10:50)
Query Viewer (4:35)
Understanding Query Manager for existing queries (11:44)
Scheduling Queries (5:43)
Quiz
2 Using PS Query
Create new Query in Query Manager (7:36)
Adding Criteria to Queries (6:13)
Joining 2 tables (6:04)
Creating Runtime Prompts (4:06)
3 Managing & Organizing Queries
Renaming a Query (5:37)
Deleting Queries (3:26)
Managing Queries in Folders (4:15)
Copy query to another user (6:22)
4 Expressions - Part 1
Using Expressions in Query (8:24)
Using Expressions in Query Criteria (2:55)
Using COUNT in Expressions (5:14)
Using Arithmetic Expressions (3:27)
Using Literals in Expressions (6:16)
5 Expressions - Part 2
Using Functions in Expressions (6:53)
Using INSTR function in Expressions (3:47)
Using SUBSTR function in expressions (4:31)
Using INITCAP in expressions (3:25)
Using LTRIM & RTRIM in expressions (4:15)
Combining Functions in Expressions (ADVANCED) (7:05)
Using prompts in Expressions (4:44)
6 Run time Prompts
Runtime Prompts (No Table Edit) (4:34)
Prompts with Prompt Table Edit (3:15)
Creating Multiple Runtime Prompts Translate Table (3:20)
Yes No Table Prompt (3:35)
7 Criteria
Criteria Types
Using Criteria in Queries (10:21)
Use Grouping and Reorder in Criteria (5:03)
Using the Having Criteria (4:03)
Using Effective Date Field in Criteria (4:03)
8 Performing Joins
Creating Standard Joins (6:02)
Using Outer Joins (8:51)
Auto Join (5:13)
9 Using Subqueries
Creating a Single-Value Subquery (6:36)
Creating an In-List and Not-In-List Subquery (6:11)
Creating an Exists or Does-Not-Exist Subquery (5:09)
10 Working with Unions
Creating Unions (6:01)
Using Literals as Placeholder Fields (7:12)
11 Drilling URLs in a PeopleSoft Query
Query URL Widgets (12:39)
Component URL Widgets (8:34)
Freeform URL Widgets (3:59)
Attachment URL Widget (6:15)
12 Query Monitoring & Administration
Query Administration (10:57)
Enable Logging for Queries (3:42)
Disable a Query (3:12)
Change Query Owner (3:29)
Renaming & Deleting a Query (1:44)
Move to Folder & Clear Query Stats (2:49)
Monitor current query performance (1:40)
Reviewing Query Administration settings (1:43)
13 PeopleSoft Connected Query
Connected Query - Create Parent Child Queries (9:38)
Using Connected Query Quick Start (8:24)
Using Connected Query Manager (3:58)
14 PeopleSoft Composite Query
Composite Query Manager (5:04)
Run Composite Query (3:04)
Using Prompts in Composite Query (2:26)
15 PS Query Security
Securing PS Query Component Access (5:10)
Granting Access to Query Components (8:24)
Restricting Records Accessing using Query Security Tree (9:22)
Query Trees & Access Groups (8:19)
Create custom Query Trees & Access Groups (7:31)
Row Level Security (2:56)
Implementing Row Level Security using Query Security Records (4:02)
16 Query Backup & Migration
Migrate Queries using Application Designer (6:48)
Backup & Migrate queries using tables (2:59)
Backup & Migrate Connected and Composite Queries
Joining 2 tables
Lesson content locked
If you're already enrolled,
you'll need to login
.
Signup in Course to Unlock