I am trying to implement filter which can support relative fields i.e. the first field would be table names once user choose any table then second field gets populated with all columns available for selected table. Now users can choose operator and pass value for filtering the column value. So basically I want to filter on basis of column's value. As I dont want to put all columns for all tables in one field because that makes my drop down very long as I have huge columns in some table and also user wont be able to search specific column easily hence I want to introduce one more field which is table drop down. Once user select from table drop down then column dropdown will only have selected table column which reduce the columns number and user can choose easily. see the attached screenshot for same.  So the expression preview should be something like <field1-N>.<field2-N> <operator> <value> e.g. "table1.column5 is equal to myvalue". How we can achieve this ? I tried using editortemplate of field property of kendo Filter widget and added field 2 as shown in attached screen shot but after that not able to get field 2 value in expression. Can someone suggest what are the other ways we can achieve this ?

Hi,

Is there a way to calculate/sum the display value instead of the keyed value on the spreadsheet control? In the example below, the actual value for the E3 and E4 is actually 1.5 as we do not allow decimal points, it is shown as 2 instead of 1.5. I will like the sum (cell E5) to be "4" instead of "3". Is it possible?

Hi!

I'm trying to create an email input control. Something similar to how gmail works, where you can type and get autocompletion and where the email is converted to a "chip" that have an "x" on the right for removing. The multiselect already looks very close to what I need to achieve, but I need to be able to enter freeform convert to chip on enter or after a comma is added.

I realize that the multiselect is not designed that way, and freeform text is not really compatible with multiselect.

So the question I have is... Is there a way to use some of the building blocks of the multiselect to achieve a similar result?

I need to create a custom control to convert a freeform "John Doe <jd@example.com>" To a chip that just displays the name.

Again, I understand I will need to write the bulk of the logic to support this behavior, but I don't see a "chip" control like the angular counterpart has. Maybe I'm missing something.

Cheers

We are using jquery-1.11.3.js and implemented Kendo UI Jquery Virtual Vertical Grouping Scheduler Control (2021.3.1207). 

We upgraded the jquery to jquery-3.6.0.js and also jquery-1.12.4.js but unable to open popup on double click of event or day.

Please find below screenshot of JavaScript errors we are getting.

I have a grid and I added a search to the toolbar using toolbar: ["search"]. My datasource has a field called eventType that returns an integer corresponding to an event's type. Since the number means nothing to an end user I am using the item template to convert the number to a text string. How would a user use the toolbar's search field to search by that text string rather than the number? For example, type in "concert" and you should get events with type 1. 

Here is a dojo: https://dojo.telerik.com/@dojolee/UWaVOtoY

I am trying to apply filter for my grid. It is working fine for normal data in the grid but it is not working for array of array data in the grid. I am using template for rendering the grid data.

Kindly suggest some way to resolve this issue as soon as possible. In below example filter is working for productnumberlist but not working for daterangelist and intelWwlist.

var _daterangelist = [];
var _productnumberlist = [];
var _intelWwlist = [];

