Maintaining a Private PeopleSoft Query Library

Body

Private query libraries can become large easily, it is important to review and update your queries periodically

Detailed Information

. 
This Article includes instructions for reviewing and cleaning your private queries.

 

Keeping it Clean

  1. Log in to MaineStreet and go to Query Manager

  2. Choose "Advanced Search"
    Advanced Search example

  3. Choose "Private" under Owner.
    selecting private queries example

  4. Check the box(es) for unwanted queries. Choose "Delete Selected" under "Action". 
    selecting queries to delete examlpe

  5. Make sure that the queries you selected are "Private."  Click "Go."

  6. Click "Yes" in the pop-up window


Confirm the permanent deletion of all selected queries Yes/No example

NEVER delete a public query unless you are the creator of the query! (for Campus Solutions and Human Resources queries)

Tip - If you are not sure about a query, click "Edit". Go to the  "Properties" link below the fields grid

PeopleSoft Properties Menu

You can see the last updated time and person's ID.

Query Proerties example

Environment

All PeopleSoft Databases

 

Details

Details

Article ID: 159368
Created
Fri 5/10/24 5:01 AM
Modified
Wed 10/2/24 3:21 PM
Applies To
Students
Faculty
Staff

Related Articles

Related Articles (2)

PS Query Best Practices
Saving & Organizing Queries

Related Services / Offerings

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)