Filtering Grid Views

<< Click to Display Table of Contents >>

Navigation:  Import and Export >

Filtering Grid Views

Right Clicking on a grid column header and selecting "Filter <selected column>" will open the column filter condition form, with the condition applying to the selected column chosen.  All columns can be filtered on except for columns showing part/plate images and node expansion columns. In cases where the table is a tree with subnodes, the filtering is only applied to the top layer of nodes.

 

Filtered Column

A table filtered on Part Name

 

 

multipleCriteriaFilterGrid

1.The section to the left of the first filter dropdown can be used to reposition the filter list.

2.You can add brackets when there are multiple conditions, by selecting the '(' button that appears when you mouse over next to the column name, and then ')' after the last condition you want to be included in the brackets. Closing brackets on the same criteria that opened them cancels out the brackets.

3.The column of the table can be chosen from the first dropdown box. Depending on the column type the criteria boxes will change between text, multichoice, numerical or date range match options. Sometimes a column has multiple options for filtering, if implemented for that table.

4.The clause of the condition - what is available depends on the column type.

5.The text or number or date value of the condition.

6.The ')' closing bracket button will appear on mouse over after the conditions that are inside a set of brackets for moving the closing bracket earlier (the closing bracket is by default added to the end).

7.The + button adds a criteria below the one selected. As more criteria are added, you can use AND and OR operators to combine them together in different ways.

8.The - button removes the criteria in that row.

9.Select AND and OR to change how the conditions are combined in calculating if a row is filtered.

 

The filter is applied by clicking away from the form, or pressing Enter or Escape with the criteria added. Filters with no text in their edit box are automatically removed.

 

The query can be more complex, for example finding parts with 'Beveling' in the name with either a width<=140mm OR height <=140mm can be achieved as shown:

VirtualTreeMultiFilter

Filtering tables on multiple criteria

Note that if you export the grid view (Exporting Grid Views) the table won't be filtered in the exported format.