问题描述
我有一个数据表,正在从 api 获取数据.现在我的状态是活动的,如果标志是活动的,那么我需要在数据表中显示,否则我不应该显示过期的.这是我的 小提琴.在这个小提琴中,我同时显示了活跃和不活跃.但我只想显示活动状态.
I have a datatable and am fetching the data from an api. Now i have the status like active,inactive if the flag is active then i need to show in the datatble else i should not show the expired one.Here is my fiddle. In this fiddle am showing the active and inactive both. but i want to show only the active status.
HTML
<table id="example" class="display" cellspacing="0" width="100%">
<thead>
<tr>
<th>Name</th>
<th>Email</th>
<th>Subject</th>
<th>Status</th>
<th>Message</th>
<th>Details</th>
</tr>
</thead>
</table>
脚本:
$(document).ready(function() {
$('#example').DataTable({
"processing" : true,
"ajax" : {
"url" : "https://api.myjson.com/bins/12uwp2",
dataSrc : ''
},
"columns" : [ {
"data" : "name"
}, {
"data" : "email"
}, {
"data" : "subject"
}, {
"data" : "status"
},{
"data" : "message"
},
{
"mData": "Details",
"mRender": function (data, type, row) {
return "<a class='delete' data-id=" + row.id + " href='/Details/" + row.id + "'>Delete</a>";
}
}]
});
$(document).on("click", ".delete", function(e) {
e.preventDefault()
alert("Delete button clicked for Row number " + $(this).data("id"))
})
});
如何做到这一点.谁能帮我怎么做.
How to do this. Can anyone help me how to do.
推荐答案
用例是:操作服务器返回的数据
The use case is: Manipulate the data returned from the server
$('#example').DataTable({
"ajax" : {
"url" : "https://api.myjson.com/bins/12uwp2",
"dataSrc": function ( json ) {
return json.filter(function(item){
return item.status=="active";
});
}
}
});
关键是要正确使用dataSrc
进行数据操作.
The key is to use dataSrc
properly for data manipulation.
作为函数 - 作为函数,它接受一个参数,即 JSON从服务器返回,可以根据需要进行操作.这函数的返回值将被 DataTables 用作表的数据源.
我建议从 DataTable 初始化对象中删除 processing
属性,因为不再有繁重的处理步骤.
I recommend to remove the processing
property from DataTable initialization object since there is no heavy processing step anymore.
文档
这篇关于数据表 - 从 AJAX 源过滤数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!