Filtering Your Compatibility Data
Applies To: Windows 7, Windows 8, Windows 8.1, Windows Vista
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
On the <Operating_System> - Application Report screen, click Toggle Filter.
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.
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
In Query Builder, in the Field column, click any field that contains a plus sign (+) as suffix.
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.
Move your cursor to the next row in the group clause, and then in the Field column, select a field.
In the Operator column, select an operator.
In the Value column, enter a value, and then click Refresh.