Questions on Kendo UI for jQuery Forum

0 answers

112 views

Sorting problem

Hi,

i create this to get grid info from mysql database:

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

<script>

$(document).ready(function() {

$("#grid").kendoGrid({

dataSource: {

transport: {

read: {

url: "page.php",

type: "post",

dataType: "json"

}

},

schema: {

data: "data",

total: "pageSize"

},

pageSize: 200,

serverPaging: true,

serverSorting: true

},

height: 450,

scrollable: true,

groupable: true,

sortable: true,

filterable: true,

pageable: true,

selectable: "multiple row",

columns: [

{

field: "sel",

template: "<input type=\'checkbox\' id=\'select\' name=\'sel\' value=#=ARTICLE_ID# />",

filterable: false,

sortable: false,

groupable: false,

width: 50

},

"CODE",

{

field: "CATEGORY_NAME",

title: "CATEGORY"

}

,

"ARTICLE_NAME",

{

field: "edit",

template: "<a class=\'link_page\' href=\'/gestionale/factory/article/edit/id/#=ARTICLE_ID#\'>Edit</a>",

filterable: false,

sortable: false,

groupable: false,

width: 50

},

]

});

</script>

my page.php

i do a query with an inner join

select a.NAME as ARTICLE_NAME,a.CODE,c.NAME as CATEGORY_NAME from T_ARTICLE as a inner join T_CATEGORY as c on a.CATEGORY_ID = c.ID

i do serverSorting because the table have more rows (300.000). When i click on TH CATEGORY_NAME the script run a ajax call to page.php and passes through POST the sort array with the FIELD CATEGORY_NAME, but the query is wrong because in ORDER clause i don't insert CATEGORY_NAME, i would insert c.NAME.
Is it possible to define the name of the fields that i will use in the sort and filter?

Thanks

Grid

asked on 19 Mar 2012

1 answer

47 views

With IE, a XML datasource with space values show 'undefined'

Hello,
I use a Grid with a XML datasource. When some elements in the xml are ' ' instead of strings, the corresponding cell shows 'undefined' with IE. The same site with Firefox shows the space character.
Is there a workaround in the grid definition or in the XML ?
Regards

Grid

answered on 19 Mar 2012

3 answers

238 views

Cannot bind ListView to web service.

I have been trying many ways to bind the listview to an ASP.Net .asmx web service. I have attached the code for both the consuming page and the web service.

I have tried many different ways to return the data from the web service and event tried to just return a string array. The listview works if you bind it to the static flatData var.

Any help or examples would be great!

R

Client side:

</

head>

<

body>

MobileXus Header

</div>

iOS MobileXus Footer

</div>

</ul>

</div>

var flatData = ["Sashimi salad", "Chirashi sushi", "Seaweed salad", "Edamame"];

function mobileListViewDataBindInitFlat() {

$(

"#listview").kendoMobileListView({ dataSource: flatData });

}

var deviceJDS = new kendo.data.DataSource({

transport: {

read: {

contentType:

"application/json; charset=utf-8",

type:

"POST",

data:

"{}",

dataType:

"json",

url:

"WebServices/TestService.asmx/GetList"

}

});

var app = new kendo.mobile.Application();

</script>

</form>

</

body>

</

html>

Web service:

///

///

Summary description for TestService

///

</summary>

[

WebService(Namespace = "http://tempuri.org/")]

[

WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.

[System.Web.Script.Services.

ScriptService]

public

class TestService : System.Web.Services.WebService {

public TestService () {

//Uncomment the following line if using designed components

//InitializeComponent();

}

[

WebMethod]

[

ScriptMethod(ResponseFormat = ResponseFormat.Json)]

public Array GetList() {

DeviceSvc.

Device dsvc = new DeviceSvc.Device();

DeviceSvc.

Device1[] devices = null;

ArrayList devlist = new ArrayList();

devices = dsvc.SelectAll();

foreach (DeviceSvc.Device1 d in devices)

{

devlist.Add(d.Name);

}

string[] data = { "Rod", "Karen", "Jamie", "Christopher" };

return data;

}

ListView (Mobile)

answered on 19 Mar 2012

6 answers

986 views

Problem when filtering with date..

I m having a kendo grid in my page. I need to search the data from the controller using external search. So i set the serverFiltering of datasource to true for that. Its working wonderfully. But I need to enable Grid filtering also. So I set the filterable to true. Here comes the problem the grid's bult in grid filtering functionality is not working when I set the server filtering to true. Its always post to the controller. When I set the server filtering to false its working. Here's my datasource

ds= new kendo.data.DataSource({
                transport: {
                    read: {
                        url: 'method',
                        dataType: "json",
                        type: "POST",
                        contentType: "application/json; charset=utf-8"
                    },
                    parameterMap: function (options) {                    
                        return JSON.stringify({ filter: options });
                    }
                },
                schema: {
                    model: {
                        fields: {
                            Id: { type: "number" },
                            Name: { type: "string" },
                            Age: { type: "number" },
                            BeginDate: { type: "date" },
                            EndDate: { type: "date" },
                            Mode: { type: "string" }
                        }
                    }
                }
            });

Also when I set the serverfiltering to false. Its working fine. But for both the date fields its throwing format error when filter by dates.
In my grid's row template I am showing the date by format it by.

 <td># if(EndDate!=null){# #= kendo.toString(toDate(EndDate), "MM/dd/yyyy")#  #} else {# ${EndDate}#}#</td>

Can anyone figure this out???

Grid

answered on 19 Mar 2012

1 answer

189 views

Where to find localization resources?

Hi,

I downloaded from my premium telerik account, the kendoUI library.

But I can't find localization resources in the download or anywhere else?

Where is it?

Something like kendo.culture.fr-FR.js ?

Thank you!

Globalization

answered on 19 Mar 2012

0 answers

63 views

Dynamic Window interacting with an embedded Grid

How do I connect the selected data of a line to the data of a window? (see image).

Thanks,
Mike

Grid

asked on 19 Mar 2012

0 answers

292 views

kendo.parseFloat() ??

Hi Admin,

How do we ensure that kendo.parseFloat()/parseIntt()
method able to parse given formatted input?
Suppose it user gives the string instead of formatted value then how we recognize that its invalid input give by user and kendo.parseFloat()/parseIntt()
will not be able to parse it?

kendo.parseFloat()/parseIntt()
will throw any exception in javascript in case of invalid input

Globalization

asked on 19 Mar 2012

1 answer

192 views

[Solved] Ajax load event?

Is there an event to know when the content of a window (when loading content through Ajax) has finished loading?

Kind regards,

Window

answered on 19 Mar 2012

1 answer

76 views

[Solved] Broken chart with mutliple charts of different sizes (FF)

I'm trying to have mutliple small charts on a page and then when the user clicks a button, open a big chart in a Kendo Window. There seems to be a problem when I open the big chart: the SVG elements don't appear correctly. It seems to be related to rendering a small chart first then trying to render a larger one. If I set all the charts to the same size it's fine and if I change the big chart to a Pie it seems fine too.

I've got a fiddle showing the problem. Click the Go link to see; both charts should be identical.

Problem in Firefox 11. (Seems to work in IE8)

http://jsfiddle.net/hb7Kt/

Charts

answered on 19 Mar 2012

1 answer

139 views

cancel action in listview

Hi,
I have a listview that contains anchors in a template.

template: "<a href='details.aspx?id=${data.id}'>${data.subject}</a>"

I know that you can trap the "click" event & I want to be able to trap the event to see if the id event is -1 and stop the transfer.

Is there a "canel" property or is there another way to stop the transfer to another page on a certain condition?

regards
Roger

ListView

answered on 19 Mar 2012