---
title: "Use the Query Builder"
slug: "use-the-query-builder"
updated: 2026-02-23T08:32:14Z
published: 2026-02-23T08:32:14Z
canonical: "documentation.lakesidesoftware.com/use-the-query-builder"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.lakesidesoftware.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Use the Query Builder

The Query Builder lets you select a single reporting view and allows you to choose the columns to be included in the query for a single view. You can also define filters to include only the rows you want in the results.

1. On the **Object** tab of the Query Data block, click the **Query Builder** button.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/query_builder_1.png)
2. Select a view (from the SysTrack SQL database **Available Views** list.
3. Check the columns you want to include in the query and the number of rows to return.

> [!NOTE]
> **NOTE**: It is recommended that you avoid large queries and limit the maximum number of rows to be returned. Clearing the number of rows to be set results in a limit of 10,000 being applied by the system.
4. Click the **Next** button. The **Add Filters** pane displays.

## Defining Filters

To restrict the data to include only the rows you want in the results, use the **Add Filters** pane. For example, you may want to get only the records in which the **%TotalCPU** is greater than or equal to **50**.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/Add_filters.png)

1. To define a filter, click the **Add Test** button.
2. Select a data column from the left drop-down menu.
3. Select a condition from the middle drop-down menu.
4. Select either **fixed value,** or **variable named** from the right drop-down menu. If you selected **variable named**, enter a variable in the **<enter variable>** field. If you selected a fixed value, enter a comparison value.
5. Click the **See Sample Results button** to see the results.

> [!NOTE]
> **NOTE**: The sample results are limited by the system to the top 100 rows.
6. You can add additional Tests or Groups (using the **Add Group** button) to further refine your filter.
7. If you wish to delete a test or group, select the appropriate test or group, and click the **Delete Selected** button.
8. Click **Done** when complete. The SQL query is placed in the **Query** field. The Query Builder creates a SELECT statement, while using filters will create a WHERE clause. The **Query defined by Query Builder** option is checked, and the query text is not editable.
9. If you wish to edit this query and filters, click the **Query Builder** button again.
10. To change the query manually (outside of the Query Builder), deselect the **Query defined by Query Builder** option.

> [!NOTE]
> **NOTE**: If you deselect the "Query defined by Query Builder" option you will no longer be able to make changes to that query using the Query Builder.