jQuery Grid Plugin - jqGrid - Topic: 'Virtual' data mode

tony on 'Virtual' data mode

Mon, 09 Dec 2013 11:55:51 +0200

Hello,

Of course the way I posted this will not work. It was my mistake. Sorry.

The way to do it is to define a variable and change the variable within the function.

Here is a example

Regards

bosko on 'Virtual' data mode

Mon, 09 Dec 2013 11:11:04 +0200

Of course. I didn't try to do that. I just tried to use function for name through variable as you suggested but result is the same - sort will not work in that case.

tony on 'Virtual' data mode

Mon, 09 Dec 2013 11:04:33 +0200

Hello,

I will say it other way- the names in colModel can not be changed dynamically.

With other words if you want to change the name by condition you will need to unload and load the grid again with the new name in colModel.

See docs for methods how unload the grid.

Regards

bosko on 'Virtual' data mode

Mon, 09 Dec 2013 10:47:27 +0200

I agree with you that simple solutions are the best one in most cases but unfortunatelly it seems this is not the case here. This solution also cross my mind and I tried it but with same result.

Looks like grid cannot work in 'virtual mode'. Problem is in a way header cell is constructed. Namely for element id it uses 'name' value from colModel which returns function code even if it is used in proposed way.

<th id='"+ts.p.id+"_"+ts.p.colModel[i].name....

Best regards,

Bosko

tony on 'Virtual' data mode

Sat, 07 Dec 2013 12:29:10 +0200

Hello,

Looking into the code I see there are some things which cause this not to work.

In most cases simple solutions are best one.

You can

var myname = myNameFunction(obj);

…

..jqGrid({

…

colModel : [

...

{ name : myname ,....},

...

…

});

where myNameFunction is the function defined from your post in colModel

Regards

bosko on 'Virtual' data mode

Fri, 06 Dec 2013 17:32:31 +0200

Hello,

I thought also that index property might help but it didn't. Seems like problem (at least for sorting) is in fact that when function is used for column name column id is set to source of function (actually substring of it). Later on in click handler there is comparision:

this.name === tid

which compares name (function in this case) and id which is string equal to substring of function source. Reproducing this is easy. Just in any sample put name to be function. Part of my code is:

colModel: [

{ name: function(obj) {

if (total) {

return obj.values.weight;

} else {

return obj.values.weight * totalNumber;

}

}, index: "calories", label: "Weight", width: 78, align: "right", firstsortorder: 'desc', sorttype: "float" }

]

Best regards,

Bosko

tony on 'Virtual' data mode

Fri, 06 Dec 2013 16:36:44 +0200

Hello,

A simple source code will be greatly appretiated, we can not help in most cases if no test case is provided.

I'm not sure if this can work, but maybe you will need to set a index property of this column in colModel.

See docs

Kind Regards

bosko on 'Virtual' data mode

Fri, 06 Dec 2013 13:40:23 +0200

I'm using jqGrid with local data and values that should be displayed in the cells depend on couple flags that can be set on the page. Simple example would be column called 'weight' which displays unit weight but if 'Total value' check box is checked on the page than in value displayed in this cell should be calculated value base on several other parameters (i.e. num_items * weight). I managed to do this by setting 'name' option in colModel to function which returns either row or calculated value. However in this case sorting by that column is not working.

Is there any way I can use jqGrid in this 'virtual data' mode where for each column instead of direct mapping to data custom function can be used?

Regards,

Bosko