OGE logoOGE

Filtering

All four filtering surfaces on one grid: type in the filter row (click the operator button to switch Contains → Starts with → …), open a header filter and search inside its values, use the global search (matches are highlighted), or click the filter panel at the top to open the Filter Builder for arbitrary and/or trees.

filterRow headerFilter searchPanel filterPanel filterValue
2.000 rows all filter surfaces
No commands to display
Id
First Name
Last Name
Department
City
Salary
Hire Date
1
Can
Yılmaz
HR
Bursa
71000
2021-10-07
2
Deniz
Doğan
Engineering
İzmir
57000
2024-03-22
3
Deniz
Demir
Engineering
Bursa
48000
2023-04-22
4
Selin
Demir
Engineering
Antalya
58000
2017-02-14
5
Zeynep
Demir
Support
Bursa
109000
2019-12-08
6
Ayşe
Doğan
HR
Ankara
100000
2020-10-19
7
Zeynep
Şahin
Support
Ankara
45000
2021-01-27
8
Ali
Şahin
Finance
Ankara
89000
2023-04-28
9
Elif
Demir
Support
İstanbul
96000
2015-01-21
10
Mert
Aydın
HR
Antalya
93000
2024-04-15
11
Elif
Kaya
Sales
Bursa
42000
2020-02-09
12
Can
Çelik
Engineering
Ankara
116000
2015-04-23
2000 rows

Excel-style filter menu

headerFilter.mode picks what the funnel opens: 'list' (the default value checklist with search and select-all), 'conditions' (two operator + value conditions joined by And / Or) or 'both'. Date columns list their values as a collapsible year → month → day tree. The conditions are stored as a filter expression, so they persist with stateKey.

headerFilter.mode date tree
First Name
Salary
Hired
Ali
61000
5/2/2020
Deniz
62000
11/19/2020
Can
39000
8/4/2020
Zeynep
112000
5/3/2022
Zeynep
77000
9/7/2018
Ayşe
40000
3/12/2015
Ayşe
98000
10/5/2016
Deniz
92000
5/2/2016
80 rows

Notes

  • Open the Hire Date header filter: date values are grouped into a year tree — the year checkbox toggles all its dates at once and the search box matches years or single dates.
  • Every surface produces the same serializable FilterExpr tree — combined with AND and sent to your backend unchanged in remote mode.
  • The operator button in each filter cell offers dataType-appropriate operators; Reset returns to the column default.
  • [(filterValue)] is two-way: set it programmatically, read what the builder produced, persist it — it also participates in stateKey.
  • Search highlighting only touches default cells; custom *ogeCellTemplate content is never rewritten.