Blogs

Mehul Harry's DevExpress Blog

Introducing the Filter Control For ASP.NET

     

In the next major release of DXperience and ASPxGridView & Editors Library is a new filter control for ASP.NET. The ASPxFilterControl brings you advanced filter and criteria options for the ASPxGridView. Check out the new ASPx FilterControl video below that shows:

  • Where the idea for ASPx FilterControl came from
  • How to enable the new Filter Bar within the ASPxGridView
  • How the end-user can create/modify/delete filters
  • How to set filters at runtime

image

ASPxGridView Filter Control

So check out the new ASPx FilterControl introduction video and let me know how you plan to use the filter control in your ASPxGridView.

Comments

 

Steven Rasmussen said:

This is a great step forward for the AspxGridView and will work really well as a basic filter builder.  There are still some major aspects that could be improved to both the winforms version and this version of the Filter Control that could make it un-beatable.  See suggestion S20272 for suggestions.  

Anyway, great work.

October 15, 2008 1:20 AM
 

Mehul Harry (DevExpress) said:

Hi Steve,

Thanks and yes, you'll love this new filter control. Btw, it looks like your suggestion has been accepted. Smile

October 15, 2008 2:23 PM
 

Steven Rasmussen said:

Accepted yes :)  But I'm not very hopeful that it will get implemented anytime soon...  it's been accepted for over a year now.  Oh well :(  maybe one day....

October 15, 2008 2:37 PM
 

James Foye said:

This looks great, thanks!

October 15, 2008 4:26 PM
 

Andrew (DevExpress) said:

Hi Steven,

Regarding your issue:  www.devexpress.com/issue=S20272.

We will definitely implement this feature one day. Roman (our XAF architect) constantly tells me that a database scheme is not flat, it is a tree. However, we deal with root nodes only.

Several weeks ago, when Roman came to our room to talk about integrating ASP.NET filter control into XAF, he started yelling at us. He was disappointed because to introduce the filter control, his guys have  to implement a couple of interfaces (IWebFilter…). The problem is simple; the filter control needs to get properties and their types (or editor types) to build criteria. There is nothing wrong from our point of view, the guys who wrote ASP.NET filter control. However, from XAF guys’ point of view, they have to introduce some more damn interfaces. Is it a big deal? Nope, but they already did a similar thing for WinForms filter control, Winforms and ASP.NET field customization window. There are several other places where they have to work with different API that does the same. It will make mad any agile development and it is hard to disagree with Roman.

A good solution is to introduce these interfaces into our core dll and use them through our entire control library. And of course, this API should support the tree structure.

I hope we will do it rather sooner than later. Although our management understands that changing our code will not introduce more features and, as a result, will not make our customers feel better. They respect these types of changes.  Because they understand that it will keep our code clean and as a result we will introduce new features faster and our customers will report less issues, the product line will be more solid.

PS: I have to say that we are fighting against refactoring that doesn’t give us any reasonable benefits. However, this situation is not a case.

October 16, 2008 3:05 AM
 

Ben Staton said:

Looks good. When can we get it? When is 2008.3 due?

October 16, 2008 4:29 AM
 

Peter O said:

Looks really nice. We are using the Winforms control allready and waiting for this control. Can you give an date on when it's available?

October 16, 2008 9:35 AM
 

Mehul Harry (DevExpress) said:

Hi Ben/Peter,

We're aiming for early November.

October 16, 2008 2:11 PM
 

Steven Rasmussen said:

Andrew,

I appreciate the insight.  It is nice to know that it is at least being talked about internally.  I can understand the debate and agree that the code should be centrally located.  Anyway, thanks for the post!

October 17, 2008 10:36 AM
 

The ASPx Blog said:

The next major release of DXperience and the ASPxGridView & Editors Library includes new controls

October 24, 2008 9:33 PM
 

The ASPx Blog said:

[Post Updated: Sunday, October 26th, 2008] The next major release of DXperience and the ASPxGridView

October 26, 2008 6:46 PM
 

SSICT BAS said:

Awesome control, thank you, is there any suggestions which could allow as a part of the filter control to specify how particular column should be sorted, sometimes this is not very optimal to sort asc and then descending, would be really cool to have possibility to specify sort type or filtering or both together, what do you think?

I think that suggestion S20272 is a not a good idea to implement for ASP.NET.

October 27, 2008 11:33 PM
 

Chan Kok Kiet said:

Hi,

The control is cool. I would like to know, whether the below supported?

1. Is it possible to use it independently (outside of GridView)?

2. I would like to allow user to specify filter expression and save it somewhere. Then user can re-use it.

3. Able to filter any GridView supported data source.

4. Generate filter expression for C#, SQL, Javascript

Thank you

October 31, 2008 6:01 AM
 

Mehul Harry (DevExpress) said:

Hi Chan,

Thanks,

1. Yes.

2. Yes, I believe this is possible. Wait for the beta and you can try it very soon.

3. Not sure if this is possible because of the filter expression that is generated may need to be adapted for the particular control you're using. Our goal was not to support any gridview product.

4. No, it generates filter expressions on the server side which you can read through callbacks or save to the database if you wanted to. Although, your idea isn't bad. After trying the beta, you may want to create a suggestion.

Thanks again!

October 31, 2008 4:48 PM
 

The ASPx Blog - Mehul Harry's DevExpress Blog said:

The DXperience 2008 Volume 3 release is now available for download. Included with it is the new ASP.NET

December 2, 2008 2:02 PM
 

The ASPx Blog - Mehul Harry's DevExpress Blog said:

The DXperience 2008 Volume 3 release is now available for download. Included with it is the new ASP.NET

December 2, 2008 2:03 PM
 

Bruno Conti said:

Hi Said

I want to save details of layout and data a ASPxGridView in a file  XML. This is possible, how?

If possible, how do I load the information?

Thank you,

Bruno

January 30, 2009 2:03 PM
 

Rossi said:

Hi,

How do I change text of FilterControl operators ("Equals" => "="; "Not Equals" => "!=" ..) ?

Thanks,

Rossi

June 12, 2009 4:52 AM
 

Mehul Harry (DevExpress) said:

Hi Rossi,

You can change localization to change those strings: devexpress.com/issue=Q139054

This file specifically:

DevExpress_Web_ASPxEditors_v9_1.resx

<data name="ASPxEditorsStringId.FilterControl_ClauseType">

<value>Equals,Does not equal,Is greater than,Is greater than or equal to,Is less than,Is less than or equal to,Is between,Is not between,Contains,Does not contain,Begins with,Ends with,Is like,Is not like,Is blank,Is not blank,Is any of,Is none of</value>

</data>

For reference, please see:

www.devexpress.com/Help

June 12, 2009 2:56 PM
 

Reginald said:

My question is similar to Rossi's, but the resx solution is perhaps not the answer.  I would like to limit the number of operators made available to the users on a column by column basis dynamically.  

So for example my filter control will have three properties that can be filtered: LifeId, Age, and Country.  If the user chooses to filter on LifeId, which is an integer, I only want to make the "equals" operator available to them.  And if the user chooses to filter on Age, which is also an integer, they should be given two operator options: equals and is greater than.  And if they choose to filter on Country I do not want to limit the operator options offered to the user by default at all.

LifeId will be a column of type FilterControlSpinEditColumn, and so will Age.  Country will be a column of type FilterControlTextColumn.

November 27, 2009 12:36 PM

About Mehul Harry (DevExpress)

Mehul Harry is an ASP.NET technical evangelist at Developer Express. You can reach him directly at mharry@DevExpress.com. You can also follow him on Twitter: http://twitter.com/mehulharry
More from DevExpress
Live Chat
Have a pre-sales question?
Need assistance with your evaluation?
We are here to help.
Chat is one of the many ways you can contact members of the DevExpress Team. We are available Monday-Friday between 8:30am and 5:00pm Pacific Time.
If you need additional product information, require pre-sales assistance, or want help with your order, write to us at info@devexpress.com or call us at
+1 (818) 844-3383.