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