MyWSU - Query Viewer

MyWSU - Query Viewer

Query Viewer Overiew

Navigation

Sign into my.wsu.edu using your okta credentials

Click on the Main Menu Tile

Navigate to Main Menu > Reporting Tools > Query > Query Viewer

Requesting Access to Query Viewer

Visit crimsonservicedesk.wsu.edu and log a ticket to request access to Query Viewer. 

Please include the following information:

 

Search 

Perform a quick search by entering a query name or the partial name of a query and clicking search

 

Results will be displayed below the header:

 

Advanced Search

Click on Advanced Search Hyperlink next to the search button to look up queries based on additional attributes or multiple attributes:

Search on Query Name, a description, Record (or Table Name), a Field Name, a Folder name, Query Type and or an Owner.

Multiple Operators are available for each of the Advanced Criteria:

Query Names usually begin with two characters that represent the functional area:

AA - Academic Advising

AR - Admissions

FA - SFS/Financial Aid

SF - Student Finance

SR - Student Records

WD - Workday 

Descriptions usually contain a brief summary of the query purpose

Uses Record Name is PeopleSoft's name for a table.   

Uses Field Name allows you to search for queries containing a specific field

Folder Name:Please note that folders are usually functional area specific.  Student Finance is SF, Workday is WD, Student Financial Services/Financial Aid is FA, Student Records is SR etc.  

Query Type: The standard for type is User.  

Owner: Owners are either public or private.  Private would be your own queries, personally saved vs Public - a shared query seen and used by the entire WSU community.  

 

Run a Query in Query Viewer

**NOTE: Please allow pop-ups on your browser**

Search for the query you wish to run

Once visible in the list - click on the Excel Link 

If the query doesn't have any prompts, an "Opening ............xlsx" window will pop-up.  

 

Choose to open or save the file.  File names default to the name of the query.  

If the query has prompts:

Run the query of your choice, by clicking on Excel

A new window will open and request the entry of the criteria:

Enter the criteria, and click View Results button:

Choose: Open with Excel or Save radio button

Click OK