How to extend number of suggestions in the filter dropdown list ?

4 posts, 0 answers
  1. Henri
    Henri avatar
    89 posts
    Member since:
    Aug 2008

    Posted 30 Aug 2018 Link to this post

    Dear Telerik,

     

    we have a Grid containing a lot of data.
    The Columnfilters-suggestions-dropwdown-list is only showing 26 suggestions starting with 'AW', while there are more than 100 rows starting with 'AW' in the grid.
    Please look at the attached screenshot png.

    Is there a way to increase the number of suggestions shown in the Columnfilter-dropdown ?

     

    Regards,

    Henri

  2. Stefan
    Admin
    Stefan avatar
    3039 posts

    Posted 03 Sep 2018 Link to this post

    Hello, Henri,

    The AutoComplete used for filtering should show all of the data that matches the criteria without restriction of the number of records.

    I made an example with 100 rows and all of them are shown:

    https://dojo.telerik.com/eYoZiKeD

    If server filtering is used, please check if any request is made to the server when typing inside the input and if the response from the server is returning all records.

    If the issue still occurs, please provide an example as this will allow us to pinpoint to the reason for the undesired result.

    Regards,
    Stefan
    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. Henri
    Henri avatar
    89 posts
    Member since:
    Aug 2008

    Posted 05 Sep 2018 in reply to Stefan Link to this post

    Hello Stefan,

    the Problem occurs when paging is enabled.
    I have added following code to your exemple and the suggestion list is limited
     pageable: {
        refresh: true,
        buttonCount: 5,
        pageSize: 25,
        pageSizes: [25, 50, 75, 100, 'all'],
        change: e => {},
      },

     

     

    serverPaging and serverFiltering are set to false

    Is there a way to solve this ?

    Regards, Henri

     

     

     

  4. Stefan
    Admin
    Stefan avatar
    3039 posts

    Posted 06 Sep 2018 Link to this post

    Hello, Henri,

    Thank you for the additional detail.

    This occurs because the AutoComplete shares the same dataSource as the Grid. Once the Grid is pageable, the data is shown only for the visible page and the same is shown for the AutoComplete.

    This will require setting the "columns.filterable.cell.dataSource" property and passing nonpageable dataSource to ensure that the AutoComplete has to full data, not only the current page:

    https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/columns.filterable.cell#columns.filterable.cell.dataSource

    I hope this is helpful.

    Regards,
    Stefan
    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