This is a migrated thread and some comments may be shown as answers.
How to extend number of suggestions in the filter dropdown list ?
3 Answers 10 Views
This is a migrated thread and some comments may be shown as answers.
Henri
Top achievements
Rank 1
Henri asked on 30 Aug 2018, 10:20 AM

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

3 Answers, 1 is accepted

Sort by
0
Stefan
Telerik team
answered on 03 Sep 2018, 05:58 AM
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.
0
Henri
Top achievements
Rank 1
answered on 05 Sep 2018, 10:28 AM

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

 

 

 

0
Stefan
Telerik team
answered on 06 Sep 2018, 06:55 AM
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.
Tags
Grid
Asked by
Henri
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Henri
Top achievements
Rank 1
Share this question
or