jQuery Grid Plugin - jqGridForum

Topic RSS

Pivot: formatter for the grouping dimension not fired

29/04/2014
14:23

stapelchip

Member

Members

Forum Posts: 20

Member Since:
24/04/2014

Offline

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

02/05/2014
12:04

stapelchip

Member

Members

Forum Posts: 20

Member Since:
24/04/2014

Offline

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?

04/05/2014
10:13

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

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

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

05/05/2014
14:58

stapelchip

Member

Members

Forum Posts: 20

Member Since:
24/04/2014

Offline

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.

05/05/2014
16:16

stapelchip

Member

Members

Forum Posts: 20

Member Since:
24/04/2014

Offline

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 🙂

06/05/2014
10:12

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

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

Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

22/05/2014
21:48

wjgray

Utah

New Member

Members

Forum Posts: 1

Member Since:
14/05/2014

Offline

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.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
37 Guest(s)

Currently Browsing this Page:
1 Guest(s)