Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
wiki:grouping [2012/12/23 06:01] dlwiii Typos |
wiki:grouping [2017/12/09 14:51] (current) admin |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| Grouping is a way to group data by diffrent criteria. jqGrid currently supports one level of grouping. | Grouping is a way to group data by diffrent criteria. jqGrid currently supports one level of grouping. | ||
| - | The simple way to group in jqGrid is to enable grouping with the grid option **grouping:true** and define a field name on which grouping occurs. The name should correspond to the name in colModel | + | The simple way to group in jqGrid is to enable grouping with the grid option **grouping:true** and define a field name on which grouping occurs. The name should correspond to the name in colModel. |
| The definition is done with array //groupField// which is a part of another grid option **groupingView**. | The definition is done with array //groupField// which is a part of another grid option **groupingView**. | ||
| Line 72: | Line 72: | ||
| |groupColumnShow|array|Show/Hide the column on which we group. The value here should be a boolean true/false for the group level. If the grouping is enabled we set this value to true. |empty| | |groupColumnShow|array|Show/Hide the column on which we group. The value here should be a boolean true/false for the group level. If the grouping is enabled we set this value to true. |empty| | ||
| |groupSummary|array|Enable or disable the summary (footer) row of the current group level. If grouping is set the default value for the group is false.|empty| | |groupSummary|array|Enable or disable the summary (footer) row of the current group level. If grouping is set the default value for the group is false.|empty| | ||
| + | |groupSummaryPos|array| Set the position of the summary row at current group level. Possible values - header or footer. If set to header the summary values are placed at the same row where the group values is. If footer is set additional row at end of the group level is builded and the summary values are placed here|footer| | ||
| + | |hideFirstGroupCol|boolean| If set to true the values at first column are replaced with empty ones so that we have a pretty view. This usually is set ih the first column is a group column|false| | ||
| |showSummaryOnHide|boolean|Show or hide the summary (footer) row when we collapse the group.|false| | |showSummaryOnHide|boolean|Show or hide the summary (footer) row when we collapse the group.|false| | ||
| |groupCollapse|boolean|Defines if the initially the grid should show or hide the detailed rows of the group.|false| | |groupCollapse|boolean|Defines if the initially the grid should show or hide the detailed rows of the group.|false| | ||
| |plusicon|string|Set the icon from jQuery UI Theme Roller that will be used if the grouped row is collapsed|ui-icon-circlesmall-plus| | |plusicon|string|Set the icon from jQuery UI Theme Roller that will be used if the grouped row is collapsed|ui-icon-circlesmall-plus| | ||
| |minusicon|string|Set the icon from jQuery UI Theme Roller that will be used if the grouped row is expanded|ui-icon-circlesmall-minus| | |minusicon|string|Set the icon from jQuery UI Theme Roller that will be used if the grouped row is expanded|ui-icon-circlesmall-minus| | ||
| + | |isInTheSameGroup| array| The elements of the array correspond to the number of the groups. Every element of this array is a function which should return true or false. In case if it return false the element will be added in the groupt. Parameters passed to this functiona are : previous value, current value, group index, group object| null | | ||
| + | |formatDisplayField| array| The elements of the array correspond to the number of the groups.Every element should return a value which will be display grouped value. Parameters passed to this function are: current value, source value, colModel option, group index and group object.|null| | ||
| ===== colModel Options ===== | ===== colModel Options ===== | ||
| Additionally if the group summary footer row is enabled we use a option in column model to set the type of the summary field. | Additionally if the group summary footer row is enabled we use a option in column model to set the type of the summary field. | ||
| - | We add two options in colModel and it name is **summaryType** and **summaryTpl**. | + | We add two options in colModel and it name is **summaryType**, **summaryTpl**, **summaryRound** and **summaryRoundType**. |
| === summaryType === | === summaryType === | ||
| Line 129: | Line 133: | ||
| ===summaryTpl=== | ===summaryTpl=== | ||
| This option acts as template which can be used in the summary footer row. By default its value is defined as {0} - which means that this will print the summary value. The parameter can contain any valid HTML code. | This option acts as template which can be used in the summary footer row. By default its value is defined as {0} - which means that this will print the summary value. The parameter can contain any valid HTML code. | ||
| + | |||
| + | ===summaryRound=== | ||
| + | <code javascript> | ||
| + | |||
| + | {..., summaryRound: number_of_digits, ... } | ||
| + | </code> | ||
| + | |||
| + | By default this parameter is not defined in colModel when grouping is on.\\ | ||
| + | The number_of_digits by default is not defined.\\ | ||
| + | This options determines the length of the remaining part after the decimal point. | ||
| + | |||
| + | ===summaryRoundType=== | ||
| + | <code javascript> | ||
| + | { summaryRoundType: 'round' | 'fixed' } | ||
| + | </code> | ||
| + | |||
| + | This parameter works only if the //summaryRound// is defined. | ||
| + | |||
| + | This is rounding method selector. | ||
| + | |||
| + | Parameter //round// means 'just round it and do not keep trailing zeroes'. //fixed// means 'round it and keep the given fixed number of digits even zeroes'. | ||
| + | |||
| + | The default option is set to round | ||
| ===== Methods ===== | ===== Methods ===== | ||