this.setDaterangelist = function(input){
_daterangelist = input;
}
this.setProductnumberlist = function(input) {
_productnumberlist = input;
}
this.setIntelWwlist = function(input){
_intelWwlist = input;
}
this.assuranceGridOptions = function () {
var selectTemplate = '<input type="checkbox" class="wom-md-checkbox"/>',
customerPartNumberTemplate = '',
intelProductNumberTemplate = '<span>{{dataItem.productNumber | trimLeadingZero}}</span>',
intelProductNameTemplate = '',
intelProcessorNumberTemplate = '',
intelWwTemplate = '#ln=availablelist.length;for (var i = 0; i< ln; i++) {#<span>#="WW"+(availablelist[i].workweek).slice(4)#</span><br>#}#',
dateRangeTemplate = '#ln=availablelist.length;for (var i = 0; i< ln; i++) {#<span>#=availablelist[i].startdate + " To " + availablelist[i].enddate#</span><br>#}#',
requestedQtyTemplate = '#ln=availablelist.length;for (var i = 0; i< ln; i++) {#<span>#=availablelist[i].quantity#</span><br>#}#',
plantTemplate = '#ln=availablelist.length;for (var i = 0; i< ln; i++) {#<span>#=availablelist[i].plant#</span><br>#}#';


var columnStyle = "text-align: center; font-size: 14px; white-space: normal; overflow: visible",
headerStyle = 'text-align: center; font-size: 14px; overflow: visible';

var searchResultsGrid = {
columns: [
{
field: '',
title: '',
width: '50px',
headerAttributes: {style: headerStyle},
attributes: {style: columnStyle},
template: selectTemplate
},
{
field: 'cpn',
title: 'Customer Part #',
headerAttributes: {style: headerStyle},
attributes: {style: columnStyle},
template: customerPartNumberTemplate
},
{
field: 'prodNum',
title: 'Intel Product #',
headerAttributes: {style: headerStyle},
attributes: {style: columnStyle},
template: intelProductNumberTemplate,
filterable: {ui: productnumberFilter}
},
{
field: 'productName',
title: 'Intel Product Name',
headerAttributes: {style: headerStyle},
attributes: {style: columnStyle},
template: intelProductNameTemplate
},
{
field: 'processorNumber',
title: 'Processor #',
headerAttributes: {style: headerStyle},
attributes: {style: columnStyle},
template: intelProcessorNumberTemplate
},
{
field: 'intelWw',
title: 'Intel WW',
headerAttributes: {style: headerStyle},
attributes: {style: columnStyle},
template: intelWwTemplate,
filterable: {ui: intelWwFilter}
},
{
field: 'dateRange',
title: 'Date Range',
width: 210,
headerAttributes: {style: headerStyle},
attributes: {style: columnStyle},
template: dateRangeTemplate,
filterable: {ui: dateRangeFilter}
},
{
field: 'quantity ',
title: 'Qty',
headerAttributes: {style: headerStyle},
attributes: {style: columnStyle},
template: requestedQtyTemplate
},
{
field: 'plant',
title: 'Plant',
headerAttributes: {style: headerStyle},
attributes: {style: columnStyle},
template: plantTemplate
}
],
columnMenu: true,
pageable: true,
noRecords: {
template: "No record found. Please contact your Intel representative for supply assurance information."
},
filterable: {
extra: false,
operators: {
string: {
contains: "Contains",
startswith: "Starts with",
eq: "Is equal to",
neq: "Is not equal to"
}
}
},
dataSource: new kendo.data.DataSource({
selectable: "",
transport: {
read: {
dataType: "json",
cache: false
}
},
schema: {
parse: function (d) {
for (var i = 0; i < d.length; i++) {
if (d[i]) {
return d[i];
}
}
return [];
},
},
filter: {

}
})
};
return searchResultsGrid;
}

this.getEmptyLineItem = function () {
return {
orderID: "",
cpn: "",
intelProductNumber: "",
intelProductName: "",
intelProcessorNumber: "",
intelWw: "",
dateRange: "",
requestedQty: "",
plant: ""
}
}

function productnumberFilter(element) {
element.kendoDropDownList({
dataSource: _productnumberlist,
optionLabel: "--Select Value--"
});
}

function dateRangeFilter(element) {
element.kendoDropDownList({
dataSource: _daterangelist,
optionLabel: "--Select Value--"
});
}
function intelWwFilter(element){
element.kendoDropDownList({
dataSource: _intelWwlist,
optionLabel: "--Select Value--"
});
}

Hi,

Can I customize remove dependency popup's message? Or it is a static message?

Thanks

Hi,

I have a date in my database (25/08/2020). When I try to display it in the kendo grid, it is shown as 25/08/2020 (Expected) for me. But some of the users from USA are shown 24/08/2020. After some debugging, I found that the local timezone conversion is done based on the browsers timezone settings. Anyway we can exclude this automatic conversion globally?

Option available so far but not suitable:

1. Convert the date to string and display. This means I lose all the functions of using date type.

2. Have UTC time in both client and server. This is a tedious process as the application is huge and cannot do this change.