Accessing Query Viewer in MaineStreet
- Sign on
to MaineStreet UMS Portal using your UMS credentials (Internet Explorer is the recommended browser)
Navigate to Query Viewer
MaineStreet Menu >Enterprise Applications >Campus Solutions-Reporting DB >Reporting Tools >Query Viewer
- View queries in the University College folder
- Select Folder Name in the "Search By" drop-down list and type in University College (or just the first part of it) after "begins with" and hit Search (see below)
- TIMESAVER: Save the step of navigating to the UC folder by clicking Favorite next to any queries you run frequently.
- Run the query by clicking either the HTML or Excel link
- Use Run to HTML when you wish to view the results in the web page
- Fill in prompts or use look-up list to view possible values
- Click View All if you have more than 100 rows and wish to view them all on one page rather than scrolling through multiple pages
- Use Run to Excel when you wish to download the results into a spreadsheet
- Fill in prompts or use look-up list to view possible values
Excel launches > click Open > click Yes if prompted about file formats
File is read only, so you must save it with a new file name if you wish to edit it
File > Save As > Excel Workbook > Choose file location and file name
Filter/sort in Excel
Click Sort & Filter on the Home tab of the ribbon’s Editing group > click Filter
 |  |
- Click column drop-downs to filter or sort
- e.g. click Location if you wish to see just one location's records or Campus if you wish to see the sections by campus
- Click A-Z to sort ascending by that column or Z-A to sort descending by that column
