Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
wiki:pivotsettings [2014/02/16 14:54] tony |
wiki:pivotsettings [2017/12/09 14:53] admin |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| - | jqPivotGrid has the following calling convention | + | jqPivotGrid has the following calling convention. |
| <code javascript> | <code javascript> | ||
| Line 129: | Line 129: | ||
| === yDimension === | === yDimension === | ||
| + | The values build dynamically columns depend on the data source.\\ | ||
| + | Example: | ||
| + | \\ | ||
| + | <code javascript> | ||
| + | yDimension : [ | ||
| + | { | ||
| + | dataName: 'Country', | ||
| + | converter: function(Value, xValues) { | ||
| + | return 'Total Countryies'; | ||
| + | } | ||
| + | },{ | ||
| + | dataName: 'Country' | ||
| + | } | ||
| + | ] | ||
| + | </code> | ||
| + | |||
| + | Possible options are:\\ | ||
| + | **dataName** is a cell from data which build the column. The value of this should correspond to a name in the data source | ||
| + | \\ | ||
| + | **converter** is function which can convert the source cell data and return new value. The parameters passed to this functions are:\\ | ||
| + | * Value - the value | ||
| + | * xValues - the "static" data from the row | ||
| + | |||
| + | ==== gridoptions ==== | ||
| + | |||
| + | These options are [[ options | options of the grid]]. You can set any of them. | ||
| + | |||
| + | ==== ajaxoptions ==== | ||
| + | |||
| + | Additionally when the data is obtained via ajax we can set additional [[https://api.jquery.com/jQuery.ajax/ |ajax options]].\\ | ||
| + | Note that currently we support only JSON data, so some ajax options like //dataType// is not recommended to be changed. Again with this we have a //reader// option which defines the root data. By example if the data that is returned from the server has the following structure: | ||
| + | |||
| + | <code javascript> | ||
| + | {"root":[ | ||
| + | {"CategoryName":"Beverages","ProductName":"Steeleye Stout","Country":"UK","Price":"1008.0000","Quantity":"65"}, | ||
| + | {"CategoryName":"Beverages","ProductName":"Laughing Lumberjack Lager","Country":"USA","Price":"140.0000","Quantity":"10"}, | ||
| + | {"CategoryName":"Beverages","ProductName":"Lakkalik","Country":"USA","Price":"2160.0000","Quantity":"120"}, | ||
| + | ... | ||
| + | ]} | ||
| + | </code> | ||
| + | |||
| + | In this case the setting should be like this | ||
| + | |||
| + | <code javascript> | ||
| + | jQuery("#grid").jqGrid('jqPivot', | ||
| + | "jsondataurl.json", | ||
| + | {pivotoptions}, | ||
| + | {gridoptions}, | ||
| + | { | ||
| + | reader:"root" | ||
| + | } | ||
| + | ); | ||
| + | </code> | ||
