RadGridView and filtering

[Rune]

Hi,

I have i grid with filtering enabled, in columns of type integer i get listed several menu items if I click on the filter cell. One of them has the name "between" (GridKnownFunction.Between), how can I disable this menu item ?

Rune

[Jordan]

Hi Rune,

Currently the filter functions for a given type and respectively the menu items in the filter functions menu are fixed.
We are nevertheless planning to allow such customization for the Q3 2008 release of RadControls for WinForms.

This is the right time to tell us what are your specific needs. How would you want such feature to work and be used? Do you want to customize the available filter functions per type or per column? Your feedback will be most helpful.
 

Regards,
Jordan
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[William]

I would like to see filter conditions, where you can define simple or complex conditions that can be used to filter, format, summarize and find rows which conform to the criteria. I single item filter is very limiting.  I need filtering with "and", "or", "between", "greater than" etc. with combinations of all of them

[Rune]

The original reason for my request is that the "between" filter function generates an exception due to lack of parameters, and my application is terminated because of this. I thought that a solution to this was to hide this feature.

On the forum i found one solution for this problem, it was as following:

FilterExpression filter = new FilterExpression(FilterExpression.BinaryOperation.AND, GridKnownFunction.EqualTo, GridFilterCellElement.ParameterName, GridFilterCellElement.ParameterName2);  
grid.Columns["column name"].Filter = filter;

This solution appears to be working in most cases, but are there no other solution for this problem ?

[Jordan]

Hello guys,

Rune,
Indeed there is a bug related to the "between" function. It is already fixed and the fix will be available in the next release of RadControls for WinForms. The workaround that you have found is the most appropriate that I could think of - it should work for now.

William: The RadGridView filtering functionality allows for quite complex filter expressions with more than a single predicate (parameter). However that functionality is limited in purpose by the UI  in order to mimic the filtering in Excel. Currently you can use the custom filter dialog to edit up to two filter predicates in a filter expression for a given column. You can configure more complex filter expressions with code. You could implement a custom dialog in order to allow your users to edit more complex filters.

In a future release we could allow for replacing the custom filter dialog or we could provide another dialog which will allow for editing the filter expression for the whole grid instead of for a single column. Please, share with us your thought about these options.

 
Best wishes,
Jordan
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[William]

I apologize for jumping into Rune's thread but I'm currently using another Grid Control and I know that my end users will never give up their current ability to filter.  I love the rest of your controls (which I just purchased) and will use your grid for rendering information especially the cardview but when it comes to filtering I think that Janus is by far the leader.  I work in the Medical Research field and having the ability to do slicing and dicing of data in real time has been a key factor.  I'd be very happy to give more information and screen shots via email.

[Vassil Petev]

Hello William,

Feel free to send us your feedback and screenshots in a support ticket. You can open a ticket from your Client.net account --> My Support --> New Support Ticket.

Thanks a lot.


Kind regards,
Vassil
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.