You can use Query Builder to filter your compatibility-issue data or reports by selecting specific restriction criteria.

The following table shows the columns in Query Builder.

Column Description

And/Or

If you select And, your data must match all query rows to appear as a returned result.

If you select Or, your data can match any query row to appear as a returned result.

Field

Select filter criteria.

Operator

Select an operator. The available operators depend on the field that you choose.

Value

Type or select a value.

Creating Basic Queries

You can insert as many query clauses as you want to create a customized view of your compatibility data.

Note
The following examples use the <Operating_System> - Application Report screen. The process is the same for other report types.

To create a basic query

  1. On the <Operating_System> - Application Report screen, click Toggle Filter.

  2. In the Query Builder, enter your filter criteria, pressing the Tab key to add clauses.

    To delete a clause, right-click the row, and then click Delete Clause.

  3. Click Refresh.

    Your filtered results appear. To close the Query Builder, click Toggle Filter again.

Querying on Objects

You can query your compatibility data based on its relationship with other objects. For example, in the applications report, you can query for applications that have corresponding issues. Fields that have a (+) suffix in Query Builder are collections of objects.

To query for a collection of objects

  1. In Query Builder, in the Field column, click any field that contains a plus sign (+) as suffix.

  2. In the Operator column, select Exists, Not Exists, or All Have.

    Query Builder creates a group clause, which is shown by a bracket that spans the rows that are included in the group.

  3. Move your cursor to the next row in the group clause, and then in the Field column, select a field.

  4. In the Operator column, select an operator.

  5. In the Value column, enter a value, and then click Refresh.

See Also