Filters on multiple spreadsheet columns

4 posts, 0 answers
  1. Callam
    Callam avatar
    6 posts
    Member since:
    Oct 2019

    Posted 01 Nov 2019 Link to this post

    Is there any way to apply column filtering to multiple columns at once? Whenever I try to add a second filter, the first is erased.

     

    Thanks for any help.

     

    Callam

  2. Aleksandar
    Admin
    Aleksandar avatar
    188 posts

    Posted 04 Nov 2019 Link to this post

    Hello Callam,

    This can be achieved by defining the filter property for the sheet.

    filter.columns represents an array that defines the filter configuration for each individual column. You need to specify the criteria for the filter - an array of filter criteria for the custom filters. The criteria should contain an object, that provides the operator type and the value. The column array also needs information on the index to which the criteria are applied and a filter type.

    In this dojo you will find the modified demo where Client column is filtered for customers with name containing "er" and Shipping columns containing "2".

    I hope this helps. Let me know if you have further questions.

    Regards,
    Aleksandar
    Progress Telerik

    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  3. Callam
    Callam avatar
    6 posts
    Member since:
    Oct 2019

    Posted 21 Nov 2019 in reply to Aleksandar Link to this post

    Hi thanks for replying. So I take it multiple filters only work if implemented when the spreadsheet is created and that the user cannot add multiple filter?

     

    As a follow up question, is it possible to filter between a range of values, like in Excel?E.g. 'filter out if not between 3 and 6'. As far as I can tell, it seems you can only filter ' if lower than 3' or 'if above 6', but you cannot specify a filtering range. Am  I missing something?

  4. Aleksandar
    Admin
    Aleksandar avatar
    188 posts

    Posted 25 Nov 2019 Link to this post

    Hi Callam,

    The user can also apply multiple filters. In the Basic Usage example once the data is selected and filters added for the columns the user can filter by multiple columns, see a demo screencast here

    Currently, there is no available option for the user to filter values that are in between a range. As a possible solution, the user can manually select the values that should be filtered. I have logged a Feature Request on your behalf on the Public Feedback portal and updated your Telerik Points accordingly:

    We will monitor the interest in this feature and based on the demand for such an integration, this might be scheduled for research in future versions of Kedno UI. 

    Regards,
    Aleksandar
    Progress Telerik

    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top