Skip to Main Content
Getting Started with PeopleSoft Query
PeopleSoft Query Overview
PeopleSoft Query Business Processes
Other Sources of Information
PeopleSoft Query Implementation
Creating and Running Simple Queries
Understanding Query Types
Understanding Dirty Reads in PeopleSoft Query
Common Elements Used to Create and Run Simple Queries
Creating New Queries
Saving Queries
Running Queries
Adding Queries to the Internet Explorer Favorites List
Downloading Queries
Performing Query Lookups
Performing Definitional Reference Lookups in Queries
Printing Query Results
Using Query Viewer
Defining Selection Criteria
Choosing Selection Criteria
Defining Criteria
Defining Prompts
Defining HAVING Criteria
Defining Record and Field Dependencies
Defining Expressions
Extracting and Transforming Data from PeopleSoft Pure Internet Architecture
Drilling URLs in PeopleSoft Query
Understanding Drilling URLs
Defining Query Drilling URLs
Defining Component Drilling URLs
Defining External Drilling URLs
Defining Attachment Drilling URLs
Defining Free Form Drilling URLs
Defining Image Drilling URLs
Defining REST Drilling URLs
Viewing Query Results With Drilling URLs
Scheduling Queries With Drilling URLs
Modifying, Scheduling, and Organizing Queries
Modifying Queries
Scheduling Queries
Organizing Queries
Working with Advanced Query Options
Working with Aggregate Functions
Working with Subqueries
Working with Unions
Joining Records
Using Connected Query
Understanding Connected Query
Using Connected Query Quick Start
Using Connected Query Manager
Using Connected Query Viewer
Using Connected Query Scheduler
Using Composite Query
Composite Query Overview
Creating Composite Query Definitions
Defining Composite Query Prompts
Defining Joins in Composite Queries
Defining Expressions in Composite Queries
Defining Drilling URLs in Composite Queries
Defining Filters in Composite Queries
Applying Aggregate Functions in Composite Queries
Applying Group By Clause in Composite Queries
Editing Field Properties
Defining HAVING Criteria in Composite Queries
Viewing SQL in Composite Queries
Previewing Composite Query Results and Viewing Composite Query Properties
Editing, Copying, and Deleting Composite Queries
Using Composite Query Viewer
Using Composite Query Scheduler
Creating Workflow Queries
Understanding Workflow Queries
Defining Workflow Queries
PeopleSoft Query Security
Using Query Access Group Trees
Using Row-Level Security and Query Security Record Definitions
Using Query Profiles
Query Administration
Understanding Query Administration
Using Query Administration