How to run a Query

Owned by Victor DeVore
Last updated: Aug 04, 2021
2 min read

This goes over the process to run a generic Query.

Instructions

Users must have access to run query viewer.

  1. On Campus Solutions, click on Navigator

  2. Go to Campus Solutions → Reporting Tools → Query → Query Viewer

  3. Type in the query name in the search field below (1)

  4. Then click on search, you should see the query pop up that you’re looking for. 

  5. Click on “HTML” to run it. Be sure to click on “Favorites” to save it to your favorites so you don’t have to search for it each time.

  6. Depending on the query, some may ask for prompts in order to pull the specific information you’re looking for. Common prompts include:

    1. Career

      UGRD = Undergarduate (City, Mesa, Miramar) CE = College of Continuing Education CEHS = College of Continuing Education High School

       

    2. Term

      2217 = Fall 2021 2223 = Spring 2022 2225 = Summer 2022

       

    3. Campus

      CITY = City College MESA = Mesa College MIRA = Miramar College ECC = Educational Cultural Complex WESTC = West City CCHAV = Cesar Chavez MCITY = Mid City NCCTR = North City / CE (Mesa/Miramar)

       

  7. Click on “View Results” to run the query.

  8. To download the results, you can click on “Excel SpreadSheet” to download your results.