How to sort and filter data in Master-Detail Browser

In Master-Detail Browser, you can sort and filter data retrieved from the master and detail tables in the document Data view.

Note

When saving a master-detail document, sorting and filtering conditions are not kept.

Sorting data

Data can be sorted in master and detail tables.

To sort data by a particular column, click the column header. Clicking the cell removes sorting from all other columns, sets sorting order to ascending if it has not been set before, or changes the sorting direction.

To assign secondary sorting, click another column header while holding down the Shift key. You can set any number of sorting columns. To stop sorting on a certain column, click it by holding the Ctrl key.

Ascending sorting in the column: Indicates ascending sorting in the column.

Descending sorting in the column: Indicates descending sorting in the column.

No arrows indicate that no sorting is applied to the column.

Sorting

Filtering data

Data can be filtered in master and detail tables.

To apply filtering to a column, click Filter icon on the header of a column that you want to apply filtering to and select the filter from the drop-down list.

You can set a custom filter. To do so, select (Custom) from the drop-down list. In the Custom AutoFilter dialog that opens, specify filtering properties and click OK.

Custom filter

The result is as follows:

filter result

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Query Builder for SQL Server.
Request a demo

Request a demo

If you consider employing the Query Builder for your business, request a demo to see it in action.
Ready to start using dbForge Query Builder for SQL Server?