Excel Like Filtering - using Webservice context is NULL

10 posts, 1 answers
  1. Srikrishna
    Srikrishna avatar
    13 posts
    Member since:
    May 2015

    Posted 12 Apr 2016 Link to this post

    W.r.t to Excel like filtering in radgrid. I am trying to call a webservice using -

    ADMIN: Code removed upon OP request.

    Requirement : To use Webservice , I have 40 columns so planning to send Column name as a context to WS method and reuse the select query for all..
    eg)

     

    ADMIN: Code removed upon OP request.

  2. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 15 Apr 2016 Link to this post

    Hi,

    Note that using WebMethod as you are trying to achieve in your code would not work in this case. You should use WebService as shown in the online demo below:
    http://demos.telerik.com/aspnet-ajax/listbox/examples/loadondemand/wcf/defaultcs.aspx

    I hope this helps.

    Regards,
    Maria Ilieva
    Telerik
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
  3. Srikrishna
    Srikrishna avatar
    13 posts
    Member since:
    May 2015

    Posted 15 Apr 2016 in reply to Maria Ilieva Link to this post

    Thank you for your reply. The example you provided will involve much changes in my side as I have 40 columns and I would like to avoid using radcombo or listbox .. instead of my current gridboundcolumn. That's fine we settled with using multiple methods to achive this scenario.

     

    I have found one more issue in Excel like filtering grid. When select few checkbox and click 'filter' it works fine. But once user tries to reopen the same column and click 'Clear Filter' button . It is not unchecking the checkbox selected by user before. I see that your online demo is working fine but I am not able to replicate that clearing in my side.

     

    Question 1: Is there a way for me to Handle the 'ClearFilter' event in codebehind (or) client side .

    Question 2 : I only want to clear the selected column filter not other remaining columns.

    Question 3 : When I click 'Filter' button - radgrid filters but I don't get to see the loading image. Which shows up on other operations.

     

    Please find the code .. Removed few lines . Please help. Using Vs 2015 enterprise , ,net 4.5.01055

    Telerik : v4.0.30319 ,  version : 2015.3.1111.45 , Telerik UI for ASP.NET AJAX

     

     

    ADMIN: Code removed upon OP request.

     

  4. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 20 Apr 2016 Link to this post

    Hi Srikrishna,

    The mentioned issue was a problem in older version of the controls and this behavior is already fixed in the  latest official release. I would suggest you to update your application to the latest version and see how it goes.


    Regards,
    Maria Ilieva
    Telerik
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
  5. Srikrishna
    Srikrishna avatar
    13 posts
    Member since:
    May 2015

    Posted 20 Apr 2016 in reply to Maria Ilieva Link to this post

    Hi ,

       Sorry not sure about your reply , as I had the following 3 questions in it.

    Question 1: Is there a way for me to Handle the 'ClearFilter' event in codebehind (or) client side .
    Question 2 : I only want to clear the selected column filter not other remaining columns.
    Question 3 : When I click 'Filter' button - radgrid filters but I don't get to see the loading image. Which shows up on other operations.

     

    You mean to say that Question 2 -- will be resolved with latest version ?

    Can you please suggest something on Question 1 and Question 3?

     

    Thanks

     

  6. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 25 Apr 2016 Link to this post

    Hi Srikrishna,

    1. The ClearFilter method fires OnCommand event and OnUseraction event that can be handeled.
    2. If you need to clear the filter for specific column you could simply filter without parameter to achieve this requirement.
    3. The LoadingPanel will appear when regular Ajax request is performed and when a service is called you should call it manually as shown below:
    http://docs.telerik.com/devtools/aspnet-ajax/controls/ajaxloadingpanel/how-to/show-and-hide-ajaxloadingpanel-explicitly






    Regards,
    Maria Ilieva
    Telerik
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
  7. Srikrishna
    Srikrishna avatar
    13 posts
    Member since:
    May 2015

    Posted 14 Jun 2016 in reply to Maria Ilieva Link to this post

    HI MARIA,

       Thank you for the options.

       Could you please give an sample code to using - ' The ClearFilter method fires OnCommand event and OnUseraction event that can be handeled.'

       I have 10 columns in my radgrid , when I click clear filter button --- I don't know how to get the current column & how to uncheck the checkboxs that I selected earlier to filter upon ... I mean I want to perform a nofilter operation on click on clearfilter.

     

       appreciate if you could provide a sample for 1 and 2 options you provided.

    thanks

    krishna

     

  8. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 17 Jun 2016 Link to this post

    Hello,

    You can simply handle the server OnCommand event with Filter command name as when "Clear Filter" button is clicked a filter command with empty filter function, value and expression fires.

    Regards,
    Maria Ilieva
    Telerik
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
  9. Srikrishna
    Srikrishna avatar
    13 posts
    Member since:
    May 2015

    Posted 19 Jan Link to this post

    Please delete the following post from me ... as it contains some information that I should have removed before posting..

     

    http://www.telerik.com/forums/excel-like-filtering---using-webservice-context-is-null#ho0lv6aTg0-ZZH_ZJqXfEg

     

  10. Answer
    Marin Bratanov
    Admin
    Marin Bratanov avatar
    3843 posts

    Posted 19 Jan Link to this post

    Hi Krishna,

    I removed the code snippets. I left the discussion itself in case someone else finds it useful.

    Regards,

    Marin Bratanov
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top