You can open the PeopleSoft Query tool by clicking on the MaineStreet icon in your MyCampus portal. Your icons may be somewhat different, but you should have this MaineStreet link. If not, go to mainestreet.maine.edu, click to go to mainestreet (if prompted) then log in.
Run a query and display results in a new browser window
Download a query
Print a query
Schedule a query
Additionally, Query Manager enables you to:
Edit a query
Save and rename queries
Delete a query
Searching For Your Query
From the Query option, select Query Viewer or Query Manager and it will present you with a search bar. If you know the name of the query you are looking for, you can copy and paste or type the name in the the search bar and click search.
Don't have a query to try? Please ask your supervisor for the name of a query to run. Running random queries will create unintended results.
Have a query in mind but can't remember the exact name? See Advanced Search below to help you find it.
If you don't know the exact name, you can also use the drop down menu to search for the description, a field used in the query, etc. This Advanced Search option is also available when creating a new query to search for records (tables).
For more search options than just the drop down menu, you can click on Advanced Search
Advanced Search provides many options.
The options of <, <=, =, >, >=, begins with, between, contains, in, not= will return all queries matching the criteria entered into the text box(es) in the following areas:
Uses Record Name
Uses Field Name
Access Group Name
For example, an advanced query search of the following will return all queries that begin with UMS, have 'student' in the description, and contain EMPLID as a field:
Once you find your query, you have some options to organize your landing page. The search below was for UMS_DTS_S and turned up all of the relevant queries. Once you find your query, you have the option to save it to your favorites. A handy feature if you are running the same report frequently.
Simply click the Select box on the left of the query you want and choose Add to Favorites from the dropdown Action menu. Going forward, this query will show in My Favorite Queries when you access Query Manager. Any private queries will show first followed by public queries you have added to favorites.
Now you can run the query by selecting HTML under Run to HTML. The query will then open in a new tab in your browser and will provide the option to download to excel. Click on HTML, enter any additional criteria required on the next page and click "view results." You also have the option to run to Excel directly, which will automatically download the query in an excel document to your computer. If you have a query that takes too long to run, you can schedule the query. See Scheduling Queries for the instructions.