Get Free Trial
Get Free Trial

DrillThrough columns change change after editing the fields

Answered
Devesh asked on August 9, 2019

Hi team,
I have configured the ‘slice.drillThrough’ array with n number of fields. when I double click the cell, I can see all the fields/columns on popup as configured. But when I edit the rows and columns  from ‘Fields’ option in toolbar and apply changes and then double click the cell, I don’t see the pre-configured fields and the ‘drillThrough’ array items are changed by tool.
How can I keep the ‘drillThrough’ array same as configured even after editing columns and rows.

4 answers

Public
Vera Didenko Flexmonster August 12, 2019

Hello,
 
Thank you for your question.
 
For such cases, we kindly advise specifying the slice.drillThrough configuration in the global object:

global: {
slice: {
"drillThrough": [
"Business Type",
"Country",
"Price"
]
}
}

 
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/0f9c8xg5/

Please let us know if this works fine for you.
 
Best Regards,
Vera

Public
Sangamesh August 13, 2019

Where to include the above global configuration?
 
I am configuring in typescript as below.
 
public pivotReport: any;
this.pivotReport = {
dataSource: {
dataSourceType: “ocsv”,
filename: Url,

},
slice: {
reportFilters: [],
rows: [],
columns: [],
measures: [
],
drillThrough: []
},
};

Public
Vera Didenko Flexmonster August 13, 2019

Hello, 
 
Thank you for your response.
 
The global object is a separate Flexmonster parameter, not part of the report object (see: https://www.flexmonster.com/api/new-flexmonster/ ).
 
Please consider the following example:
1) Let’s specify global in fm-pivot in app.component.html:

<fm-pivot #pivot

...

[height]="450"

[global]="pivotGlobal"

[report]="pivotReport"

....

>

</fm-pivot>

 
2) Next, let’s define pivotGlobal in app.component.ts:

public pivotGlobal = {

slice: {

"drillThrough": [

"Color",

"Country",

"Price"

]

}

};

 
Please let us know if everything works.
 
Best Regards,
Vera

Public
Sangamesh August 14, 2019

Thanks. It worked

Please login or Register to Submit Answer