我想通过制表器创建表格。
我的数据是:
[{
"trade_symbol": "aaa",
"volume": 159842,
"real": 0.051560379918588875,
"date_time": "2020-07-06T09:34:51",
"value": 0.12543630017452,
"result": [{
"title": ["R1"],
"alias_title": ["R"],
"value": 0.12543630017452,
"value_type": 2
}, {
"title": ["RV"],
"alias_title": ["B"],
"value": true,
"value_type": 4
}
]
}, {
"trade_symbol": "bbb",
"volume": 144216,
"real": 0.04997030626961907,
"date_time": "2020-07-06T09:34:44",
"value": 0.271246764452114,
"result": [{
"title": ["R1"],
"alias_title": ["R"],
"value": 0.271246764452114,
"value_type": 2
}, {
"title": ["RV"],
"alias_title": ["B"],
"value": true,
"value_type": 4
}
]
}, {
"trade_symbol": "ccc",
"volume": 1566952,
"real": 0.04988399071925754,
"date_time": "2020-07-04T12:29:33",
"value": 0.057654850019478,
"result": [{
"title": ["R1"],
"alias_title": ["R"],
"value": 0.057654850019478,
"value_type": 2
}, {
"title": ["RV"],
"alias_title": ["B"],
"value": true,
"value_type": 4
}
]
}]" result“字段可能大于1(这是搜索结果,例如,我们可能有1或5个结果)现在我想使用"tabulator”(http://tabulator.info/docs/4.7)
所有数组中的"result“数组元素的数量是相同的,但其数量是未知的。
每次结果都必须在我们的表中添加一列。它的值在Resualt item元素的值中。所以我们不知道这个表中的列数。
但在制表程序中,我们必须只有平面数据。
因为" result“的计数不是固定的,所以我不能使用平面数组。(任何结果都必须显示在新的列中)并且我不能使用下面的代码:
table.addColumn({title:alldata[0].result.alias_title, field:alldata[0].result.value});和制表器不支持字段中数组的索引。
如何使用这些数据创建表?
发布于 2020-07-07 07:17:22
下面是来自examples的一个示例
http://tabulator.info/examples/4.7#nested-tables
var nestedData = [
{id:1, make:"Ford", model:"focus", reg:"P232 NJP", color:"white", serviceHistory:[
{date:"01/02/2016", engineer:"Steve Boberson", actions:"Changed oli filter"},
{date:"07/02/2017", engineer:"Martin Stevenson", actions:"Break light broken"},
]},
{id:1, make:"BMW", model:"m3", reg:"W342 SEF", color:"red", serviceHistory:[
{date:"22/05/2017", engineer:"Jimmy Brown", actions:"Aligned wheels"},
{date:"11/02/2018", engineer:"Lotty Ferberson", actions:"Changed Oil"},
{date:"04/04/2018", engineer:"Franco Martinez", actions:"Fixed Tracking"},
]},
]
//define table
var table = new Tabulator("#example-table", {
height:"311px",
layout:"fitColumns",
resizableColumns:false,
data:nestedData,
columns:[
{title:"Make", field:"make"},
{title:"Model", field:"model"},
{title:"Registration", field:"reg"},
{title:"Color", field:"color"},
],
rowFormatter:function(row){
//create and style holder elements
var holderEl = document.createElement("div");
var tableEl = document.createElement("div");
holderEl.style.boxSizing = "border-box";
holderEl.style.padding = "10px 30px 10px 10px";
holderEl.style.borderTop = "1px solid #333";
holderEl.style.borderBotom = "1px solid #333";
holderEl.style.background = "#ddd";
tableEl.style.border = "1px solid #333";
holderEl.appendChild(tableEl);
row.getElement().appendChild(holderEl);
var subTable = new Tabulator(tableEl, {
layout:"fitColumns",
data:row.getData().serviceHistory,
columns:[
{title:"Date", field:"date", sorter:"date"},
{title:"Engineer", field:"engineer"},
{title:"Action", field:"actions"},
]
})
},
});发布于 2020-07-07 12:48:46
所有数组中的"Result“数组元素的数量是相同的,但其数量是未知的。必须为每个结果在我们的表中添加一列。它的值在结果项元素的值中。所以我们不知道这个表中的列数。它不是行中的“嵌套表”。我们需要多列。
https://stackoverflow.com/questions/62757924
复制相似问题