jQuery Grid Plugin - jqGrid - Topic: Pivot: formatter for the grouping dimension not fired http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired Simple:Press Version 5.7.5.3 wjgray on Pivot: formatter for the grouping dimension not fired http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30665 Help http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30665 I am struggling with this (formatter not firing when associated with xdimension dataname).  I need to decorate the cell value before output. 

 

Should the custom formatter be firing for these even if they are not "aggregates"?  Note that it works like a charm for aggregate columns.

]]> Thu, 22 May 2014 21:48:03 +0300 tony on Pivot: formatter for the grouping dimension not fired http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30585 Help http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30585 Hello,

You can try to set groupColumnShow in the same gridViewOptions to false. (this is not tested from)

Regards

]]> Tue, 06 May 2014 10:12:43 +0300 stapelchip on Pivot: formatter for the grouping dimension not fired http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30580 Help http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30580 I tried to make a workaround for this problem by sorting my json response serverside.

Than i found out that "hidden:true" works only for the very last dimension.

Do you have any suggestions to solve my problem?

Edit: There is an option "isGroupField". With this option enabled i can hide other dimension 🙂

]]> Mon, 05 May 2014 16:16:26 +0300 stapelchip on Pivot: formatter for the grouping dimension not fired http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30579 Help http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30579 Thank you very much, the fix is working for me. 

But it is still not possible to hide the first dimension with hidden:true.

Is there an other way to pass a value to the rowObject?

I have several "key Columns" and i only need them to create my links, not to display.

]]> Mon, 05 May 2014 14:58:19 +0300 tony on Pivot: formatter for the grouping dimension not fired http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30573 Help http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30573 Hello,

This is a expected behavior. The reason for this is the new option in grouping introduced with the pivot.

The option is named hideFirstGroupCol and it is set to true when pivot is enabled.

Partially I have fixed this enabling to overwrite group options in pivot. This can be achieved when you use groupingView in grid options like this.

$("#pivot").jqGrid('jqPivot', 'url',

{…}, //pivot options

{groupingView:{ hideFirstGroupCol : false}, // grid options

…

);

Note that this is only in the fixed code in git hub.

I will think in the future how to fix this.

Kind Regards

]]> Sun, 04 May 2014 10:13:02 +0300 stapelchip on Pivot: formatter for the grouping dimension not fired http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30562 Help http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30562 Same problem for the hidden attribute. 

I can hide every dimension, except the first.

Can you please tell me if this is a bug or the expected behavior?

]]> Fri, 02 May 2014 12:04:45 +0300 stapelchip on Pivot: formatter for the grouping dimension not fired http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30557 Help http://www.trirand.com/blog/?page_id=393/help/pivot-formatter-for-the-grouping-dimension-not-fired#p30557 Hello,

I try to implement DrillDown functionality for my Pivot table.

Therefore i want to use a custom formatter which creates a url.

xDimension: [{formatter: urlFmatter, dataName: 'Config.Name'},

      {formatter: urlFmatter, dataName: 'Config.Value'}]

     

function urlFmatter(cellvalue, options, rowObject)

{

//create drilldown url

return url

}

Unfortunately the urlFmatter function is not fired for the first dimension(Config.Name), only for Config.Value.

Is this a bug or is there an other way to change the Grouping Text dynamic?

Sincerely, Stapelchip

]]> Tue, 29 Apr 2014 14:23:19 +0300