People have often asked for enhanced reporting, data querying, and export capabilities in QATrack+. Today, I'm very excited to announce a new powerful tool to allow users to write SQL queries to search, summarize, chart, and analyze data in their QATrack+ databases. This tool is available now to MLC hosted customers and will be released generally in v0.3.1 which should be out sometime next year.

The new Query Tool makes it possible to answer such questions as:

How many times have I completed our monthly QA test lists?

How long does our morning QA take on average?

What is the test that fails most frequently on a specific unit?

Some of the features included with the query tool include:

A "Playground" for testing and running one off queries

Save queries for later use so they can be run by you or others

Parameterize your saved queries so they can easily be customized by people who don't know SQL

Export your query data to CSV, Excel or JSON

Analyze and summarize your data using built in pivot tables

Generate charts (line, scatter, bar etc) from your data

Link directly to your query or pivot table to share your analysis with colleagues

Database schema view to aid in constructing queries

I'll be adding some examples of using the query tool to this blog in the future but for now check out some screenshots below. I'm looking forward to seeing what uses people come up with for this tool!

Fig 1 A query calculting duration for performing test lists showing the query results

Fig 2. A parameterized query

Fig 3 Same query as Fig 2 showing results as a bar chart

Fig 4 Same query as figure 2 but showing a pivot table with the median duration of each test list instance

Fig 5. A query showing distributions of test values