Update data - bug
by ilaria_nunziante
HTML
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<button onclick="changeLayout1()">Layout Color</button>
<button onclick="changeLayout2()">Layout Category</button>
<button onclick="updateData()">Update data</button>
<div id="pivot-container"></div>
JavaScript
let jsonData = [{
"RowId": 1,
"Category": "Accessories",
"Color": "red",
"Price": 100
},
{
"RowId": 2,
"Category": "Accessories",
"Color": "white",
"Price": 200
},
{
"RowId": 3,
"Category": "Bikes",
"Color": "white",
"Price": 300
}
];
let slice1 = {
"rows": [ {"uniqueName": "Color", "filter": { "members": ["color.[red]"]} }],
"columns": [ {"uniqueName": "[Measures]" }],
"measures": [{"uniqueName": "Price"}]
}
let slice2 = {
"rows": [ {"uniqueName": "Category", "filter": { "members": ["category.[accessories]"]} }],
"columns": [ {"uniqueName": "[Measures]" }],
"measures": [{"uniqueName": "Price"}]
}
let pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
report: {
dataSource: {
type: "json",
data: jsonData,
mapping:{
"RowId":{ "type": "id"},
"Category": {"type": "string"},
"Color": {"type": "string"},
"Price": {"type": "number"},
}
},
slice: slice1
}
});
function updateData() {
flexmonster.updateData({
data: jsonDataToUpdate
},{partial: true});
}
let jsonDataToUpdate = [{
"RowId": 1,
"Category": "Accessories",
"Color": "red",
"Price": 1100
}
];
function changeLayout1(){
flexmonster.runQuery(slice1);
}
function changeLayout2(){
flexmonster.runQuery(slice2);
}