Progress® Kendo UI® for jQuery Feedback Portal
Back to Feed
Request a Feature Report a Bug
Completed
Last Updated: 03 Mar 2020 09:45 by ADMIN
Philip
Created on: 24 Jul 2012 07:59
Category: Grid
Type: Feature Request
1
Compare grid columns
Hi,

We use your kendo grid and it's great. Our users use a lot of filtering, sorting, etc.. One capability which is lacking is a way to compare columns. Now you filter a column based on a value (is greater than 5). It would be great if users could enter a value or another column.  The user should be able to select that column from the list. This list should contain all column titles.

This would be a great addition.
Duplicated Items
3 comments
ADMIN
Pavlina
Posted on: 03 Mar 2020 09:45

Hello Philip,

The requested functionality can be achieved using the Kendo Filter component which creates various filter expressions, ranging from a simple "contains" to a more complex filter containing and/or statements. Below you can find a runnable example:

https://demos.telerik.com/kendo-ui/filter/custom-editors

Regards,
Pavlina
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.
Philip
Posted on: 07 Sep 2012 10:52 
http://feedback.kendoui.com/forums/127393-kendo-ui-feedback/suggestions/3096464-expressioneditor

would be a perfect solution.
Philip
Posted on: 25 Jul 2012 08:00 
Another way to implement this would be to allow formulas. Right now in a field of type number the user can only enter a decimal value. When you try to type in anything else it just doesn't respond. Instead you could allow removing the restriction on the field and allow users to enter a formula.

For instance you could then enter:
- Greater than or equal to
- (Column title 1) * 2

This solution would even be more beautiful if it worked with tagging, recognizing the column name or operator as you're typing it in. Like a jquery tagify. Such an example already exists in practice in robotdough.com where users can enter formulas in text boxes and the systems tags and provides autocomplete as you're typing.

If the user enters a bogus formula, this can be handled on the server side. This feature would add a lot of power to the grid.
Create an account Log In
View
Type
Status
Category