Hi

I need aggregate function SUM to skip some column values based on other column value. In another words I don't want to include all column values in sum but only those for which the another column value, say Record_ID == 1. I think of a kind of custom function with if condition.
Is it possible in grid?

Hello,

Currently, is there a way to compare Kendo filters?

Example of equalities:
* {"logic":"and","filters":[{"value":"abc","operator":"eq","field":"type"},{"value":"xyz","operator":"eq","field":"model"}]}
* {"logic":"and","filters":[{"logic":"or","filters":[{"value":"abc","operator":"eq","field":"type"}]},{"value":"xyz","operator":"eq","field":"model"}]}
* {"logic":"and","filters":[{"logic":"or","filters":[{"value":"abc","operator":"eq","field":"type"}]},{"logic":"or","filters":[{"value":"xyz","operator":"eq","field":"model"}]}]}
* {"logic":"and","filters":[{"value":"abc","operator":"eq","field":"type"},{"logic":"or","filters":[{"value":"xyz","operator":"eq","field":"model"}]]}}
* {"logic":"and","filters":[{"value":"xyz","operator":"eq","field":"model"},{"value":"abc","operator":"eq","field":"type"}]}
* ...

There are many ways that Kendo generate equal filter queries (such as the "Clear" button). However, I did not find a way to compare...

Thanks,
Pascale Audet

Hi!

I have some troubles with drawer. I have the application with the login page. After the user is authenticated I navigate his on page "Cabinet" using 



But when I open the drawer on the second page I see the previous login page.

The code of drawer:

What is the problem?

P/S/ please find the screenshot with problem in the attached file   

 

Does the count measure count the itens using DISTINCT?

For instance, let's say we have a dataSource like this:

 

var dados = [{ PersonID: 2958, Address: "5h St"},{ PersonID: 2958, Address: "​Lexington Ave"},{ PersonID: 2958, ​Address: "76th Street"}]

 

Note that it is only 1 person, which has 3 address.. if I wanted to use the COUNT measure on the Address, it is correct (it counts 3 itens). But when I use the COUNT measure on the PersonID, it also counts 3 itens, but there is only one personID. If the COUNT measure does not use DISTINCT, Is there any workaround for this? 

Hi,

Like you see it on this example: http://dojo.telerik.com/@Janek91/AbUSE if I try to change available tools in the embedded Editor - in result I'm getting it duplicated, that's because I'm using k-ng-model directive. There is a possible workaround here: http://dojo.telerik.com/@Janek91/Eseva I can simply use Angular to paste HTML into <textarea> tag and not to use k-ng-model. But is there really no other way to use k-ng-model, configure tools and don't get duplicated Editor?

I guess I'm not understanding the hierarchical grid when it comes to editing. 

Is the parent dataSource in no way connected to the child dataSources? So, when saving, I have to loop through and call save on every child grid? 

Does it not use a hierarchical DataSource?

 

 

I have recently started to work with the LinearGauge control, but don't see a way to increase the size of the colored bands that define the ranges.  The bands are very thin, giving the gauge somewhat the appearance of a thermometer.  I would like thicker bands that are easier to see at a glance -- for a horizontal gauge, this would be a height increase in the bands; for a vertical gauge, a width increase.  The scale.rangeSize option accomplishes this for a RadialGauge, but is there any similar setting for a LinearGauge?  Alternatively, are there style settings that could do the same thing?

Regards,
Fred

Hello,

I have a grid like the one from your demo: http://demos.telerik.com/kendo-ui/grid/hierarchy
<div>
        @{
            Html.Kendo().Grid<TicketModel>()
                .Name("ticketsList")
                .HtmlAttributes(new { @class = "ticketsGrid" })
                .Columns(columns =>
                {
                    columns.Bound(m => m.TicketID).Visible(false);
                    columns.Bound(m => m.TicketNumber);
                    columns.Bound(m => m.TicketTypeName);
                    columns.Bound(m => m.Name);
                    columns.Bound(m => m.Status);
                    columns.Bound(m => m.Severity);
                    columns.Bound(m => m.DaysOpened);
                    columns.Bound(m => m.DateCreated).ClientTemplate("#= kendo.format('{0:d}', kendo.parseDate(DateCreated))#");
                    columns.Bound(m => m.TicketNumber).ClientTemplate("<img title='Add comment' src='" + Url.Content("~/Images/icon_edit.png") + "' onclick=\"location.href='" + Url.Action("AddTicket", "Support", new { ticketId = "#= TicketID #" }) + "'\"/>&nbsp;&nbsp;&nbsp;").Title("").Sortable(false).HtmlAttributes(new { @class = "action-buttons" });
                })
.....
        }
    </div>

    <script id="template" type="text/kendo-tmpl">
    @(Html.Kendo().Grid<ActionModel>()
            .Name("ticketsList_#=TicketID#")
            .Columns(columns =>
            {
                columns.Bound(o => o.ActionID);
                columns.Bound(o => o.Description);
                columns.Bound(o => o.Name);
                columns.Bound(o => o.Status);
                columns.Bound(o => o.AttachmentId).ClientTemplate(
                    "# if (o.AttachmentId != null) { #" +
                        "<img title='Download Attachment' src='" + Url.Content("~/Images/Attach.png") + "' onclick=\"location.href='" + Url.Action("AddTicket", "Support", new { ticketId = "#= o.AttachmentId #" }) + "'/>" +
                        "# } #").Title("").Sortable(false).HtmlAttributes(new { @class = "action-buttons" });
            })
......
    )
    </script>
The conditional from the 2nd grid is not working.. if I use the following condition "# if (AttachmentId != null) { #"  i get a javascript error in page that AttachmentId is not defined.

Could you help me please with this one?

Thank you,
Oana

I have a custom Edit template working with a grid in that when I show the grid and click the "Edit" button it shows the popup with the data.  I can edit the data and choose the "Update" button and the popup closes.  I can click the "Edit" button again and the popup shows with the modified data.  So far so good.

 

But two things are happening that are not good.  If I click the "Cancel" button I get the following error:

Unhandled exception at line 27, column 1898 in http://localhost:51277/Scripts/kendo/2016.1.18/kendo.all.min.js
0x800a138f - JavaScript runtime error: Unable to get property 'uid' of undefined or null reference

 

Also the data from the Popup is not populating the underlying row visually in the grid.  The popup only has a few of the columns in the grid row but again they remain empty when the popup closes.  When the popup shows again if you again click the "Edit" button the data is in the fields.

 

I have this at the top of the custom editor template which is the unique ID for the row.

The following code is in place in the Grid markup:

The Datasource in the grid defines the update method on the controller:

 

One thing to note is that the spec for the main template that contains the grid is to do a batch update for all the rows in grid that are modified.  I have that concept working in other templates which send the JSON to the controller.  All that is working fine but I mention the spec here to state that the controller method does nothing on the backend and just returns the data row item sent into the controller.  When the user clicks the master "Save" button I will post the data to the database.

Here is the controller method:

 

Does someone have a suggestion as to what is going wrong here?  Do I need some JavaScript in the Editor template or the parent main Razor view?

Thanks!

Reid

 

 

 

 

 

 

 

 

 

 

 

 

 

 

My json data for this cells is String i.e. :  "05:20"   {HH:mm} format.

Here is my grid options for this column:

column ...  { title: 'Jazdy', field: 'driving_time', footerTemplate: "#= data.driving_time.sum #"}

aggregate ... { field: "driving_time", aggregate: "sum" }

schema ... model: { fields: { driving_time: { type: "duration" }, ...} ...}

So in this scenario in footer i see value only from last row. How to make it properly to get summary duration in footer?