fbpx

Log in

Please log in to continue.

Forgot your password? Click here to reset.

Not a member? Register Now. Registration is Free!

Register

Fantastic! Before you enroll, do you have an account with us? If so, please log in to continue. Otherwise, we have a simple three-step process:

① REGISTER

Already a member? Log in.

A username may contain letters, numbers, spaces, underscores, hyphens, periods, and the @ symbol

By clicking register, I agree to receive communications from JSMpros. I understand that I can opt-out of communications at any time and that opting out may result in missed notices regarding my account.

① LOG IN

Login

Forgot Password?
Register

Confirm your e-mail Address

Check your e-mail (and spam/junk) for an e-mail from us asking you to confirm your e-mail address. After confirmation, return to this dialog to complete step 3: Enroll in this course.

③ Purchase this course

Check your e-mail (and spam/junk) for an e-mail from us asking you to confirm your e-mail address. After confirmation, return to this dialog to complete step 3: Enroll in this course.

PeopleSoft Query 2

Advanced Query Topics

Adhoc analysis, data sources, and reporting

  • Manual joins
  • Expressions
  • Subqueries
  • Outer joins
  • Unions
  • Connected queries
  • Composite query
  • Pivot Grids
  • Security

PeopleSoft Query is the data source for many PeopleTools features, such as Pivot Grids, BI Publisher, and Elastic Search

Pricing and Availability

On-Demand

Not Recorded Yet
Let us know you
are interested!

Live-Virtual

Interested? Let us know!
Get on the notification list
$2,354 USD

Group

By-request
2-days
$23,540 USD

About Delivery Options

Topics Covered

  • Automatic joins
  • Manual joins
  • Expressions
  • Criteria expressions
  • Prompts in expressions
  • Aggregates in expressions
  • Concatenation expressions
  • Drilling URLs
  • List-of-values subqueries
  • Exists subqueries
  • Outer joins
  • Unions
  • Connected queries
  • Composite queries
  • Pivot grids
  • Query security trees

Who Should Attend?

  • Functional analysts
  • Functional users
  • PeopleSoft Developers
  • Administrators