Basics

Formatting

Context menu

Drag n Drop

Spreadsheet

Tabs

Export (csv, html, pdf, xlsx )

RTL Layout

Layouts

Rows

Paging

Big data

Columns

Cells

Inline editing

Row Grouping

Pivot

Sorting

Filter

Selections

Nesting / Row details

Tree grid

Charts

Angular

React React

Vue Vue

Knockout

;

Filtering effect on display of parent, children and summary nodes

  • Parent nodes: Only those parent nodes are shown which meet the filtering criteria or are parent to children that meet the filtering criteria.

  • Children nodes: By default only those children nodes are shown which meet the filtering criteria. However when treeModel.filterShowChildren is set to true, all the children of parents which meet filtering criteria are also shown.

  • Summary values: By default summary values are recalculated depending upon displayed nodes in relation to filtering state. However when treeModel.filterLockSummary is set to true, summary values of pre-filtered state are retained and are not affected by filtering.

Hidden versus removed nodes

By default when treegrid is filtered, filtered and non-filtered rows are separated and kept in dataModel.data and dataModel.dataUF arrays respectively.

However when filterModel.hideRows is set to true, non-filtered rows are hidden but remain in dataModel.data array at their original positions.

Note for pqGrid Developers

When working with filtering, data should be normalized for numeric and boolean data types to ensure correct behavior.

  • Without normalization, values like "5" (string) and 5 (number) are treated as different, which can cause unexpected results in filtering, sorting, or duplicate-removal logic.
  • Similarly, "true" vs true and "false" vs false should be considered distinct when applying filters.

Recommendation:

Normalize incoming dataset values before they are processed by pqGrid. For example:

  • Convert numeric-like strings to actual numbers
  • Convert "true"/"false" strings to booleans
  • Keep consistent typing across all records

This ensures that filtering and comparison logic works consistently and avoids subtle bugs.