Filtering & Grouping

<< Click to Display Table of Contents >>

Navigation:  PlantDataManager > How to use > PlantDataManager > Data Viewing >

Filtering & Grouping

Previous pageReturn to chapter overviewNext page

Show only changes

With the button "Show only changed objects" you can hide all drawing, classes and records which don't show any changes.

PDM DataViews 43

The result shows only the changes. You can revert this by clicking again "Show all objects".

PDM DataViews 44

Filtering

To filter your project data you can still use the filter function implemented in version 1.79 (22.01.2019).

If you want to filter for a value you simple right-click and use "Filter by Selection".

PDM DataViews 45

This result can be seen here. You also recognize that the value and expression ("=") shows in the Auto Filter Row.

PDM DataViews 46

To remove the filter you select "Remove filter" which removes any filter in your grid in case you filtered in multiple columns.

PDM DataViews 47

You can also filter out a value by using "Filter Excluding Selection".

PDM DataViews 48

In this example, it leaves "TIC" out. In the Auto Filter Row you see the expression "≠ TIC".

PDM DataViews 49

For more filter options you can click on the expression in the Auto Filter Row and select one expression which suits your needs. By default, string fields use "Contains" and numeric fields "Equals".

PDM DataViews 50

You can use for example "Begins with".

PDM DataViews 51

And then type "T" behind it which filters for all records where Type begins with a "T".

PDM DataViews 52

You can filter in additional columns too.

PDM DataViews 53

You can also use the Filter Editor for more complex expressions.

PDM DataViews 54

Here an example where we filter for P1 and P.

PDM DataViews 55

The expression then sets the filter in the Auto Filter Row.

PDM DataViews 56

Besides "And" you can use other expressions and even group expressions by using "(" and ")".

Be aware, that filters are not save when switching between classes.

PDM DataViews 76

Filter set in the Auto Filter Row can be removed through the context menu.

PDM DataViews 57

You can also filter similar to Excel by clicking on the filter icon on the right side of each header.

PDM DataViews 73

The filter will be executed right away.

PDM DataViews 74

If the list of values is long, you can also filter the available values.

PDM DataViews 75

Finally, you can filter by typing in a value in the auto filter box. It will instantly filter for the value you typed in.

PDM DataViews 77

Grouping

To group your data you can make a right-click on the header you want to group and select "Group By This Column".

PDM DataViews 58

Alternatively, you can drag and drop the header into the Group By Box at the top.

PDM DataViews 59

The result looks like this.

PDM DataViews 60

You can then expand the individual groups.

PDM DataViews 61

You can also use "Full Expand" in the Group By Box.

PDM DataViews 62

Which then expands every group.

PDM DataViews 63

Or collapse everything again.

PDM DataViews 64

Which looks like this.

PDM DataViews 65

You can remove any grouping with "Clear Grouping".

PDM DataViews 66

The result is then ungrouped.

PDM DataViews 67

You can also group for multiple columns. Just drag and drop another column header into the Group By Box.

PDM DataViews 68

Which then shows you the group in the group in a tree like fashion.

PDM DataViews 69

To remove one of the grouped columns you can select "Ungroup" from the context menu of the header in the Group By Box.

PDM DataViews 70

Or you drag and drop the header back to the other headers.

PDM DataViews 71

With now all group header removed we have the original layout again.

PDM DataViews 72

Next Chapter: Data Editing