Questions on Kendo UI for jQuery Forum

3 answers

190 views

Gantt - toggle planned vs actual outside of gantt toolbar

Hi,

I would like to be able to toggle planned vs actual view on gantt outside of gantt toolbar as I have a few other steps and conditions to fulfill before I show the data.

Is there any method for doing this or any way you would recommend?

Thank you and regards,

Vedad

Gantt

answered on 04 Aug 2021

3 answers

6.1K+ views

Dialog change kendo.confirm title

Please open Dialog form.

How can I change title for dialog opened with kendo.confirm(... ?

May I suggest that you extend kendo.confirm method with optional second parameter for title.

General Discussions

answered on 03 Aug 2021

0 answers

107 views

Format Nodes Headers in a Diagram

I am trying to figure out how to format some nodes in my diagram. See attached dojo. https://dojo.telerik.com/ASinArEh

I would like:

The Circles to be centered under the titles.
The Node Name to be centered in the circle, not the group.
The Connections to hook to the Circle connectors, not the group connectors.

It seems like my visual template needs to create the circles, then possibly go back and add groups to the diagram then include the existing circles in the new groups, but I haven't figured out a way to do that yet

Diagram

asked on 02 Aug 2021

1 answer

353 views

LOWER() in SQL script created by Kendo causes major performance problem!

Hello,

We are using Kendo.MVC, version 2020.1.400. We use microsoft sql server 2017. Our database is case insensitive.

When kendo grid request comes in, we translate Kendo's sort, paging, etc into ISpecification in SharpRepository and we let SharpRepository to handle the sql communication.

We recently made the code change that we skip SharpRepository and use Kendo extension ToDataSourceResult() to deal with sql server.

For large data set, we find the new approach takes much longer time to show the Kendo grid. After investigation, I found that the sql generated by Kendo contains LOWER() for columns! Below is an example. However, in SQL Server, when you use LOWER for a column, the index for that column is not used! It has to do clustered index scan, which is very slow.

I saw an old post saying LOWER() is built in behavior and no way to change it. https://www.telerik.com/forums/grid-filtering-on-text-using-lower-in-sql

I wonder if the latest kendo can allow the user to disable LOWER() behavior. it is very straightforward for your company to fix it, basically providing an additional boolean parameter to ToDataSourceResult() to enable or disable LOWER(). A small thing for Kendo but a big thing for us. Currently if LOWER() can't be removed, we have to go back to the old approach by using SharpRepository. the sql generated by SharpRepository doesn't include LOWER. Our database is case insensitive, so LOWER() is really unnecessary and it is a performance bottleneck.

Please please please fix it.

SELECT
    [Extent1].[UserId] AS [UserId],
    [Extent1].[Id] AS [Id],
    [Extent1].Blah
    FROM [dbo].[UserFilteredWorkbenchItems] AS [Extent1]
WHERE (((LOWER([Extent1].[UserId])) = (LOWER(N'881d796c-9c88-ea11-99e7-0003ff77da57'))) OR ((LOWER([Extent1].[UserId]) IS NULL) AND (LOWER(N'881d796c-9c88-ea11-99e7-0003ff77da57') IS NULL))) AND (((LOWER([Extent1].[FilterByUnit])) = (LOWER(N''))) OR ((LOWER([Extent1].[FilterByUnit]) IS NULL) AND (LOWER(N'') IS NULL)))
    ORDER BY row_number() OVER (ORDER BY [Extent1].[Priority] ASC)
    OFFSET 160 ROWS FETCH NEXT 20 ROWS ONLY

Best regards

Frank

Filter

Grid

answered on 02 Aug 2021

1 answer

74 views

Kendo Window Event Syntax Error

Per screenshot below: I have used events in Kendo Window this way many times before, and I don't understand why I'm getting the syntax error below. Can anyone help, please?

Window

answered on 02 Aug 2021

1 answer

207 views

Changing Behavior of Kendo Grid Inline Editing Selected Text Drag/Drop

Currently Kendo grids, like this one, behave like tables in MS Word when selected text is dragged/dropped. I would like my Kendo grid to not have this behavior and instead act more like Excel, where clicking and moving the mouse while over selected text will change the selection.

Is there an option for this in the Kendo jQuery Grid?

Drag and Drop

Editor

Grid

answered on 02 Aug 2021

0 answers

214 views

Kendo UI Grid function create send Duplicate

hello

i don't know why, but my code send a duplicate request to the web API

please help me with this.

jquery code:

<body>
<div id="grid"></div>
</body>

<script>

$(document).ready(function ()
{

var dataSource = new kendo.data.DataSource(
{
autoSync: false,
transport:
{
read:
{
url: '/api/test/GetAllRecords',
dataType: "json"
},
create:
{
url: '/api/test/AddNewRecord',
dataType: "json",
method: "GET"
}
},
schema:
{
data: "results",
model: {
id: "PolicyId",
fields: {
PolicyId: { type: "number", validation: { required: true, min: 1 }},
PolicyName: { validation: { required: true } },
PolicyDeletionPeriod: { type: "number", validation: { required: true, min: 1 } }

}
}
},
pageSize: 100
});

$("#grid").kendoGrid(
{
dataSource: dataSource,
toolbar: [{ name: "create", text: "Create new row" }],
editable: "popup",
columns: [
{ field: "PolicyId", title: "PolicyId" },
{ field: "PolicyName", title: "PolicyName" },
{ field: "PolicyDeletionPeriod", title: "PolicyDeletionPeriod" }
]

});

});
</script>
</body>

blue is my request the second I don't know why happened

Grid

asked on 31 Jul 2021

1 answer

1.1K+ views

How to custom font-size, color, style of validationMessage

Hello,

Please guide me for change font-size , color or style of the invalid message (see at attahc image)

Thank you

Validation

answered on 30 Jul 2021

4 answers

186 views

How to change hover color of table in MultiColumnComboBox list

Hello Support,

I want to custom color of hover in row of list in MultiColumnComboBox. How can I do it?

Thanks.

MultiColumnComboBox

answered on 30 Jul 2021

1 answer

766 views

GRID : Group by column type object

Hi all,

We are trying grouping by column type object , for this, we use this code:

group: function(e) {
    if (e.groups.length) {
        var isNestedGrouped;
        
        e.groups.map(function(x){
            if(x.field == "type"){
                isNestedGrouped = true;
            }
        })
        
        if(isNestedGrouped){
            e.preventDefault()
            var newGroups = [];
            this.dataSource.group().forEach(function(x){
                if(x.field != "type"){
                    newGroups.push(x)
                }
            })
            newGroups.push({field:"type.name"})
            this.dataSource.group(newGroups)
        }   
    }
}

With this code, the grouping work correctly, but the text appears in header group template it's not we need.
In the grid we can see the name of field and his value, but we want see the title of the column.

How we can do it?

Thank you in advance

Grid

answered on 30 Jul 2021