/
How to run a Query

How to run a Query

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.

Related articles

Related content

How to run the Honors Dashboard Query
How to run the Honors Dashboard Query
More like this
Viewing and Extracting Queries
Viewing and Extracting Queries
More like this
X_SR_MIS_STDNT_ATTR_WBL_SG21 and X_SR_MIS_WBL_SG21
X_SR_MIS_STDNT_ATTR_WBL_SG21 and X_SR_MIS_WBL_SG21
More like this
X_SR_MIS_WBL_SG21_DISTINCT
X_SR_MIS_WBL_SG21_DISTINCT
More like this
X_SR_WBL_SG21_CLASS_ATTRIBUTES
X_SR_WBL_SG21_CLASS_ATTRIBUTES
More like this
X_SR_MIS_WBL_SG21_CE
X_SR_MIS_WBL_SG21_CE
More like this