Knowledgebase

Search:     Advanced search

Using Microsoft Access to Query TestTrack Projects

Article ID: 380  |  Last updated: 31 Dec, 2014

The following Access example builds a query that returns the number of defects found per date using the Seapine ODBC driver.

Connecting to a data source

  1. Start Microsoft Access and open a Blank Access database.
  2. Enter a database name and click Create.
  3. Choose File > Get External Data > Link Tables.
    By linking tables you get updated data and the ability to use the Seapine ODBC driver. As data is entered into TestTrack, it is automatically updated in the Access database.
  4. Select ODBC Databases from the Files of Type pop-up menu.
  5. Click the Machine Data Source tab.
  6. Select the data source of the TestTrack project you want to link to.
  7. Click Select All and click OK. All the tables are linked to the project that was configured in the data source.

Creating a query

  1. Click the Queries button in the Object group.
  2. Click New.
  3. Select the method you want to use to create the new query and click OK.
    This example uses Design View, SQL method. You do not have to use SQL.
  4. Without adding tables or queries, click Close in the Show Table dialog box.
  5. Click the SQL button on the Query Design toolbar and select SQL view.
  6. Enter the following SQL query to return the number of issues/defects found per date.
    SELECT Count (*) AS Count, rb.datefound AS DateFound
    FROM defects AS d, reportby AS rb
    WHERE d.IDRECORD=rb.iddefrec
    GROUP BY rb.DATEFOUND;
  7. Click Run on the toolbar to run the query.
  8. Click Close. You are prompted to save the query design.
  9. Click Yes to save the query design or click No if you do not want to save the query.

Note: If you want to edit the SQL query, on the View menu select SQL View.

Article ID: 380  |   Last updated: 31 Dec, 2014
Tags
ODBC Access query data source

Prev   Next
ODBC Call Failed Error #1032     TestTrack SMTP Send Mail Error #553