Data filtering

SINCE V4.2

Grid View offers flexible data filtering for each column.

Setting up column filter

To apply data filtering to specific column, please select Filters option on it's menu:

To apply the filter, data grid will reload showing only objects that meet selected criteria:

Note that when column contains an active filter, a red "filter" icon will be shown in column header. 

Additionally, a button for disabling all active filters is available on the main grid toolbar. The number in brackets shows how many active filters are present in this tab. 

By using this button, filters will be deactivated, but not removed. They can be re-enabled with column menu. 

Filter Types

Each data type has it's dedicated filtering options

Dictionary lookup field

Dictionary lookup values allow for selection of one or more lookup values, as well as "is empty" or "is not empty" options:

Number field

Numerical columns, like area, have greater-than, smaller-than and equals as well as "is empty" or "is not empty" options:

Text field

Text fields, like Name, have string search field, as well as "is empty" or "is not empty" options:

Date field

Date field have filter settings for Before, After and On date, as well as "is empty" or "is not empty" options:

Boolean (Yes/No) field

Boolean field offers selection between Yes/No values.

Working with filtered data

A filtered data set can be used in various ways. 

Using filtered data as temporary presentation

Using a Highlight function available in the top menu, one can highlight filtered data set on the given drawing. 

The number of highlighted items might not match exactly the number of records in the grid:

• in case not all records have a lined spot entity on the drawing
• in case only some objects are located on the current drawing:

When highlight function is active, a legend panel will present a temporary filter called "selection", with area and items count:

Using filtered data with predefined presentations

When using predefined presentations, an additional filtering can be applied by reducing number of elements used for presentation.

This way a given presentation will be limited to filtered elements.

Let's consider the following example: We will use Floor Type predefined presentation, that normally displays floor type for each space object on the drawing.

First, add filtering to Grid View, where we limit the rooms to Function: Bostad. Use Highlight button to enable filtering in the Viewer as well. Finally select the Floor Type presentation.

As a result, we have a presentation that shows and counts floor types only in rooms with function Bostad:

Printing

Filtering result as well as both ad-hoc and predefined presentations support copy view function and can be printed as well. 

Data Reports

Data reports run from Grid will respect filter settings. 

Filter-bar as alternative option for defining filters in GridView

Alternative way of adding filters to Grid was added, called Filter bar.

It can be activated from Object menu in GRID in main interface.

When it's activated additional row with filters is added to grid that allows to easily manage filters, by selecting desired operator from menu:

When filter is applied it can be removed by selecting context menu on cell with field name and selecting Clear column filter:

or all filters can be removed (along with filter bar) by using Toogle Filter bar button, It can be pressed again to activate filter bar again.