Faculty and Staff

How to Retrieve Data Using QueryLink

Last updated August 26, 2009 8:43:26 AM PDT
Give more feedback

Follow this guide to learn about QueryLink, a Web-based tool that allows authorized staff toretrieve data from UCSD's Data Warehouse without knowing a programming language.

The available data includes financial, student, and payroll/ personnel information.

This is a brief overview. The online PowerPoint tutorial describes how to use QueryLink inmore detail. QueryLink classes demonstrate the basics and focuson specific databases.

Notes:
1) Click on the button next to each query for a full explanation of its features and functional purpose.
2) Some fields are required, some are selected by default, and some require you to enter your specific criteria.
3) Remember that QueryLink opens pop-up windows, so you should close the window when you move on.

Expand all

1. Select a query model that matches your interest.

2. Start the query.

  • Click the query title.
  • Enter your login and password.

3. Take a tour of the query.

Some fields require more qualification.

  • Click all the tabs at the top, moving from left to right.
  • Review the fields that each page offers.
  • Click on the name of the field to read a description.
  • Look through the drop-down lists that many fields offer.

4. Decide how you want the information presented.

  • Click the drop-down lists at the bottom of each page to see the options. Choosing some of these options will open another window requesting your input.
  • Note that in the Query Option: Set Results Row Count, the default retrieves 2000 rows of data.

5. Run a preliminary query.

  • Enter values in the appropriate fields on all the pages.
  • Check the boxes for the fields you'd like to display returned information.
  • Leave the default row count at 2000 for this test.
  • Click Submit.
  • Use this preliminary query to be sure that you're getting what you want.
  • Close the preliminary window.

6. Run your query.

  • Enter all the necessary information.
  • Enter the row count that you need. (Enter "0" for an infinite number)
  • Click Submit.

Expand all

For more information, contact the Data Warehouse Team.