jQuery Grid Plugin - jqGrid - Topic: editoptions dynamicly load from database

majkel on editoptions dynamicly load from database

Tue, 24 Feb 2009 16:49:51 +0200

OK it works.I made something like this:

...

userdata: 'userdata',
loadComplete: function(){
select_options = jQuery('#grid_table').getUserData();
$("#grid_table").setColProp('sklep',{'editoptions': {'value':select_options.sklep}});
},

...

majkel on editoptions dynamicly load from database

Tue, 17 Feb 2009 07:43:05 +0200

Data from serwer is presented in post at 19:59 08/02/2009 in this topic:

“userData”:

{”sklep”:”1:real;2:lidl;3:auchan;4:media”}

JQGrid can't get userData from serwer.

select_options2 = $('#grid_table').getGridParam(”userData”);

if I replace above line(testing) with this:
select_options2 = {”sklep”:”1:real;2:lidl;3:auchan;4:media”};

everything is ok, but select options are just static text.

If I alert(select_options2.sklep); in case of dynamic I get a message:

undefined

If I alert(select_options2.sklep); in case of static(test) I get a message:

1:real;2:lidl;3:auchan;4:media

So the dead point is marked red

I've try olso such a construction:

select_options2 = jQuery('#grid_table').getUserData();

tony on editoptions dynamicly load from database

Mon, 16 Feb 2009 08:57:38 +0200

What does not work? How look your data. Remember the last item should not end with ; - this will break the select. To make a test just put a string and see what is it - I mean

loadComplete : function () {

$("#mygrid").setColProp('myname',editoptions:{'1:one;2:two'});

}

Regards

Tony

majkel on editoptions dynamicly load from database

Wed, 11 Feb 2009 10:40:53 +0200

It doesn't work so any ideas what is wrong? I am stuck

Majkel

majkel on editoptions dynamicly load from database

Sun, 08 Feb 2009 20:02:12 +0200

PS.

We can test part of code and uncoment the following code

// select_options2 = {”sklep”:”1:real;2:lidl;3:auchan;4:media”};

and it works.

majkel on editoptions dynamicly load from database

Sun, 08 Feb 2009 19:59:38 +0200

I've added the following to jqgrid

jQuery("#grid_table").jqGrid({

....

userdata: 'userData',
loadComplete: function(){
select_options2 = $('#grid_table').getGridParam("userData");
// select_options2 = {"sklep":"1:real;2:lidl;3:auchan;4:media"};
var op_sk = select_options2.sklep;
alert(op_sk);
gt2 = {'editoptions': {'value':op_sk}};

$("#grid_table").setColProp('sklep',gt2);

},
...

There is some error when I call getGridParam. Probably it doesn't get data from server properly although the JSON is sended and looks like this:

....

{"page":null,

"total":497,

"records":"497",

"rows":

[{"id_produkt":"1","cell":["1","frytki","3.49","0","1","2008-11-02","lidl","spo?ywcza"]}],

"userData":

{"sklep":"1:real;2:lidl;3:auchan;4:media"}

}

Any ideas what is wrong?

Majkel

pequesalta on editoptions dynamicly load from database

Mon, 15 Dec 2008 06:49:38 +0200

Could you write an example?

This cuestions is the most asked in the forum.

Thanks for all.

majkel on editoptions dynamicly load from database

Fri, 12 Dec 2008 06:29:08 +0200

Thanx

tony on editoptions dynamicly load from database

Fri, 12 Dec 2008 04:50:28 +0200

Hello,

One possible solution is to use userdata array and setColProp method combined with loadComplete event.

Regards

Tony

majkel on editoptions dynamicly load from database

Wed, 10 Dec 2008 11:31:50 +0200

How to dynamicly load 'editoptions'(select field) with data from database within Column MOdel?

Greetings

Majkel