Filtering UI confusing in some cases

14 posts, 0 answers
  1. erwin
    erwin avatar
    358 posts
    Member since:
    Dec 2006

    Posted 22 Jan 2009 Link to this post


    While filtering is a very useful feature, it tends to confuse my test users in some cases, mostly in combination with other powerful features of the grid:

    - If a filter is set and the column then hidden by the user, there is no visual indication of an active filter. This can be especially confusing in combination with the SaveLayout()/ LoadLayout() feature.

    - On boolean columns there is no easy way to distinguish between a clear filter and an unchecked checkbox.

    On my prototype application I have therefore implemented a 'Clear all Filters' Button, that is only enabled if any filters are set. In addition to indicate the filtering, clear all filters might be a useful standard function (for example in the context menu) of the grid.

    Regards
    Erwin
     
  2. Jack
    Admin
    Jack avatar
    2335 posts

    Posted 23 Jan 2009 Link to this post

    Hello erwin,

    Thank you for the feedback.

    All the suggestions are valuable for us. We will take them in consideration when working on the future versions of the RadGridView. I have updated your telerik points.

    Feel free to write us if you have any questions.

    All the best,
    Jack
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Prad
    Prad avatar
    35 posts
    Member since:
    Apr 2008

    Posted 26 Jan 2009 Link to this post

    Hi Erwin,

        If a filter is set and the column then hidden by the user, there is no visual indication of an active filter. This can be especially confusing in combination with the SaveLayout()/ LoadLayout() feature.
       - Explicit coding can be done on the UI to indicate if the column is filtered. Example: color the column when filtered.

    **Make use fo cellformating event.


    if (e.CellElement.ColumnInfo is GridViewDataColumn)  
                    {  
                        for (int i = 0; i < rgvResult.MasterGridViewTemplate.FilterExpressions.Count; i++)  
                        {  
                            for (int j = 0; j < rgvResult.MasterGridViewTemplate.FilterExpressions[i].Parameters.Count; j++)  
                            {  
                                if (((GridViewDataColumn)e.CellElement.ColumnInfo).FieldName ==  
                                        rgvResult.MasterGridViewTemplate.FilterExpressions[i].FieldName)  
                                {  
                                    if (rgvResult.MasterGridViewTemplate.FilterExpressions[i].Parameters[j].Value != null)  
                                    {  
                                        if (rgvResult.MasterGridViewTemplate.FilterExpressions[i].Predicates[0].Function != GridKnownFunction.NoFilter)  
                                        {  
                                            if (!(e.CellElement is GridHeaderCellElement))  
                                            {  
                                                e.CellElement.DrawFill = true;  
                                                e.CellElement.NumberOfColors = 1;  
                                                ee.CellElement.BorderBottomColor = e.CellElement.BackColor = System.Drawing.Color.Beige;  
                                            }  
                                        }  
                                        else  
                                        {  
                                            if (!(e.CellElement is GridHeaderCellElement))  
                                                e.CellElement.DrawFill = false;  
                                        }  
                                    }  
                                    else  
                                    {  
                                        if (!(e.CellElement is GridHeaderCellElement))  
                                            e.CellElement.DrawFill = false;  
                                    }  
                                }  
                                break;  
                            }  
                        }  
                    }  
     
    ///Event  
      private void CallFormatCell(RadGridView rgvResult, CellFormattingEventArgs e)  
            {  
                FormatCell(rgvResult, e);  
            } 

    Hope this helps till Telerik comes up with blink.

    Regards

    Pradeep

  5. erwin
    erwin avatar
    358 posts
    Member since:
    Dec 2006

    Posted 27 Jan 2009 Link to this post

    Thanks for the sample code Pradeep.

    Regards
    Erwin



  6. Jack
    Admin
    Jack avatar
    2335 posts

    Posted 28 Jan 2009 Link to this post

    Your feedback is greatly appreciated, Pradeep. We will take it into consideration when implementing this feature in RadGridView. I have updated your Telerik points.

    Please do not hesitate to write us if you have any questions.

     
    Greetings,
    Jack
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  7. Alcatraz
    Alcatraz avatar
    15 posts
    Member since:
    Mar 2010

    Posted 26 Apr 2010 Link to this post

    Hi Telerik Team,

    I go with Erwin's query and even had the same requirement in my application where in the user need to be indicated whether any filter is applied for any column.  Infact as per my requirement, the user feels comfortable to see a colored funnel when a filter is applied and an empty funnel icon if its not applied.

    Currently am using the latest version (2010 SP1) and could you please confirm whether you have included any attribute or event in gridview such that I can achieve this.

    Please help me out on this.

    Thanks
    Krishnan N
  8. Jack
    Admin
    Jack avatar
    2335 posts

    Posted 27 Apr 2010 Link to this post

    Hello KrisYs,

    This is not possible with the current version of RadGridView. We plan to add such a property in our upcoming Q2 2010 release.

    Kind regards,
    Jack
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  9. Prad
    Prad avatar
    35 posts
    Member since:
    Apr 2008

    Posted 27 Apr 2010 Link to this post

    Krishnan,
     You could color the header in cellFormatting event (for sorted/filtered scenario). Hope if that helps you though..

    prad
  10. erwin
    erwin avatar
    358 posts
    Member since:
    Dec 2006

    Posted 27 Apr 2010 Link to this post

    The filtering UI caused a lot of support questions with my users.
    The checkbox/boolean column filter is more intuitive in 2010Q1 where the checkbox is now not shown if no filter set.
    But there is still room for improvement for the filter UI.

    In my app, I have derived a grid control from the original grid which provies a context menu and button to clear all filters.
    These controls are only enabled, if a filter is set, so the user has direct feedback on active filters.

    Plus I always display the total amount of records in the datasource and the amount of visible records. This helped a lot in reducing support questions such as "I can't see my data anymore".

    Regards
    Erwin
  11. Jack
    Admin
    Jack avatar
    2335 posts

    Posted 29 Apr 2010 Link to this post

    Hi Erwin, thank you for your feedback.

    Please, feel free to share your project with the community. I think it will be helpful and we will appreciate that. We will add a property which indicates whether filtering is applied on a column in one of our upcoming releases.

     

    Best wishes,
    Jack
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  12. Eric
    Eric avatar
    24 posts
    Member since:
    Jul 2011

    Posted 01 Jun 2012 Link to this post

    I would like to second the request of Prad regarding the ability to problematically set the funnel to colored.  I also wanted to expand on that.  Similar to Erwin and other's observations, our users are also perplexed with the filtering.  First, let me explain our situation.  We have the ability to filter our dialog using a "saved view".  This saved view is used to control the data that is fed into the grid.  For performance reasons, we do not simply pull down the entire data set and then use the grid to filter.  I'm imagining this is a common scenario among the dev community.

    So because of this, and the fact that in our saved views we allow the user to filter down on any particular column, when this saved view data is loaded into the grid, it will be pre-filtered if you will.  Therefore, the column filter is not colored or showing of a filter applied in any way, because of course from the grid's perspective there is no filter.  

    So what would be ideal is the following in order of importance
    1. Ability to just set a flag on the column that visually indicates it is filtered (even if the user cannot see the filter... it's still a help)
    2. At the bottom of the list, some button or other UI control to indicate the user can click and retrieve more values.  This would trigger an even we could catch and then allow us to populate a complete list of values that we retrieved from the database.  Then, we'd need a way to know if they had checked any of these "virtual" filters so that we could modify our saved view definition and pullback the new dataset that was inclusive of those values.  

    Hope you are following.  I'm just describing the underlying problem and one possible solution.  I'd be glad to discuss more in detail if needed. To end on a positive note, the user of the Telerik controls has had a huge impact on our product's usability and excitement in our company.  So thanks,

    Eric
  13. Jack
    Admin
    Jack avatar
    2335 posts

    Posted 07 Jun 2012 Link to this post

    Hello Eric,

    Thank you for your feedback. We appreciate it and you have a point. I will discuss all possible scenarios with our developers and we will think how to improve our API to enable these features.
     
    Kind regards,
    Jack
    the Telerik team
    RadControls for WinForms Q1'12 release is now live! Check out what's new or download a free trial >>
  14. M. R.
    M. R. avatar
    49 posts
    Member since:
    Dec 2009

    Posted 24 Jul 2012 Link to this post

    Hello,

    I am trying to implement a similar code for the ASP.Net grid, but here is no CellFormating event in the ASP version...
    Any suggestion?

    Regards,
    M.R.
  15. Stefan
    Admin
    Stefan avatar
    2891 posts

    Posted 25 Jul 2012 Link to this post

    Hello,

    This forum concerns RadGridView for WinForms, while your question is related to RadGridView for ASP.NET AJAX. Please address your question to the appropriate forums, so you can get adequate answer.
     
    All the best,
    Stefan
    the Telerik team
    RadControls for WinForms Q2'12 release is now live! Check out what's new or download a free trial >>
Back to Top
UI for WinForms is Visual Studio 2017 Ready