tony.
stapelchipHello,
There is an index error with three or more yDimensions.
I get the following error:
”Uncaught TypeError: Cannot read property ‘name’ of undefined”
in this line:
headers[items.level-1].groupHeaders[collen-1].startColumnName = columns[colpos].name;
Â
For example then colpos is 90 but columns have only 86 entries
tonyHello,
There was some fixes in the GitHub regarding pivot.
Can you please post a simple test case, since I can not reproduce this problem.
Thank you.
Kind Regards
stapelchipHello tony,
i want to try it with the latest GitHub Source but if i run the gradlew script the output file “jquery.jgGrid.js” is twice as big as my original file (26515 Lines).Â
And with this file i get errors even with a simple table.
If you can tell me how to fix this i will test it again and if necessary i provide a test case.
Thank you 
stapelchipHello Tony,
the following is a simple non working example:
Â
var grid = jQuery("#table").jqGrid('jqPivot', "data.json"+window.location.search, // pivot options { xDimension : [ { formatter: urlFmatter, formatoptions:{keyAttribute:'browser'}, dataName: 'browser', label: 'Browser', align: 'center' }, ], yDimension : [ {dataName: 'date_visit.year', label: 'Year'}, {dataName: 'date_visit.quarter', label: 'Quarter'}, {dataName: 'date_visit.month', label: 'Month'}, ], aggregates : [ {member: 'pageviews_sum', aggregator : 'sum', label:'Sum of pageviews', summaryType: 'sum'} ], rowTotals: false, colTotals : false }, // grid options { groupingView : { hideFirstGroupCol : true }, gridview: false, rowNum : 10, pager: "#pager", caption: 'Website / Visits' }, { reader : 'cells' } );
With sample data:
{ "summary": {}, "remainder": {}, "cells": [ { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 1, "pageviews_sum": 233, "browser": "Chrome" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 2, "pageviews_sum": 208, "browser": "Chrome" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 3, "pageviews_sum": 206, "browser": "Chrome" }, { "date_visit.quarter": 2, "date_visit.year": 2012, "date_visit.month": 4, "pageviews_sum": 178, "browser": "Chrome" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 1, "pageviews_sum": 172, "browser": "Firefox" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 2, "pageviews_sum": 127, "browser": "Firefox" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 3, "pageviews_sum": 123, "browser": "Firefox" }, { "date_visit.quarter": 2, "date_visit.year": 2012, "date_visit.month": 4, "pageviews_sum": 136, "browser": "Firefox" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 1, "pageviews_sum": 70, "browser": "Lynx" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 2, "pageviews_sum": 46, "browser": "Lynx" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 3, "pageviews_sum": 79, "browser": "Lynx" }, { "date_visit.quarter": 2, "date_visit.year": 2012, "date_visit.month": 4, "pageviews_sum": 99, "browser": "Lynx" } ], "aggregates": [ "pageviews_sum" ], "cell": [ { "type": "set", "dimension": "date_visit", "hierarchy": "monthly", "level_depth": 3, "invert": false, "hidden": false, "paths": [ [ "2012", "1", "1" ], [ "2012", "1", "2" ], [ "2012", "1", "3" ], [ "2012", "2", "4" ] ] } ], "levels": { "date_visit": [ "year", "quarter", "month" ], "browser": [ "browser" ] }}
With this code you will receive the error message:
Uncaught TypeError: Cannot read property ‘name’ of undefined
If you remove one month in the “cells” array, there is no error but the pageviews_sum values in the table are wrong.
It would be very nice if you could run my example.
tonyHello,
Thanks for the test case. With the last code this works fine for me except that there was another bug which I will see how to fix.
I have put the new script in our demo site – you can see the demo index and load the script or download it.
To work your code you should put a converter function.It should look like this:
Kind Regards
stapelchipHello Tony,
thank you for your help!
Do you mean this file from the demo site?Â
http://trirand.com/blog/jqgrid/js/jquery.jqGrid.js
Thats strange because i get the same error with this file.
But it breaks with more data (The data above was only a part of my testdata)
Can you please test it with my full Response:
{
“summary”: {},
“remainder”: {},
“cells”: [
{
“pageviews_sum”: 233,
“pageviews_avg”: 10.590909090909092,
“date_visit.year”: 2012,
“date_visit.month”: 1,
“pageviews_max”: 18,
“date_visit.quarter”: 1,
“browser”: “Chrome”
},
{
“pageviews_sum”: 208,
“pageviews_avg”: 9.043478260869565,
“date_visit.year”: 2012,
“date_visit.month”: 2,
“pageviews_max”: 19,
“date_visit.quarter”: 1,
“browser”: “Chrome”
},
{
“pageviews_sum”: 206,
“pageviews_avg”: 9.363636363636363,
“date_visit.year”: 2012,
“date_visit.month”: 3,
“pageviews_max”: 28,
“date_visit.quarter”: 1,
“browser”: “Chrome”
},
{
“pageviews_sum”: 178,
“pageviews_avg”: 9.368421052631579,
“date_visit.year”: 2012,
“date_visit.month”: 4,
“pageviews_max”: 20,
“date_visit.quarter”: 2,
“browser”: “Chrome”
},
{
“pageviews_sum”: 118,
“pageviews_avg”: 6.9411764705882355,
“date_visit.year”: 2012,
“date_visit.month”: 5,
“pageviews_max”: 15,
“date_visit.quarter”: 2,
“browser”: “Chrome”
},
{
“pageviews_sum”: 145,
“pageviews_avg”: 7.25,
“date_visit.year”: 2012,
“date_visit.month”: 6,
“pageviews_max”: 16,
“date_visit.quarter”: 2,
“browser”: “Chrome”
},
{
“pageviews_sum”: 170,
“pageviews_avg”: 8.947368421052632,
“date_visit.year”: 2012,
“date_visit.month”: 7,
“pageviews_max”: 20,
“date_visit.quarter”: 3,
“browser”: “Chrome”
},
{
“pageviews_sum”: 145,
“pageviews_avg”: 8.529411764705882,
“date_visit.year”: 2012,
“date_visit.month”: 8,
“pageviews_max”: 15,
“date_visit.quarter”: 3,
“browser”: “Chrome”
},
{
“pageviews_sum”: 144,
“pageviews_avg”: 6,
“date_visit.year”: 2012,
“date_visit.month”: 9,
“pageviews_max”: 21,
“date_visit.quarter”: 3,
“browser”: “Chrome”
},
{
“pageviews_sum”: 128,
“pageviews_avg”: 7.111111111111111,
“date_visit.year”: 2012,
“date_visit.month”: 10,
“pageviews_max”: 21,
“date_visit.quarter”: 4,
“browser”: “Chrome”
},
{
“pageviews_sum”: 114,
“pageviews_avg”: 6,
“date_visit.year”: 2012,
“date_visit.month”: 11,
“pageviews_max”: 16,
“date_visit.quarter”: 4,
“browser”: “Chrome”
},
{
“pageviews_sum”: 243,
“pageviews_avg”: 9.346153846153847,
“date_visit.year”: 2012,
“date_visit.month”: 12,
“pageviews_max”: 19,
“date_visit.quarter”: 4,
“browser”: “Chrome”
},
{
“pageviews_sum”: 217,
“pageviews_avg”: 7.75,
“date_visit.year”: 2013,
“date_visit.month”: 1,
“pageviews_max”: 19,
“date_visit.quarter”: 1,
“browser”: “Chrome”
},
{
“pageviews_sum”: 139,
“pageviews_avg”: 8.6875,
“date_visit.year”: 2013,
“date_visit.month”: 2,
“pageviews_max”: 20,
“date_visit.quarter”: 1,
“browser”: “Chrome”
},
{
“pageviews_sum”: 166,
“pageviews_avg”: 8.3,
“date_visit.year”: 2013,
“date_visit.month”: 3,
“pageviews_max”: 20,
“date_visit.quarter”: 1,
“browser”: “Chrome”
},
{
“pageviews_sum”: 204,
“pageviews_avg”: 7.0344827586206895,
“date_visit.year”: 2013,
“date_visit.month”: 4,
“pageviews_max”: 20,
“date_visit.quarter”: 2,
“browser”: “Chrome”
},
{
“pageviews_sum”: 211,
“pageviews_avg”: 7.535714285714286,
“date_visit.year”: 2013,
“date_visit.month”: 5,
“pageviews_max”: 22,
“date_visit.quarter”: 2,
“browser”: “Chrome”
},
{
“pageviews_sum”: 119,
“pageviews_avg”: 7,
“date_visit.year”: 2013,
“date_visit.month”: 6,
“pageviews_max”: 17,
“date_visit.quarter”: 2,
“browser”: “Chrome”
},
{
“pageviews_sum”: 202,
“pageviews_avg”: 8.08,
“date_visit.year”: 2013,
“date_visit.month”: 7,
“pageviews_max”: 22,
“date_visit.quarter”: 3,
“browser”: “Chrome”
},
{
“pageviews_sum”: 170,
“pageviews_avg”: 8.5,
“date_visit.year”: 2013,
“date_visit.month”: 8,
“pageviews_max”: 19,
“date_visit.quarter”: 3,
“browser”: “Chrome”
},
{
“pageviews_sum”: 209,
“pageviews_avg”: 8.708333333333334,
“date_visit.year”: 2013,
“date_visit.month”: 9,
“pageviews_max”: 18,
“date_visit.quarter”: 3,
“browser”: “Chrome”
},
{
“pageviews_sum”: 171,
“pageviews_avg”: 7.125,
“date_visit.year”: 2013,
“date_visit.month”: 10,
“pageviews_max”: 20,
“date_visit.quarter”: 4,
“browser”: “Chrome”
},
{
“pageviews_sum”: 139,
“pageviews_avg”: 6.95,
“date_visit.year”: 2013,
“date_visit.month”: 11,
“pageviews_max”: 19,
“date_visit.quarter”: 4,
“browser”: “Chrome”
},
{
“pageviews_sum”: 124,
“pageviews_avg”: 8.266666666666667,
“date_visit.year”: 2013,
“date_visit.month”: 12,
“pageviews_max”: 17,
“date_visit.quarter”: 4,
“browser”: “Chrome”
},
{
“pageviews_sum”: 172,
“pageviews_avg”: 9.555555555555555,
“date_visit.year”: 2012,
“date_visit.month”: 1,
“pageviews_max”: 25,
“date_visit.quarter”: 1,
“browser”: “Firefox”
},
{
“pageviews_sum”: 127,
“pageviews_avg”: 7.9375,
“date_visit.year”: 2012,
“date_visit.month”: 2,
“pageviews_max”: 21,
“date_visit.quarter”: 1,
“browser”: “Firefox”
},
{
“pageviews_sum”: 123,
“pageviews_avg”: 6.833333333333333,
“date_visit.year”: 2012,
“date_visit.month”: 3,
“pageviews_max”: 19,
“date_visit.quarter”: 1,
“browser”: “Firefox”
},
{
“pageviews_sum”: 136,
“pageviews_avg”: 8.5,
“date_visit.year”: 2012,
“date_visit.month”: 4,
“pageviews_max”: 16,
“date_visit.quarter”: 2,
“browser”: “Firefox”
},
{
“pageviews_sum”: 71,
“pageviews_avg”: 5.916666666666667,
“date_visit.year”: 2012,
“date_visit.month”: 5,
“pageviews_max”: 14,
“date_visit.quarter”: 2,
“browser”: “Firefox”
},
{
“pageviews_sum”: 150,
“pageviews_avg”: 7.894736842105263,
“date_visit.year”: 2012,
“date_visit.month”: 6,
“pageviews_max”: 22,
“date_visit.quarter”: 2,
“browser”: “Firefox”
},
{
“pageviews_sum”: 135,
“pageviews_avg”: 10.384615384615385,
“date_visit.year”: 2012,
“date_visit.month”: 7,
“pageviews_max”: 22,
“date_visit.quarter”: 3,
“browser”: “Firefox”
},
{
“pageviews_sum”: 112,
“pageviews_avg”: 7,
“date_visit.year”: 2012,
“date_visit.month”: 8,
“pageviews_max”: 11,
“date_visit.quarter”: 3,
“browser”: “Firefox”
},
{
“pageviews_sum”: 195,
“pageviews_avg”: 10.833333333333334,
“date_visit.year”: 2012,
“date_visit.month”: 9,
“pageviews_max”: 18,
“date_visit.quarter”: 3,
“browser”: “Firefox”
},
{
“pageviews_sum”: 162,
“pageviews_avg”: 7.714285714285714,
“date_visit.year”: 2012,
“date_visit.month”: 10,
“pageviews_max”: 15,
“date_visit.quarter”: 4,
“browser”: “Firefox”
},
{
“pageviews_sum”: 137,
“pageviews_avg”: 8.058823529411764,
“date_visit.year”: 2012,
“date_visit.month”: 11,
“pageviews_max”: 18,
“date_visit.quarter”: 4,
“browser”: “Firefox”
},
{
“pageviews_sum”: 119,
“pageviews_avg”: 8.5,
“date_visit.year”: 2012,
“date_visit.month”: 12,
“pageviews_max”: 20,
“date_visit.quarter”: 4,
“browser”: “Firefox”
},
{
“pageviews_sum”: 157,
“pageviews_avg”: 10.466666666666667,
“date_visit.year”: 2013,
“date_visit.month”: 1,
“pageviews_max”: 27,
“date_visit.quarter”: 1,
“browser”: “Firefox”
},
{
“pageviews_sum”: 166,
“pageviews_avg”: 9.764705882352942,
“date_visit.year”: 2013,
“date_visit.month”: 2,
“pageviews_max”: 18,
“date_visit.quarter”: 1,
“browser”: “Firefox”
},
{
“pageviews_sum”: 172,
“pageviews_avg”: 8.19047619047619,
“date_visit.year”: 2013,
“date_visit.month”: 3,
“pageviews_max”: 21,
“date_visit.quarter”: 1,
“browser”: “Firefox”
},
{
“pageviews_sum”: 180,
“pageviews_avg”: 8.181818181818182,
“date_visit.year”: 2013,
“date_visit.month”: 4,
“pageviews_max”: 19,
“date_visit.quarter”: 2,
“browser”: “Firefox”
},
{
“pageviews_sum”: 162,
“pageviews_avg”: 8.526315789473685,
“date_visit.year”: 2013,
“date_visit.month”: 5,
“pageviews_max”: 17,
“date_visit.quarter”: 2,
“browser”: “Firefox”
},
{
“pageviews_sum”: 141,
“pageviews_avg”: 8.8125,
“date_visit.year”: 2013,
“date_visit.month”: 6,
“pageviews_max”: 20,
“date_visit.quarter”: 2,
“browser”: “Firefox”
},
{
“pageviews_sum”: 88,
“pageviews_avg”: 9.777777777777779,
“date_visit.year”: 2013,
“date_visit.month”: 7,
“pageviews_max”: 19,
“date_visit.quarter”: 3,
“browser”: “Firefox”
},
{
“pageviews_sum”: 73,
“pageviews_avg”: 6.636363636363637,
“date_visit.year”: 2013,
“date_visit.month”: 8,
“pageviews_max”: 23,
“date_visit.quarter”: 3,
“browser”: “Firefox”
},
{
“pageviews_sum”: 106,
“pageviews_avg”: 9.636363636363637,
“date_visit.year”: 2013,
“date_visit.month”: 9,
“pageviews_max”: 25,
“date_visit.quarter”: 3,
“browser”: “Firefox”
},
{
“pageviews_sum”: 140,
“pageviews_avg”: 7.777777777777778,
“date_visit.year”: 2013,
“date_visit.month”: 10,
“pageviews_max”: 16,
“date_visit.quarter”: 4,
“browser”: “Firefox”
},
{
“pageviews_sum”: 211,
“pageviews_avg”: 8.791666666666666,
“date_visit.year”: 2013,
“date_visit.month”: 11,
“pageviews_max”: 21,
“date_visit.quarter”: 4,
“browser”: “Firefox”
},
{
“pageviews_sum”: 105,
“pageviews_avg”: 7.5,
“date_visit.year”: 2013,
“date_visit.month”: 12,
“pageviews_max”: 13,
“date_visit.quarter”: 4,
“browser”: “Firefox”
},
{
“pageviews_sum”: 70,
“pageviews_avg”: 8.75,
“date_visit.year”: 2012,
“date_visit.month”: 1,
“pageviews_max”: 17,
“date_visit.quarter”: 1,
“browser”: “Lynx”
},
{
“pageviews_sum”: 46,
“pageviews_avg”: 11.5,
“date_visit.year”: 2012,
“date_visit.month”: 2,
“pageviews_max”: 18,
“date_visit.quarter”: 1,
“browser”: “Lynx”
},
{
“pageviews_sum”: 79,
“pageviews_avg”: 9.875,
“date_visit.year”: 2012,
“date_visit.month”: 3,
“pageviews_max”: 14,
“date_visit.quarter”: 1,
“browser”: “Lynx”
},
{
“pageviews_sum”: 99,
“pageviews_avg”: 7.615384615384615,
“date_visit.year”: 2012,
“date_visit.month”: 4,
“pageviews_max”: 18,
“date_visit.quarter”: 2,
“browser”: “Lynx”
},
{
“pageviews_sum”: 58,
“pageviews_avg”: 8.285714285714286,
“date_visit.year”: 2012,
“date_visit.month”: 5,
“pageviews_max”: 19,
“date_visit.quarter”: 2,
“browser”: “Lynx”
},
{
“pageviews_sum”: 76,
“pageviews_avg”: 7.6,
“date_visit.year”: 2012,
“date_visit.month”: 6,
“pageviews_max”: 20,
“date_visit.quarter”: 2,
“browser”: “Lynx”
},
{
“pageviews_sum”: 46,
“pageviews_avg”: 11.5,
“date_visit.year”: 2012,
“date_visit.month”: 7,
“pageviews_max”: 26,
“date_visit.quarter”: 3,
“browser”: “Lynx”
},
{
“pageviews_sum”: 83,
“pageviews_avg”: 8.3,
“date_visit.year”: 2012,
“date_visit.month”: 8,
“pageviews_max”: 17,
“date_visit.quarter”: 3,
“browser”: “Lynx”
},
{
“pageviews_sum”: 34,
“pageviews_avg”: 6.8,
“date_visit.year”: 2012,
“date_visit.month”: 9,
“pageviews_max”: 15,
“date_visit.quarter”: 3,
“browser”: “Lynx”
},
{
“pageviews_sum”: 73,
“pageviews_avg”: 8.11111111111111,
“date_visit.year”: 2012,
“date_visit.month”: 10,
“pageviews_max”: 20,
“date_visit.quarter”: 4,
“browser”: “Lynx”
},
{
“pageviews_sum”: 30,
“pageviews_avg”: 6,
“date_visit.year”: 2012,
“date_visit.month”: 11,
“pageviews_max”: 8,
“date_visit.quarter”: 4,
“browser”: “Lynx”
},
{
“pageviews_sum”: 2,
“pageviews_avg”: 2,
“date_visit.year”: 2012,
“date_visit.month”: 12,
“pageviews_max”: 2,
“date_visit.quarter”: 4,
“browser”: “Lynx”
},
{
“pageviews_sum”: 83,
“pageviews_avg”: 6.916666666666667,
“date_visit.year”: 2013,
“date_visit.month”: 1,
“pageviews_max”: 15,
“date_visit.quarter”: 1,
“browser”: “Lynx”
},
{
“pageviews_sum”: 48,
“pageviews_avg”: 12,
“date_visit.year”: 2013,
“date_visit.month”: 2,
“pageviews_max”: 19,
“date_visit.quarter”: 1,
“browser”: “Lynx”
},
{
“pageviews_sum”: 72,
“pageviews_avg”: 8,
“date_visit.year”: 2013,
“date_visit.month”: 3,
“pageviews_max”: 15,
“date_visit.quarter”: 1,
“browser”: “Lynx”
},
{
“pageviews_sum”: 25,
“pageviews_avg”: 6.25,
“date_visit.year”: 2013,
“date_visit.month”: 4,
“pageviews_max”: 14,
“date_visit.quarter”: 2,
“browser”: “Lynx”
},
{
“pageviews_sum”: 83,
“pageviews_avg”: 11.857142857142858,
“date_visit.year”: 2013,
“date_visit.month”: 5,
“pageviews_max”: 21,
“date_visit.quarter”: 2,
“browser”: “Lynx”
},
{
“pageviews_sum”: 25,
“pageviews_avg”: 5,
“date_visit.year”: 2013,
“date_visit.month”: 6,
“pageviews_max”: 10,
“date_visit.quarter”: 2,
“browser”: “Lynx”
},
{
“pageviews_sum”: 145,
“pageviews_avg”: 8.529411764705882,
“date_visit.year”: 2013,
“date_visit.month”: 7,
“pageviews_max”: 16,
“date_visit.quarter”: 3,
“browser”: “Lynx”
},
{
“pageviews_sum”: 96,
“pageviews_avg”: 10.666666666666666,
“date_visit.year”: 2013,
“date_visit.month”: 8,
“pageviews_max”: 16,
“date_visit.quarter”: 3,
“browser”: “Lynx”
},
{
“pageviews_sum”: 19,
“pageviews_avg”: 3.8,
“date_visit.year”: 2013,
“date_visit.month”: 9,
“pageviews_max”: 9,
“date_visit.quarter”: 3,
“browser”: “Lynx”
},
{
“pageviews_sum”: 36,
“pageviews_avg”: 7.2,
“date_visit.year”: 2013,
“date_visit.month”: 10,
“pageviews_max”: 14,
“date_visit.quarter”: 4,
“browser”: “Lynx”
},
{
“pageviews_sum”: 69,
“pageviews_avg”: 8.625,
“date_visit.year”: 2013,
“date_visit.month”: 11,
“pageviews_max”: 22,
“date_visit.quarter”: 4,
“browser”: “Lynx”
},
{
“pageviews_sum”: 9,
“pageviews_avg”: 4.5,
“date_visit.year”: 2013,
“date_visit.month”: 12,
“pageviews_max”: 7,
“date_visit.quarter”: 4,
“browser”: “Lynx”
}
],
“aggregates”: [
“pageviews_sum”,
“pageviews_avg”,
“pageviews_max”
],
“cell”: [],
“levels”: {
“date_visit”: [
“year”,
“quarter”,
“month”
],
“browser”: [
“browser”
]
}
}
Â
Thank you very much.
tonyHello,
Will look into this these days and will replay. Eventually I will post a code.
Regards
tonyHello,
Well with this data I have error too.
Currently I investigate the problem and will post you a solution.
Thank you for the test case and patience.
Best Regards
Tony
tonyHello,
I have found the bug. It is little difficult to fix this. I always will fix this.
Thanks for the code and test case.
Kind Regards
stapelchipThank you
stapelchipHello Tony,
do you have any news on this topic?
Kind Regards
tonyHello,
Â
Just have made the fix. This is maybe my hardest fix that i have made for the grid.
I’m just making last tests (some other small fixes) and will let you know.
I hope that next week you will be able to use the pivot.
Kind Regards
Tony
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
