jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

How to getCell value from custom formatter

Tags: getCell custom formatter

17/09/2010
06:24

msshushu

Member

Members

Forum Posts: 15

Member Since:
13/01/2010

Offline

Hi there,

I am trying to determine if this is even possible. Been agonizing over this for hours. I have a custom formatter as follows:

Basically, I don't want to keep having to reference an index for the columns, because I'm frequently being asked to change column orders and I sometimes forget to update the custom formatters and it really messes things up. Is there anyway I can use either rowObject or some other method like getCell to access a given column?

I've tried this and it always returns false, I have no idea what false even means.

var rowInfo = $("#backlog").jqGrid('getCell', options.rowId, 'Title');

alert(rowInfo);

Is what I'm trying to do even possible?

17/09/2010
14:28

OlegK

Germany

Member

Members

Forum Posts: 1255

Member Since:
10/08/2009

Offline

You should implement custom unformatter always together with the custom formatter. It seems to me that it will solve your problem.

Best regards
Oleg

17/09/2010
21:39

msshushu

Member

Members

Forum Posts: 15

Member Since:
13/01/2010

Offline

Hi Oleg,

I appreciate the response, but I'm not sure how the unformatter will solve my problem. Basically whether I use an unformatter or a formatter, how do i get another cell's value from within the formatter? the options object returns the information for the column it's applied to.

So if i apply a formatter to the Title column in the colModel, how do I access let's say the Manager cell?

Unless I'm not understanding something, is there someway that the options object contains the info I need?

17/09/2010
22:34

OlegK

Germany

Member

Members

Forum Posts: 1255

Member Since:
10/08/2009

Offline

The function getCell use formatter to get the value. The formatter test whether the unformatter are defined (whether unformat exist) and if it is defined it use the value returned by your custom unformatter. So just try to do what I suggested. It should work.

Regards
Oleg

23/08/2012
02:29

mb_iceman

New Member

Members

Forum Posts: 1

Member Since:
23/08/2012

Offline

msshushu,

I don't think OlegK understands what you're asking for. I've encountered the same issue as you too.

My solution was to generate my own map of field name to column index as part of initialising my grid.

Rough JS psuedocode:

grid = jQuery("#grid").jqGrid({colModel:myColModelCallback });

myColModelCallback {

colModel = [{name:'col1'},{name:'col2'}];

global var colModelMapping = {};

colModel.each(function(index,value) {

colModelMapping[value.name] = index;

});

return colModel;

}

So after the grid is initialised but before it has applied the formatters I can now use this global variable colModelMapping like so:

function myFormatter(cellvalue, options, rowObject) {

console.log('Value of col2 is: ' + rowObject[colModelMapping['col2']]);

}

Hope this helps, its not an ideal situation as far as I'm concerned, jqGrid should really let us get to other cell values in a much more robust manner.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
18 Guest(s)

Currently Browsing this Page:
1 Guest(s)