Viewing and Extracting Queries

Business Process

USING THE QUERY VIEWER

Module

CURRICULUM MANAGEMENT

BP ID

Prerequisites

Description

This Job Aid will go over the process on how to use Query Viewer after classes are scheduled.

Click on  and  navigate to:

Campus Solutions > Reporting Tools > Query > Query Viewer

Open

*Search By defaults to Query Name.

In begins with field, enter query name. Example: X_CM_CLASSES_SCHED

Click Search button.

Open

Search results will display below. Select the query you want to view.

To view the query results, click the Excel link under Run to Excel Column.

Note: Make sure to disable pop-up blockers on your web browser.

Enter your search criteria into the fields:

a. Enter required Term (i.e. 2195 for Summer 2019; 2197 for Fall 2019; etc.)

To narrow down your search criteria, enter the following:

b. Enter Offer Nbr (1 for City; 2 for Mesa; 3 for Miramar; 4 for CE)

c. Enter an Academic Org if you want to also constraint the query by Department.

Note: All Academic Units have been setup as Academic Organizations; you cannot extract class schedule data for an entire school. To extract class schedule data for your school, enter only Term and Offer Nbr. You can add filters to your Excel file to filter all data for your school. 

Click View Results button.

An Excel spread sheet of your search criteria will pop up. Determine if you want to Open and/or Save the Excel results at this point.

Note:  Click Enable Editing if you need to manipulate the query file.

End of process.