<pre> Kendoui grid date filterable "Is equal to" - Make it have a range base on what is input If you have a date column in a grid and you filter it and select "Is equal to" it currently doesn't work very good unless your dates/time are all on 12:00:00.000 AM Maybe you could make the filter do this when "Is equal to" If you select or inputput: 2/22/2004 It will find the following rows: 02/22/2004 00:00:00.000 <= datesFound < 02/23/2004 00:00:00.000 2/22/2004 06: It will find the following rows: 02/22/2004 06:00:00.000 <= datesFound < 02/23/2004 07:00:00.000 2/22/2004 06:50 It will find the following rows: 02/22/2004 06:50:00.000 <= datesFound < 02/23/2004 07:51:00.000 2/22/2004 06:50:20 It will find the following rows: 02/22/2004 06:50:20.000 <= datesFound < 02/23/2004 07:51:21.000 2/22/2004 06:50:20.034 It will find the following rows: 02/22/2004 06:50:20.034 <= datesFound < 02/23/2004 07:51:21.035 Maybe have a toggle for (0-12 AM/PM) or (00-23 24 hour clock) in the datetimepicker with a default setting that can be configured. Maybe make the datetimepicker have a range for each Hour, minute, second, millisecond, AM/PM * or blank - could act like a regular expression but would need to have the higher unit set. IE: ( 06:50:20.035 , 06:50:20.* , 06:50:*.* , 06:*:*.* , *:*:*.* or 6:50:20.035 AM, 6:50:20.* AM, 6:50:*.* AM, 6:*:*.* AM, *:*:*.* * Not this: *:50:*.* * ). HH , MM , ss , fff 00-23;*, 0-59;*, 0-59;*, 000 - 999;* or H , tt , MM , ss , fff 0-12;* , AM/PM;*, 0-59;*, 0-59;*, 000 - 999;* The yyyy,MM,dd could also be done this way so you could get all the rows for a yyyy****, yyyyMM**, yyyyMMdd </pre>
Add support for flexible width to columns on a "weight" basis (like XAML grid). Ps. I'm writting the example in MVC wrappers because I'm not familiar with the javascript initialization but I am posting this in Kendo UI Web category because it's a core feature and assume it would be implemented accordingly in every wrappers without having to specify them. @(Html.Kendo() .Grid<Employee>() .Name("EmployeesGrid") .Columns(cols => { cols.Bound(o => o.FirstName).Width("*"); cols.Bound(o => o.LastName).Width("2*"); cols.Bound(o => o.Initials).Width("Auto"); cols.Bound(o => o.JobTitle).Width("200"); // Or 200px })) -Assuming the grid is 900 pixel wide and the longest Initials (including header?) is 100 pixel -Ignoring the lost horizontal space in padding, margin, borders, scrollbars and anything else This example would give the following result: FirstName column: 200px LastName column: 400px Initials column: 100px JobTitle column: 200px
Confirmation messaage required to before delete record from a data grid. It should be looks like 'Are you sure you want to delete the record
When using multiple sort mode in a grid, visualize the sort order in which the grid is sorted. For example, displaying the sort order as 1,2,3,.. on the respective column headers. Without such an indication the user has no idea what sort order has been used.
When multi-select and batch editing is enabled, it would be nice to have a built-in feature to edit those rows all at once. Something like a popup with an editor for each column selected. The basic idea: Requirements - Selection mode has to be multiple. Both row and cell should be fine. - Edit mode: Batch preferably for performance reason (but allow other?). Features - [Grid widget] New multiEdit() method. Accepts an optional rowIndexes[], rowGuids[] or cellGuids[] parameter. If parameter array > 1 or parameter is null and selection > 1, open edit popup for specified or selected cells accordingly. - [Toolbar] Built-in Edit button. Disabled if selection <= 1. - [Popup] A popup with an editor for each selected (or passed into argument) columns. The popup could potentially be template based but I don't know how this would work out with the editors not always available. I leave that up to you :) Instead of a popup, it could also be (or as an extra optional feature maybe?) a fixed row right under the header that appears when you try to edit multiple rows. Sorta like the filter row but for editing. Perhaps you could even give this feature it's own edit mode. That mode would display the fixed row permanently and would disable individual editing. Upon selection, that fixed row would take up the value of the selected row (or display "Multiple" when the values differ) and changing that value would set all the selected cells of the column to that value. PS. I saw the other multi-row editing suggestion. It was mainly about having mutliple rows opened for edit at once. I understand the technicalities behind why it's a bit of a mess to do. This is not what I'm asking for here. My suggestion involves having only a single editor per column
This may be more of a bug, but Kendo does not allow you to call showColumn() or hideColumn() when the grid itself is not visible. If you look in the showColumn / hideColumn methods in kendo.grid.js, we can see that there is a .filter(":visible") on the columns in place. Unfortunately for us, our Kendo grid isn't always visible (it can be collapsed: think $.slideUp). Instead, we get an error saying (on the following line) that "style" could not be set on undefined - because our hidden grid's hidden column header doesn't pass the :visible filter. Thanks!
By Default the Grid filters for text columns only do the following comparisons; Equal, Contains, Starts, Ends (& Not's) We are missing: Greater Than, Less Than, GE & LE. Given the alphabet is ordered, it is reasonable & desirable to add these 4 comparisons to text as well as numeric & date columns. This empowers a filter like (Surname >= "L" AND Surname < "O") so we can find all customers with Names starting with L, M & N
The End-User experience for multiple column sort is awful. Please provide a UI that lets them see & change the columns they are sorting by. Current problems are: 1. If the user is sorting by 3 columns. All they see is 3 columns with an up/down arrow. There is no visual indication of the actual sort order (Col1, Col2, Col3) or (Col2, Col3, Col1). 2. Lack of Control. This gets more confusing if you have 3 columns in a sort, then click Col2, until it is not sorted. Then click it again to make it sort ascending. I assume it drops out of the sort, & is then added at the end. Making sort = (Col1, Col3, Col2). This confusion forces you to clear everything & start the sort again. 3. Inability to clear quickly. But there is no UI that offers the user a quick way to Unselect all sorted cols, so they can start the sort selection process again. Clearly we can add something to the toolbar, but ideally they wouldn't need to clear & restart their sort selection. . 4. Unpredictable outcome. It is not obvious to the User how to control the order of the multi-column sort. How does the sort get determined? :- A. First column selected becomes the Primary order, the next col is the Secondary order. eg: select Col1, then col2, then col3, to get (Col1, Col2, Col3) order. OR B. Last column selected is the Primary. eg: select Col3 then col2, then col1 to get (Col3, Col2, Col1) order. 5. Server/Database cost. Sorting & network round trips are expensive. Toggling from Asc / Desc / Clear. Is expensive & slow compared to setting all the columns once & clicking OK. 6. I'd add a mockup image, but this feedback screen doesn't permit uploads. To get an idea of a potential UI, Try sorting on multiple columns in Excel. It shows like a tree, with the primary key at the top, the secondary a line lower, followed by the less significant keys below it. OR at min. Change the Arrow into an Arrow with a tiny number (1,2,3 etc) 7. The current approach you use to add the Sort icon is really annoying to the user, especially when they have many narrow columns of numbers. Be aware that when you add the sort icon, converting a Label into something with 3 "..." chars is unnecessary. We found it cleaner to just truncate the chars that didn't fit, the user gets to see 2 more letters of the label. Which may be enough for them to know which column it is. And it is obvious that the column was too small to display more text. The large padding to the left of the "ColumnMenu" icon is part of the problem, it could be much smaller. 0.5 to 0.25 char width is sufficient. We did a lot of usability testing around this for a different control. The outcome was nearly unanimous in favor of the change above. PS: I too could see benefit in having the sort indicator display to the left. But the changes above may reduce the need a bit..
We can use template while rendering the custom command but the template doesn't have access to any of the data i.e neither row data(like generic field 'data' in column template) nor field data(individual column). There is no easy way to do conditional logic based on the data being rendered for the custom command. e.g. Have different icon for the custom command based on the status. We can achieve it during the databound but it is after the fact that the custom control is already rendered and we are tinkering with that. If the computer is too slow or if you have lot of data then user will observe the flickering effect.
I would like to see the ability to have more than one template for edit AND update on grid pop ups. Currently I can set the template file for the editable option but that is also used for the create when doing a pop up modal.
Searching by date range is a very common use-case in most business applications. I need a From and To calendar controls in the row filter. I would advise Telerik to put this functionality on the roadmap, else the row filter functionality is so restrictive as to render it useless. I am having to roll my own filters above the grid because of this one omission which is a real shame because the rest of the Grid functionality is so good. (I don't want to use filters in column headers because I don't like the fact you loose visibility of what filters are on - probably the reason for the grid rows introduction)
Ability to set accesskey on toolbar actions without having to do a template.
It would be great to have support for all wildcards while filtering.
If an Ajax validation (sync or async) is called by a custom validation, kendo grid navigation should move to next or previous cell by pressing once tab or shift + tab key, if it's valid -as normally- or cancel edit if it is not. +info in this thread: http://www.telerik.com/forums/ajax-validation-with-grid
See this Kendo Forum post: http://www.telerik.com/forums/multi-select-in-responsive In short, we need additional approaches to grid multi select using touch events
Add a Title tag to grid headers so that if the user mouseouvers they can see the column title/filed name if it has been clipped by the ellipsis
The grid widget has a columns editor which allows a field to be a custom widget, like a drop-down list for an autocomplete. I want the title column to be selected from a drop-down list
Support custom attributes for Kendo grid When kendo grid is applied to an html table, all custom attributes that have been applied to rows, cells or data within cells is lost. It would be great if you could preserve these. I realize the challenge in distinguishing between what is considered a *custom* attribute. Perhaps enforce specific naming conventions and support preservation of those. Perhaps anything starting with "data-" is preserved?
I would like to see the grid allow the adding of a new row via the keyboard when batch editing. When the user is on the last row and last cell they can hit tab and the grid will add a new record and with focus on the first editable cell. Or the user can hit enter anywhere on the last row to create a new row. This would allow for rapid entry of several new rows of data. It would allow the user to key in data in a similar way a spreadsheet like Excel would behave.
In your article: http://www.telerik.com/forums/how-to-make-a-non-editable-column-field, many developers make the point that the read-only attribute of a column should be part of the view, not model/data. By not providing a column property to prevent editing, you have put the view logic in the wrong place. Solution: Create a read-only property to each column to prevent editing.