In List operator

[Jacek]

Hello Team,

I would like to suggest a new string operator that would allow to filter rows by exact values specified on the  list. This could be either list of predefined check boxes (defined in grid data binding or configuration) or list of elements typed in by the user in textbox (i.e. Elements In List [ value1, value2, ... ]). Have you been thinking of such enhancement? This could be helpful for data columns with a few values like statuses or types. Is there a chance to have such feature soon?

Thanks and best regards

Jacek Kłobut

[Eyup]

Hi Jacek,

 

That sounds like a beneficial improvement. Could you also share some screenshots or drawings to better visualize what exactly you have in mind?

I will then log it in our Public Portal for further publicity:
https://feedback.telerik.com/kendo-jquery-ui 

 

Regards,
Eyup
Progress Telerik

[Jacek]

Hello Eyup,

Thank you for quick reply. Let me explain de requirement in details: I would see a new In List operator on the list of all operators of string type. Having selected In List user would be displayed list of values available for selection. The list would be defined for grid column - user could just create programmatically an array of distinct values from the database and assign to the column definition. Maybe for server filtering this list could be returned with current row count etc. This feature will be beneficial for columns with just a few values (codes, statuses, types) - too many check boxes could be inconvenient. Also the request size is limited. Please find my screen design enclosed.

Thanks

Jacek Kłobut

[Eyup]

Hi Jacek,

 

I think this pretty much resembles the current Multi CheckBox filtering available built-in (check the ProductName column):
https://demos.telerik.com/kendo-ui/grid/filter-multi-checkboxes

Let me know if I am missing something.

And as a custom solution, template implementation would also be possible:
https://demos.telerik.com/kendo-ui/grid/filter-menu-customization

 

Regards,
Eyup
Progress Telerik

[Jacek]

I managed to have the checkbox list on column filtering menu however the possibility to filter by values that contain some string, equal, start with etc disappears - in other words we can have either checkbox filtering or custom string filtering - am I correct and can we have both.

Regard

Jacek

[Eyup]

Hello Jacek,

 

Sorry, I have difficulties in figuring out exactly what you have in mind. Could you elaborate and send us a sample dojo or more screenshots?

 

Regards,
Eyup
Progress Telerik

[Jacek]

We are using grid with columnMenu: true setting then filtering menu is available on the second level of column menu.

In this example https://dojo.telerik.com/ofurEwaK/3 traditional filtering is applied for Product Name - user can specify up to 2 conditions.

In comparison https://dojo.telerik.com/ofurEwaK/4 allows for checkbox filtering - flag multi=true - user chooses by clicking checkboxes.

My question was about having both possibilities of filtering. This could be possible by adding new operator (IN_LIST) to the list of existing ones: eq, neq, startwith, ..., IN_LIST. After this operator has been selected user would be displayed  a list of checkboxes representing possible values of product name. So it would be possible to display products with names starting with 'Queso%' and additionally products [ 'Icura','Tofu'].

Thanks

Jacek

[Nikolay]

Hi Jacek,

Thank you for sharing more details on the use-case.

I definitely see the value in this scenario, thus we will log a new feature request in our Feedback portal.

• https://feedback.telerik.com/kendo-jquery-ui

We regularly monitor the request and unusually the ones that gain lots of popularity got included in the RoadMap for implementation.

Regards,
Nikolay
Progress Telerik

[Jacek]

Great, thank you.