Create a Query from a PeopleSoft Component

Description

One of the biggest challenges for end-users when writing queries is figuring out where to find the data to query against. This project is intended to allow a user to pick a component name, and then create a query against the records that are referenced in the pages in the component.

It will have the following pieces:

• An application engine program to simplify initial testing of the query creation code.
• A page, component, and associated permission list to allow end-users to create queries by picking a component name.
• The code to generate the query by searching the PeopleSoft metadata and using the Query Classes to generate the query.

Downloading the Project

Here is how you can download this project for your own use:

The current version of the PeopleTools objects can be installed in your environment using the following attachment . Here are the instructions for how the installers work. Also, at the bottom of this wiki page are attachments for the other revisions in the source code repository.

Any other objects can be downloaded directly from the pshome folder in the source tree

Bugs/Feature Requests

Existing bugs and feature requests for QueryFromComponent are here.

If you have any issues, create a new ticket (requires registration).

Source

You can browse through the source code here. A good place to start is by taking a look at the CreateQueryFromComponent function in GS_QRY_UTILS.GS_CRT_QRY_DB.FieldFormula PeopleCode.

Registered users can check out QueryFromComponent from  here using Subversion.

Recent Changes

[56] by larry.grey on 2010/06/24 17:19:52

Created user interface to allow user to pick the component to create the query against.

[55] by larry.grey on 2010/06/24 17:02:55

Added code to allow this to work for more complex components. This required eliminating related displays.

[54] by larry.grey on 2010/06/24 17:01:00

Updated to allow adding more than just the GL_ACCOUNT_TBL record. Needed to make sure that the records added share the same key structure as the search record.

[53] by larry.grey on 2010/06/23 22:08:36

Extended to loop through the records in a component and log the results. Also to not hard-code the settings for adding fields to the query.