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

[Henri]

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

[Stefan]

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

[Henri]

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

 

 

 

[Stefan]

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