The available colModel properties are listed here, in alphabetic order. The only required property is name. The colModel options can be get or set using getColProp and setColProp 1) methods - See methods.

Property

Type

Description

Default

align

string

Defines the alignment of the cell in the Body layer, not in header cell. Possible values: left, center, right.

left

cellattr

function

This function add attributes to the cell during the creation of the data - i.e dynamically. By example all valid attributes for the table cell can be used or a style attribute with different properties. The function should return string. Parameters passed to this function are: rowId - the id of the row val - the value which will be added in the cell rawObject - the raw object of the data row - i.e if datatype is json - array, if datatype is xml xml node. cm - all the properties of this column listed in the colModel rdata - the data row which will be inserted in the row. This parameter is array of type name:value, where name is the name in colModel

null

classes

string

This option allow to add classes to the column. If more than one class will be used a space should be set. By example classes:'class1 class2' will set a class1 and class2 to every cell on that column. In the grid css there is a predefined class ui-ellipsis which allow to attach ellipsis to a particular row. Also this will work in FireFox too.

empty string

datefmt

string

Governs format of sorttype:date (when datetype is set to local) and editrules {date:true} fields. Determines the expected date format for that column. Uses a PHP-like date formatting. Currently ”/”, ”-”, and ”.” are supported as date separators. Valid formats are:
y,Y,yyyy for four digits year
YY, yy for two digits year
m,mm for months
d,dd for days.
See Array Data

ISO Date (Y-m-d)

defval

string

The default value for the search field. This option is used only in Custom Searching and will be set as initial search.

empty

editable

boolean

Defines if the field is editable. This option is used in cell, inline and form modules. See editing

Defines the edit type for inline and form editing Possible values: text, textarea, select, checkbox, password, button, image and file. See also editing

text

firstsortorder

string

If set to asc or desc, the column will be sorted in that direction on first sort.Subsequent sorts of the column will toggle as usual

null

fixed

boolean

If set to true this option does not allow recalculation of the width of the column if shrinkToFit option is set to true. Also the width does not change if a setGridWidth method is used to change the grid width.

Format options can be defined for particular columns, overwriting the defaults from the language file. See Formatter for more details.

none

formatter

mixed

The predefined types (string) or custom function name that controls the format of this field. See Formatter for more details.

none

frozen

boolean

If set to true determines that this column will be frozen after calling the setFrozenColumns method

false

hidedlg

boolean

If set to true this column will not appear in the modal dialog where users can choose which columns to show or hide. See Show/Hide Columns.

false

hidden

boolean

Defines if this column is hidden at initialization.

false

index

string

Set the index name when sorting. Passed as sidx parameter.

empty string

jsonmap

string

Defines the json mapping for the column in the incoming json string. See Retrieving Data

none

key

boolean

Overwrite the id (defined in readers) from server. Can be set as id for the unique row id. Only one column can have this property. This option have higher priority as those from the readers. If there are more than one key set the grid finds the first one and the second is ignored.

false

label

string

When colNames array is empty, defines the heading for this column. If both the colNames array and this setting are empty, the heading for this column comes from the name property.

none

name

string

Set the unique name in the grid for the column. This property is required. As well as other words used as property/event names, the reserved words (which cannot be used for names) include subgrid, cb and rn.

Custom function to make custom sorting when datatype is local. Three parameters a, b and direction are passed. The a and b parameters are values to be compared direction is numeric 1 and -1 for ascending and descending order. The function should return 1, -1 or 0

null

sorttype

mixed

Used when datatype is local. Defines the type of the column for appropriate sorting.Possible values:
int/integer - for sorting integer
float/number/currency - for sorting decimal numbers
date - for sorting date
text - for text sorting
function - defines a custom function for sorting. To this function we pass the value to be sorted and it should return a value too.
See Array Data

Valid only in Custom Searching and edittype : 'select' and describes the url from where we can get already-constructed select element

empty string

template

object

Set of valid properties for the colModel. This option can be used if you want to overwrite a lot of default values in the column model with easy. See cmTemplate in grid options

null

title

boolean

If this option is false the title is not displayed in that column when we hover a cell with the mouse

true

width

number

Set the initial width of the column, in pixels. This value currently can not be set as percentage

150

xmlmap

string

Defines the xml mapping for the column in the incomming xml file. Use a CSS specification for this See Retrieving Data

none

unformat

function

Custom function to “unformat” a value of the cell when used in editing See Custom Formatter. (Unformat is also called during sort operations. The value returned by unformat is the value compared during the sort.)

null

viewable

boolean

This option is valid only when viewGridRow method is activated. When the option is set to false the column does not appear in view Form

true

As mentioned above the options in colModel can be get or sfunction are: rowId - the id of the row
val - the value which will be added in the cell
rawObject - the raw object of the data row - i.e if datatype is json - array, if datatype is xml xml node.
cm - all the properties of this coumn listed in the colModel
rdata - the data row which will be inserted in the row. This parameter is array of type name:value, wher name is the name in colModel et usitemplateng the methods getColProp and setColProp. Below are options which can not be changed dynamically when the grid is constructed (If changed they do not have effect or will cause the grid errors). For some of these options there are methods available to change the value.

name

width

resizable

label (method avail.)

1)
Some methods require that you include in your download the so named custom module

Hey I have had the same problem, but I decided to rearranged my JSON so their are no subObjects. But I can see how this method would not always be a valid solution. I think your name.replace(/\./g, “_”) is brilliant and if it doesn't have any side effects then it should be implemented by Jqgrid.

You should bring it to their attention. Nice work.

Dave.

Kandeeban, 2012/01/02 20:05

Hi all,

I have a question can we have multiple file upload in grid?

laurence, 2012/01/30 00:05

Hello,

I've got a problem with my grid. I need to tape phonetic character in my input column. My JSP is encoding with UTF-8 and when I load my data the display is good. The problem is when I tape my data.
I've had

When I save my record the character aren't saved in the good charset !
Any idea ?
Thank.
Lolo1367

Patricia, 2012/03/09 16:10

Hello,
I need to include quite long table headers, so I would rather them being showed in two lines. Is there any option to do this? Thanks

Tsahi, 2013/02/13 16:41

you can override (or change) the original CSS to allow word wraping. look at lines 14, 15 and 20 in ui.jqgrid.css.

jsnbill, 2012/06/27 11:32

Hi, there are two columns(column1 and column2) in jqgrid, the columns' edittype are select. I want to do this: when I select column1 , the content of column2 is changing . How can I do? thanks.

dorian cuentas, 2012/07/05 16:53

Hy all, is there a way to specify tablemodel from json object…
i trying to define a java class that should have all properties of a table and use that “tablemodel” to define a grid, it could be done?

Jelena Antic, 2013/02/26 16:03

Hello everyone!
Is there any option to set a class for a header columns?
I set classes for all my grid columns, but that afects only body layer (not header layer), and now column width doesnt match with those columns in header.

Later, I would like them to follow eachother when I resize them manualy (if possible).