如何将多个JSON值添加到dataTable的单个单元格中。
我正在查看datatables文档,但找不到清晰的示例。
我有以下JSON字符串,通过会话访问它并放入了一个dataTable中。
<textarea id="Report" type="text" style="" name="Report">
[
{
"Identifier": "0",
"LastName": "Cooper",
"FirstName": "Benny",
"MiddleInitial": "P",
"MRN": "7854753",
"Age": "30",
"Gender": "Female",
"Location":
{
"Bed": "1",
"Room": "A",
"unit": "NU1",
"facility": "Fac1"
},
"ServiceDate":"05/03/2013",
"ChargeAndDx":"99222 - 410.01,428",
"BillingProvider":"Palmer, James",
"title":"Add",
"start":"2013-08-07",
"url":"#",
"textColor":"red"
}] </textarea>
在另一页上,我正在访问数据表中的会话,如下所示:在另一页上,我正在访问数据表中的会话,如下所示:
$(document).ready(function (){
var ReportData=JSON.parse(document.getElementById("Report").innerHTML);
Report=$('#patientDataTables').dataTable
({
"bJQueryUI":true,
"bScrollCollapse":true,
aaData:patientReportData,
"aoColumns":
[ {"mData":"LastName","sClass":"left"},
{"mData":"ServiceDate","sClass":"left"},
{"mData":"ChargeAndDx","sClass":"left"},
{"mData":"BillingProvider","sClass":"left"},
{"mData":"null","sClass":"center","sDefaultContent":"<a href='' class='editor_menu'>menu</a>"}
]
});
在我的数据表中,当姓氏出现时,我也想要名字、中间名字缩写、MRN和年龄。
这应该如何完成?如果有人知道一个快速的方法,请告诉我。