This is a migrated thread and some comments may be shown as answers.

In List operator

8 Answers 16 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Jacek
Top achievements
Rank 1
Jacek asked on 02 Feb 2021, 08:16 PM

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

8 Answers, 1 is accepted

Sort by
0
Eyup
Telerik team
answered on 04 Feb 2021, 07:35 PM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
Jacek
Top achievements
Rank 1
answered on 05 Feb 2021, 09:48 PM

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

0
Eyup
Telerik team
answered on 09 Feb 2021, 12:40 PM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
Jacek
Top achievements
Rank 1
answered on 09 Feb 2021, 04:46 PM

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

0
Eyup
Telerik team
answered on 11 Feb 2021, 09:41 AM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
Jacek
Top achievements
Rank 1
answered on 11 Feb 2021, 11:07 AM

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

0
Nikolay
Telerik team
answered on 15 Feb 2021, 10:33 AM

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.

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
Jacek
Top achievements
Rank 1
answered on 15 Feb 2021, 04:15 PM
Great, thank you.
Tags
Grid
Asked by
Jacek
Top achievements
Rank 1
Answers by
Eyup
Telerik team
Jacek
Top achievements
Rank 1
Nikolay
Telerik team
Share this question
or