ColModel is one of the most important properties in jqGrid.
Usage:
Java code:
jQuery("#gridid").jqGrid({
...
colModel: [ {name:'name1', index:'index1'...}, {...}, ... ],
..
});
Property Data type Note The default value Align String Defines cell alignment; Optional values: left, center, right. Left Classes String Sets the CSS for the column. Multiple classes are separated by Spaces such as ‘class1 class2’. The default CSS property of the table is ui-ellipsis&sponge; The empty string Datefmt String Format the date column.” / ”, ”-”, and ”. “are valid date delimiters. Y,y,yyyy year YY, YY month m,mm for monthsd,dd day. ISO Date (Y -m - d) Defval String The default value of the query field & PI; Empty Editable Boolean Whether the cell is editable False Editoptions Array Some properties & NBSP that are set when editing a column; The empty array Editrules Array Some additional property Settings & NBSP for editable cells; The empty array Edittype String Types that can be edited. Optional values: text, textarea, select, checkbox, password, button, image and file. Text Fixed Boolean Whether the column width should be fixed immutable & cake; False Formoptions Array Property Settings & NBSP when editing the form; Empty Formatoptions Array Settings for formatting certain columns None Formatter Mixed Function name or type & PI set when formatting a column None Hidedlg Boolean Whether to show or hide this column & cake; False Hidden Boolean Whether to hide this column & NBSP when initializing the table; False Index String Define the index of the sort field name when sorting, with the parameter sidx ; The empty string Jsonmap String Defines the returned json data map None Key Boolean When there is no id in the data returned from the server side, use this as the only rowid, with only one id attribute by default False Label String This value is used as the display name for the column if colNames are empty, and the name value & NBSP if none is set; None Name String Required entries, names of table columns, all keywords, reserved words cannot be used as names including subgrid, cb and rn. Required Resizable Boolean Whether it can be resizable& compensated; True Search Boolean In search mode, define whether this column can be used as a search column & PI; True Searchoptions Array Set the search parameter Empty Sortable Boolean Is it sortable True Sorttype String Used when datatype is local to define the type of the search column, optional value: int/integer - sort to integer float/number/ currency-sort number date - sort date text - sort text & PI; Text Stype String Defines the type of the search element Text Surl String Url when searching for data; The empty string Width Number The default column width can only be a pixel value, not a percentage. 150 Xmlmap String Defines the mapping between the current column and the returned XML data None Unformat Function ‘unformat’ cell value Null
Add in source
editurl:'index.php?do=do_edit',
addurl:'index.php?do=do_add',
datatype: 'xml',
mtype: 'GET',
colNames:['ID', ' The name of the task ', ' Belongs to the class '
colModel :[
{name:'taskid', index:'taskid', width:100,align:'center',searchoptions:{sopt:['eq','ne','lt','le','gt','ge']}},
{name:'taskname', index:'taskname', width:100, align:'center',editable:true},
{name:'classid', index:'classid', width:100, align:'center',editable:true,edittype:'select',editoptions: {
value: '1: The transaction ;2: The transaction '},editselected:'classid' },
],
The addition after adding editable is also effective;
**search **Eq is equal to (=). Ne is not equal to (< > ) Lt is less than (< ) Le is less than or equal to (< =) Gt is greater than (> ) Ge is greater than or equal to (> =) Bw starts with (LIKE val%) Bn does not start at (not like val%) In (in ()) (not in ()) Ew ends with (LIKE %val) En does not end with Cn contains (LIKE %val%) Do not include the nc