Search Google Appliance

Information Technology

Article Details

Use the Query Viewer

We're taking you to an updated version of this article.

UMass Amherst Information Technology support articles are now updated in the new IT Knowledge Base. We found an updated version of this article, so we're sending you there.

Taking you to:

umass.service-now.com/sp
Redirecting in
10s

Stay here to view this page in the legacy Support Center.
Information may be outdated as these articles are no longer maintained.

Find answers to your tech questions in the new IT Knowledge Base.

UMass Amherst Information Technology support articles are now updated in the new IT Knowledge Base.

This article is part of our archived legacy Support Center and may be outdated or inaccurate.
We did not find an updated version of this article. That means this archived content is more likely to be outdated or no longer relevant.
Check the new IT Knowledge Base for updated information:

More tech help options

Introduction

The Query Viewer allows SPIRE users to run pre-built queries, view results online, and download data to Excel.

The student information you obtain by running queries falls under the FERPA (Family Educational Rights & Privacy Act) guidelines. It is your responsibility to maintain the confidentiality of this information and protect it against accidental release.

A list of queries is available on the SPIRE for Staff Query Directory page.

To access the Query Viewer, logon to SPIRE and navigate to Main Menu > Reporting Tools > Query > Query Viewer

Find & Run a Query

You can search for queries available for you to run on the Query Viewer page.

  • In Search By, select "Query Name" (if not already selected).
  • In the begins with field, you can enter the full name of query, such as UR89_DEPT_MJRS_SHORTLIST, or you can enter just the first characters of a query name and all matching queries will be returned.
  • Enter UR89_DEPT in the begins with field to see all the undergraduate queries available to you.
  • Click Search Button 

Query Page

Once the query you want is displayed click ‘HTML’ or ‘Excel’ to download results. Choose ‘Excel’ if you want to be able to sort/filter your query results.

Majors List Data Dump Query

Some queries require you to enter a term code. Enter the 4-digit code in the Current Term field or click the magnifying glass to display all available term codes.

Query Term Lookup

Click the View Results button for the Query

Data will download to Excel or HTML. Remember to protect any FERPA data.

Note: Some subject queries (ex: UR89_DEPT_CLASS_BY_SUBJECT) require you to enter a Subject Abbreviation Code. A list of subject codes can be found here:  https://www.umass.edu/it/sites/it/files/2015/06/12/subject-codes_1.pdf

  • You must allow browser pop-ups for SPIRE before you can run queries.  For instructions on how to allow pop-ups for SPIRE, consult your browser's help feature and search using the phrase "allow pop-ups for a Web site."