PeopleSoft Connected Query

If you’ve been using PeopleSoft for any length of time, you know what a query is and possibly how to create a query.  There are many users that can quickly and easily create a basic query from a table or set of tables.

when you need to create a complex report that is not achievable through a simple query, a developer is required to either write an SQR with nested loops or create an application engine program with PeopleCode that produces structured data to be used with XML Publisher.

And this is where the Connected Query comes into play.  The connected Query is new in PeopleTools 8.5 and enables you to create a single XML file based on a set of queries with parent-child relationships.  This means you can create multiple queries which are very simple and join them together or “Connect” them to achieve the same results that you would by programming an SQR or Application Engine.  That’s pretty powerful in my opinion.

I will show you steps involved in creating a connected query.

First of all we need to create PS Queries which will work as a building block for PS Query.

After creating the PS Queries Navigate to :

Main Menu > Reporting Tools >Connected Query> Connected Query Quick Start.

Provide Name and Description of Connected Query. Click Next

 

Provide Parent Query Name. Click Next

Provide Child Query Name. Click Next

Now map the fields of Parent Query to Child Query.  Click Next

Click on Complete.

Use controls to add child/ sibling queries to child query as per requirement.

Click on Preview xml to see the output.

The following table lists the delivered Connected Query permission lists and roles.

Permission List	Role	Description
PTPT2700	Connected Query Developer	Provides full access to Connected Query applications.
PTPT2800	Connected Query User	Provides access to run, preview results, and schedule a connected query. User will not be able to modify existing or create new Connected Queries