Maintaining a Private PeopleSoft Query Library

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

Submit an Inquiry or Request to DARTS Print Article

Details

Article ID: 159368
Created
Fri 5/10/24 5:01 AM
Modified
Mon 7/1/24 4:06 PM
Applies To
Students
Faculty
Staff

Related Services / Offerings (1)

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