Update Tree Effective Date in "In Tree Criteria"

Description

One limitation int PeopleSoft Query with "In Tree" criteria is that the criteria is bound to a specific effective date. This project will look at all queries with a specific prefix and update the effective date of the tree in the criteria to be the most recent tree for the DEPTID chartfied.

This can be easily updated for other chartfields on an as needed basis.

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 UpdateTreeEffdtInQry are here.

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

Source

You can browse through the source code here. The best starting place is in the GS_QRYEFFDT Application Engine program.

There are project installers listed below if you'd like to install the project locally in your own environment.

Registered users can check out UpdateTreeEffdtInQry from  here using Subversion.

Recent Changes

[47] by larry.grey on 2010/06/22 20:36:38

Updated to loop through all queries with a prefix of "GS"

[46] by larry.grey on 2010/06/22 20:34:47

Updated to apply the tree change back into the query definition and to save the updated query.

[45] by larry.grey on 2010/06/22 20:32:35

Added code to determine the most recent effective date for the tree used in the query, and to apply it to tree criterion string and log it.

[44] by larry.grey on 2010/06/22 20:30:33

Added code to decompose and log "in tree" criteria.