Adding filter in Janus Gridex

Question

I am using a Janus GridEX with multiple columns. I want to apply filter in gridex data based upon input value for a particular column in GridEX . I am trying to add an extra row at the top where i can input filter condition in a textbox for a particular column. I want to keep only the filter cells as editable while keeping rest of GridEX non editable. If it is non possible, then can I use FilterEditor to implement the same.?

score 3 · Answer 1 · edited Jun 26 '18 at 15:31

3

GridEXFilterCondition filter = new GridEXFilterCondition(GridName.RootTable.Columns["ColumnName"], ConditionOperator.Contains, TextBoxName.Text);
GridName.RootTable.FilterCondition = filter;

edited Jun 26 '18 at 15:31

shim

9,289
12
69
108

answered Jun 26 '18 at 12:22

Daniel Roberto

41
5

2

Please add some explanations to your answer. – Joao Vitorino Jun 26 '18 at 12:27

score 1 · Answer 2 · edited Oct 30 '17 at 11:53

1

Dynamic filtering is already available in GridEx. To enable it, just set these properties below:

In GridEx properties:

Dynamic Filtering = true
FilterMode = Automatic
FilterRowUpdateMode = WhenValueChanges

In RootTable properties:

Dynamic Filtering = true

In each column's properties, you can set the FilterEditType and FilterRowComparison as you like.

edited Oct 30 '17 at 11:53

Adil B

14,635
11
60
78

answered Oct 30 '17 at 11:17

Makesh

335
4
15

How to keep retain filter after reload using filtergrid – RSB Apr 30 '20 at 14:01
Can you please tell how can we retain filters after refresh. – RSB Jun 05 '20 at 08:52

score 1 · Answer 3 · edited May 06 '20 at 00:29

You can Add Multi Condition With (Or-And)

this is an Example :

GridEXFilterCondition filter=
new GridEXFilterCondition(YourJanusGridName.RootTable.Columns["YourColumnName"], ConditionOperator.Contains, sgTextBox3.Text);

filter.AddCondition(**LogicalOperator.Or**, new GridEXFilterCondition(YourJanusGridName.RootTable.Columns["YourColumnName"], ConditionOperator.Contains, sgTextBox3.Text));

filter.AddCondition(LogicalOperator.Or,new GridEXFilterCondition(YourJanusGridName.RootTable.Columns["YourColumnName"], ConditionOperator.Contains, sgTextBox3.Text));


YourJanusGridName.RootTable.FilterCondition = filter;

Its help me to do My Work Item

Hadi · Answer 4 · 2016-11-06T20:18:52.193

0

Click on the GridEx control and in the properties window set the following properties

FilterMode = Automatic

FilterRowButtonStyle = ConditionOperatorDropDown

edited Nov 06 '16 at 20:18

answered Oct 23 '16 at 15:52

Hadi

36,233
13
65
124

Adding filter in Janus Gridex

4 Answers4