Help Center API Docs Roadmap Sign up for free

Queries (QQL, Qase Query Language)

PreviousAnalytics NextQQL structure

Last updated 1 month ago

What are queries in software testing?

Queries help you make analytical requests to get specific data from your Qase projects.

Queries are available in Business and Enterprise subscriptions.

Queries are based on Qase Query Language (QQL). You can access Queries from the top-left menu.

From this page, you can manage saved queries and create new ones.

Saved Queries can be used with the QQL widget.

QQL widget allows you to leverage advanced query searches, and pin frequently used or preferred QQL searches to your dashboards to facilitate quicker and more comprehensive monitoring of testing activities.

Create a new query

You can click on either one of the two buttons to create a new query.

Here, you can: 1. Select the entity from the drop down

2. Write your query

3. Search the query

4. Save the query

5. Choose the fields to be displayed in the table.

QQL Structure

QQL consists of two parts: "Entity" + "Query". Both are required to perform a search.

Here are a few examples:

entity = "defect" and status = "open"

entity = "case" and project = "DEMO" and title ~ "auth" order by id desc

entity = "result" and status = "failed" and timeSpent > 5000 and 
milestone ~ "Sprint 12"

entity = "case" and isFlaky = false and automation = "To be automated"

Entity can be selected from the drop-down, and Projects, by default, include all projects available to a user.

If your expression contains a syntax error, the erroneous element will be highlighted in red, as well as you will see a red "x" icon appearing in the expression field:

Entities

Below are the available entities. Click on an entity to skip to the attributes available for it.

Expressions

Currently, QQL supports seven expression types. They are listed here in the decreasing priority order:

Supported operands:

Data types:

Functions:

Entity fields

Test case:

Defects:

Test run:

Test run results:

Test plan:

Requirement:

Examples of Queries

entity = "case" and isDeleted is true

entity = "case" and created >= now("-3d")

entity = "case" and created <= now("-3d")

entity = "case" and isDeleted is true and project in ["QTC"]

project = "QTC" and automation = "Not automated"

project = "MR" and automation != "Automated"

project = "QTC" and status in ["Draft", "Actual"]

entity = "defect" and status !="Open" and severity = "Not set"

entity = "defect" and status !=1 and severity = 0

entity = "defect" and status !=1 and severity = 0 and cfv in ["1", "2"]

entity = "defect" and status !="Open" and severity != "Not set" and milestone is empty

entity = "defect" and status !="Open" and severity != "Not set" and cf["Defect URL"] is not null

entity = "case" and author != "CEO" and updated <= now("-1d") and isFlaky is false

entity = "case" and author != "CEO" and updated <= now("-1d") and project in ('QA