Maintaining a Private PeopleSoft Query Library

This article shows how to view your private PS Query library and delete queries.

Instructions

Private query libraries can quickly grow, so it is crucial to review and update your queries periodically.

  1. Log in to MaineStreet and go to Query Manager

  2. Choose "Advanced Search"
    showing the location of the advanced search function in the lower left on the Query Manager Search area

  3. Choose "Private" under Owner.
    showing the advanced search, highlighting the owner being set as private.

  4. Check the box(es) for unwanted queries. Choose "Delete Selected" under "Action". 
    showing two queries selected and delete selected option selected in the action dropdown menu.

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

  6. Click "Yes" in the pop-up window
    showing the confirm Yes or No for permanent deletion message that will pop up to verify if deletion is correct.
    NEVER delete a public query unless you are the creator of the query! (for Campus Solutions and Human Resources queries)

Helpful Tip

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

showing the location of the properties menu for a query.

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

Showing an example of a query's properties which include the last update date/time and last update user ID.

Environment

  • PeopleSoft® Query