Query Builder delivers multiple ways to hide columns and filter data in the grid. Both column-level and row-level filtering are available.
Query Builder offers several ways of hiding columns:
You can remove the required columns from your SELECT statement. For instance, let’s remove LoginID, OrganizationNode, and OrganizationLevel from the following query:
SELECT BusinessEntityID, NationalIDNumber, LoginID, OrganizationNode, OrganizationLevel, JobTitle, BirthDate, MaritalStatus, Gender, HireDate FROM AdventureWorks2019.HumanResources.Employee
Thus our query becomes as follows:
SELECT BusinessEntityID, NationalIDNumber, JobTitle, BirthDate, MaritalStatus, Gender, HireDate FROM AdventureWorks2019.HumanResources.Employee
Then we click Execute to get the results.
Right-click a column header and select Visible Columns on the shortcut menu to open the Visible Columns dialog. Clear the checkboxes next to the columns you want to hide from the grid and click OK.
Click Remove from output on the Selection tab.
Clear the checkboxes next to the required columns on the Query Builder diagram.
Learn more about building queries on diagrams in Working with diagrams.
You can combine the abovementioned hiding methods.
Query Builder offers several ways of filtering data:
You can add a WHERE condition to your query to filter data. For instance:
SELECT BusinessEntityID, NationalIDNumber, LoginID, OrganizationNode, OrganizationLevel, JobTitle, BirthDate, MaritalStatus, Gender, HireDate FROM AdventureWorks2019.HumanResources.Employee WHERE OrganizationLevel < 3
If we execute this query, we will get the following results:
On the Selection tab, enter the filter condition for the required column in the Where field. When the row-level filtering is applied, a corresponding icon will appear on the diagram.
Alternatively, enter the filter condition on the Where tab. Similarly, a corresponding icon will appear on the diagram.
Click the Filter button located in the upper right corner of the required column header.
Select Quick Filter on the shortcut menu. Then select one of the predefined options or select Condition to open the Filter Editor and customize your condition.
Data sorting and filtering can be performed either on the client or on the server side. To learn more about it, refer to Server-side and client-side sorting and filtering.