ASPxGridView's Cool New Feature: Header Filter

22 May 2008

A cool new feature was recently added to the ASPxGridView in the 2008 volume 1 release. 'Header Filter' is an alternative to the standard filter toolbar. Column headers can be displayed as filter drop-down buttons. By clicking a filter dropdown, the header filter lists the unique values within a column and enables you filter the column. Check out this live demo to test drive this feature:

image

By default, the filter buttons are hidden. To show the filter buttons, just set the Settings.ShowHeaderFilterButton property to true. You can also change text for the '(All)' item above with the SettingsText.HeaderFilterShowAll property.

In certain scenarios, the header filter can be more useful to you. Drop me a line below and let me know if you use this feature and/or which filter type you prefer to use.

22 comment(s)
David Milan

This is a useful feature.  If the user could select a column from a Header Filter and then do intelliSense to jump down that list, it would be even better.  :)

23 May, 2008
Pavel Romero

For our company it's a great feature. It would be good to allow multiple selection and value rank customized (for example a start date and end date).

27 May, 2008
ASPxGridView's Cool New Feature: Header Filter

Pingback from  ASPxGridView's Cool New Feature: Header Filter

7 June, 2008
Shivani

We are using Header filter in our project. I have seen on strange behaviour of the filter dropdowns. Sometimes it shows Scrollbar in the Header filter and sometime it does not. I tried to look for a setting which make the filter scrollable or non-scrollable but did not find any. Can you please help me with this. How to make the Hearder Filter Dropdwons scrollable.

Thanks

10 June, 2008
Mehul Harry (DevExpress)

Hello Shivani,

The dropdowns in the header filter area are resizeable. So if the dropdown size is increased then the scrollbars will disappear and conversely, they'll reappear if the size is decreased. You can see it in the demo here: http://tinyurl.com/5tpt3p

10 June, 2008
ANDREA ZIGLER

Hello Mehul,

I am not agree with you. I have see it oractically happening, I can send you sample for this. in the grid its not showing scroll bar until I move  the filter window. and if i resize the filter window litle then it start showing scroll bar and that size of the popup is replicated to the other columns.

i can not expain it in words i will send you a sample for this.

Thanks

19 June, 2008
ANDREA ZIGLER

Hi Mehul,

I have reported this bug now in the devx support and attached a sample where you can reproduce this issue.

please check this ticket "B95360"

thanks

19 June, 2008
Mehul Harry (DevExpress)

Hi Andrea,

I spoke with the support team and they're looking into the issue. I believe they did some unusual behavior. I recommend using the support ticket for tracking  and communication. Thanks.

20 June, 2008
John Bierman

I was wondering if there is the ability to multi select in the Header filter drop down.  So far I have not been able to find anything on that.  

16 July, 2008
Mehul Harry (DevExpress)

Hi John,

Sorry but this feature isn't available yet. Track the suggestion below to upvote it and get notified when it gets implemented: www.devexpress.com/.../S19281.aspx

21 July, 2008
neil

Hello,

I'm looking for a solution to autofilter for datetime "less or equal" or "greater than" the given filter value. This seems not to work, or do I miss something? Using AxGridview, asp.net, 3.5, german.

BTW: How to localize the grid?

1 August, 2008
Mehul Harry (DevExpress)

Hi Neil,

For the filter, we're planning to implement a new control - ASPxFilterControl, which will allow the end-user to specify a filter condition of any complexity. You can track this suggestion here:

www.devexpress.com/.../S18365.aspx

There is a sample here as well:

http://www.devexpress.com/Support/Center/p/Q30697.aspx

For the localization, this information is available in our documentation at:

www.devexpress.com/Help

4 August, 2008
Rick

What version of the ASPxGridView is the Header Filter available?  I have version 7.3.9.0 and I cannot find how to make this work.  I have set AllowAutoFilter to true for the columns that I want to filter on, but I cannot see how to get the dropdowns.

Thanks for you help.

20 October, 2008
Mehul Harry (DevExpress)

Rick, The header filter feature was introduced in the 2008 volume 1 (v8.1.x). I recommend upgrading to the latest version.

20 October, 2008
praveen

Hi Mehul,

I am using GridViewDataDateColumn in my aspx i am keeping ShowHeaderFilterButton ="true". This header filter is not filtering data for Date Column, does it? if no, how can filter for DateColumn list data.? am i missing anything?

Regards,

Praveen

18 February, 2009
Mehul Harry (DevExpress)

Hi Praveen,

For custom date filtering, use the new filter control which gives you much more flexibility for filtering:

community.devexpress.com/.../asp-net-data-filter-control.aspx

18 February, 2009
wiyono

nice

14 January, 2010
Viren Shah

Hi Mehul,

         Could you plz tell me which grid events are fired when you select a filter option from the column filter?

19 August, 2010
Viren Shah

just elaborating some more about my query, i need to know the value of the selection from the header filter of one devex grid and apply the same filter to another devex grid to filter rows in it.

19 August, 2010
Mehul Harry (DevExpress)

@Viren,

You can use the FilterExpression property and ApplyFilter method:

documentation.devexpress.com

19 August, 2010
Manishs Singh

Hi Mehul,

I need to implement casecadding features in header filter row.

for ex: on selecting country, should filter the state dropdown for the respective country.

Thanks

Manish

29 March, 2013
Mehul Harry (DevExpress)

Manish,

Use the header template and then try the approach that is used here:

demos.devexpress.com/.../CascadingComboBoxes.aspx

If that doesn't help then please contact our support team:

www.devexpress.com/.../CreateIssue.aspx

Thanks.

29 March, 2013

Please login or register to post comments.