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.
⋅ 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
⋅ 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: []
},
};
⋅ 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
⋅ August 14, 2019
Thanks. It worked