Questions on Kendo UI for jQuery Forum

2 answers

111 views

Hey

Is it possible to bind a column to a related table?

If i add a column like this where "tblCategory" is the related table:

{

field: "tblCategory",

title: "Category"

}

I can see that it's an [Object] and that it does refer to: "data.svc/tblProducts(1)/tblProducts"

Is it possible to get the data from that somehow?

Cheers

Grid

answered on 27 Feb 2012

9 answers

309 views

[Solved] Unable to load JSON without resorting to a workaround

I'm unable to load any data from my server into a grid that I'm trying to setup for simple paging without resorting to using the solution posted in the Kendo Grid Forum that uses a jquery ajax request to directly populate the "data" member directly of the kendo.data.DataSource. I am returning a simple json response that contains an array and a count to support paging (for example):

{"artists":[{"ID":4471,"Name":"10

Years","Gender":"Male","Category":"Pop/Rock"},{"ID":4391,"Name":"10,000

Maniacs","Gender":"Female","Category":"Pop/Rock"},{"ID":15,"Name":"10cc","Gender":"Male","Category":"Pop/Rock"},"count":2004}

This is my 1st cut at a datasource, and I've verified the server gets called and returns the json as above, but nothing displays in the grid:

var artistSource = new kendo.data.DataSource({

transport: {

read: {

url: "http://localhost:53596/api/Artists?format=json",

dataType: "jsonp"

},

schema: {

data: "artists",

total: "count",

model: {

fields: {

ID: { type: "number"},

Name: { type: "string"},

Gender: { type: "string"},

Category: { type: "string"}

}

},

page: 1,

pageSize: 50,

serverPaging: true,

serverFiltering: true,

serverSorting: true

}

});

Following the workaround above, this datasource below works. From what I can tell, I'm following the examples, but I'm not able to get the datasource populated properly, and I'd really appreciate any help!

// This is the ajax call that is used to populate the data

// member in the dataSource as described in the workaround in the forums:

function GetArtists() {

var _resData;

$.ajax({

type: 'GET',

url: 'http://localhost:53596/api/Artists?format=json',

dataType: 'json',

success: function (data) {

_resData = data.artists;

},

data: {},

async: false

});

return _resData;

}

// This datasource populates the data array via a jquery ajax call,

// bypassing the configuration as done in the original datasource.

var artistSource2 = new kendo.data.DataSource({

data: GetArtists(),

schema: {

model: {

fields: { ID: { type: "number" }, Name: { type: "string" }, Gender: { type: "string" }, Category: { type: "string" }

}

});

// If I use artistSource2 (the workaround), the grid gets populated,

// but if I use artistSource, nothing shows up in the grid.

$('#Artists').kendoGrid({

dataSource: artistSource2,

height: 600,

columns: [{ field: "ID" }, { field: "Name" }, { field: "Gender" }, { field: "Category"}],

pageable: true

});

Grid

answered on 27 Feb 2012

5 answers

711 views

Preventing certain nodes from dragging, possible?

Hi All,

I am trying to create a treeview with two levels. For example, first level would be company names, and each company has one or more products (aka, second level).

Please advice what is the best way to allow ONLY the second level nodes to be draggable (aka, follow the above example, I don't want the company nodes to be draggable).

Thanks!

JB

TreeView

answered on 27 Feb 2012

3 answers

184 views

Error event paramenter

Hi all

I'm trying to build in some nice error handling into my datasource for my Kendo grid.

error: function (e) {
    error = JSON.parse(e.responseText);
    alert(error.ErrorMessage);
    dataSource.cancelChanges();
}

When my DESTROY URL returns an error, this works fine.
But when my READ URL returns an error, e contains 3 arguments where the first object is the error object I want to use.

Why is the e object not the same?

Best regards,
Allan

Data Source

answered on 27 Feb 2012

1 answer

104 views

Property "navigatable" doesn't work on both grids in a hierarchical setup

I have a parent grid and within my "detailInit" handler, I add a details grid. I am trying to make both grids "navigatable" and "editable", so I set those properties to true for both grids.

However, only the parent grid is navigatable and editable, and my child grid becomes read-only, even though I set "editable" and "navigatable" properties to true during the initialization of the child grid as well.

Could someone please point me in the right direction with this?

Thank you

Grid

answered on 27 Feb 2012

0 answers

123 views

How to link multiple combobox controls together and sync changes?

I'm trying to link multiple combobox controls together. First, I want the second box to be disabled until the first box has a choice selected. Then, if the user goes back and changes the value in the first box, the second has to go back and get the new data. Is this possible?

ComboBox

asked on 26 Feb 2012

2 answers

144 views

Dependent-Linked widgets

Hi,

I just bought Kendo UI and am rebuilding a php app using the framework and widgets. Great tools and I'm looking forward to the updates next year!

I need to be able to chain multiple widgets together using the onchange event. For example, I have an autocomplete that users select a buyer from. When a buyer is selected I want to bind a combobox or dropdown to the selected value (id) in the autocomplete.

I also need to be able to set the value of several text boxes and hidden fields based on the selection of the autocomplete and other widgets on the same page. Fairy standard jquery stuff, but I'm not sure hoiw these widgets work.

My hope is that I can use the datasource to create buyer data (json) and use the onchange event to create the widget dependencies. Can you provide a basic dependent widget example? I'm using php/mysql for the back-end and can create all the json needed.

Thanks for any help.

Thanks,

Tony

General Discussions

answered on 26 Feb 2012

2 answers

181 views

Hide Series in Legend

Is it possible to not show a given series in the legend? If not, I would like to put in a request for this please.

Thank you.

Charts

answered on 26 Feb 2012

1 answer

117 views

Styling chart text: category, series and axis labels; legend; and title

Is there a way to set the color of all text on a chart?

Most default to black, but I need them to all be #777. There doesn't appear to be a color attribute for the text in the configuration...

Charts

answered on 26 Feb 2012

4 answers

1.0K+ views

How to Recalculate datasource aggregates as soon as a grid field updated

I've following datasource and grid configuritaion :

dsDetail = new kendo.data.DataSource({

schema: {

type: "json",

model: {

id: "id",

fields: {

c_pmprj: { validation: { required: true }},

c_pmchart: { validation: { required: true }},

dt: {/*type: "date",*/ validation: { required: true } },

slip_nro: {validation: { required: true }},

defi: { type: "string" },

amn: { type: "number", validation: { required: true, min: 1} },

vat01: {type: "number"},

vat08: {type: "number"},

vat18: {type: "number"},

c_zadcity: {type: "string"},

id: {type: "number"}

}

},

aggregate: [{ field: "amn", aggregate: "sum" }],

change: function (e) {

//

}

});

gridDetail = $("#grid_pmexpense").kendoGrid({

dataSource: dsDetail,

//height: 250,

//filterable: true,

scrollable: false,

pageable: false,

//selectable: 'row',

sortable: true,

editable: true,

navigatable: true,

columns : [ {field: "c_pmprj", title: "Proje", width: "120px", editor: prjEditor},

{field: "c_pmchart", title: "Masraf", width: "300px", editor: chartEditor},

{field: "dt", title: "Belge Tar.", width: "120px", editor:dateEditor /*format: "{0:dd.MM.yyyy}"*/},

{field: "slip_nro", title: "Belge No", width: "120px"},

{field: "defi", title: "Açıklama", width: "220px", editor: noteEditor},

{field: "amn", title: "Top.Tutar", width: "120px", template: '#= amn #'},

{field: "vat01", title: "KDV %1", width: "100px", template: '#= vat01 #'},

{field: "vat08", title: "KDV %8", width: "100px", template: '#= vat08 #'},

{field: "vat18", title: "KDV %18", width: "100px", template: '#= vat18 #'},

{

field: "id",

title: "İşlemler",

template: detailGridActionTemplate,

width: "130px"}

],

change : function(e) {

//

},

save: function (e) {

$("#amn_tot").data("kendoNumericTextBox").value(this.dataSource.aggregates().amn.sum);

},

saveChanges: function(e) {

//alert('save');

}

});

But this code does not update $("#amn_tot") field with new summed value... In fact this.dataSource.aggregates().amn.sum call always return initial summed up value... How do I recalculate aggregate value? Am I missing something ?

Thanks.

Grid

answered on 26 Feb 2012