BimSens allows you to Search and Filter the data in the grid in multiple ways:

  • By typing a a value to search in the Quick Search bar
  • By selecting values in the one or several Column Filter
  • By defining Custom Filter for one or several columns
  • From Cross Filters triggered by the Relations in the Data Model
  • Finally filtering conditions are automatically added when you select items in the viewer or change the viewpoint and the 3D Trigger is active.


 LOST ROWS?


The visible rows on the grid are the one respecting the Search criteria, all Columns & Custom Filters AND the 3D Trigger filters. If some records are not showing, you might need to reset the filters. Click the  Reset Filters button to reset all filters.

It is recommended that you keep the Filter Banner active so that you can see which filters are active at any given time, and clear them selectively.

The Filter Banner

The Filter Banner is a banner that is displayed below the Data Panel, showing a card for each active filter affecting the data currently displayed. It gives a clear understanding of which filters are active, and allows you to turn them off selectively by closing the corresponding card.

If you cannot see the Filter Banner, you may need to activate it from  Home >  Options > Filters

From the Options dialogue you can further customise the appearance of the Filter Banner, including colours and optional cards to display.

Quick Search

The  Quick Search box is located in the top toolbar, it allows you to search a value within all cells in the grid.

If the automatic search is activated, the filtering will start as you type, to only show rows with at least one cell with a match. Otherwise you'll need to press the Enter key or click the Search button again to validate your search criteria. The automatic search can be turned on and off from the menu  Home >  Options > Filters


 TEXT SEARCH (NOT STRONG TYPES)


The search is performed on the text representation of the cell value. Numeric or date values can have a different text representation for the search engine than that displayed on the screen, and some search value may not work with these types.


 RELATIONS DEACTIVATED DURING Board search


The Data Model Relations are deactivated while you use the Search filter, so that it can return the matches in all tables without conflicting with cross filters. The relations are reactivated once the Search is cleared.

Column Filters

Column Filters allow you to filter values displayed in each column. To open the Column Filters right click the column header and un-check the values to exclude in the tree. You can use the Select All button to toggle the check state of all nodes at once.

The button Clear Column Filters resets both the Column Filter and Custom Filters for the column to show all values.

Custom Filters

Custom Filters allow you to filter numeric or date values of a column using operators such as =, >, <. To open the Custom Filters right click the column header and click Custom Filters.

In the Custom Filters dialogue, select an operator and a value to compare to. You can select a value from the list of values currently found in the DataView or type your own. You can add an additional filtering criteria by selecting a value for the second row and choosing whether both conditions need to apply (And) or either condition is sufficient (Or).


 DUH!


To find values that falls between 2 reference values, use a combination of filters GreaterThan and LessThan with the And operator.