如何使用下拉列表过滤jquery数据表 [英] How do I filter jquery datatable using dropdown list

问题描述

function getTeamActivities（）{

if（$（＃ddlTeamNames option）。length> 2）{

var TeamMemberSelection = $（＃ddlTeamNames ）.val（）;

$ .get（'/ Home / GetTeamMemberActivityList /'+ TeamMemberSelection，function（data）{

var items ='';

$ .each（data，function（i，TeamData）{

items + =;

}）;

项+ =

	主修课程	主题	活动类型	活动状态	优先级	到期	分配给
< input type ='checkbox'value =+ TeamData.Regarding +/>	+ TeamData.LeadCourseName +	+ TeamData.Subject +	+ TeamData.ActivityTypeCode +	+ TeamData.StateCode +	+ TeamData.PriorityCode +	+ $ .format.date（TeamData.DueDate，dd-MMM-yyyy hh：mm a）+	+ TeamData.AssignedTo.Name +

;

$（'＃dvTeamActivity'）。html（items） ;

var tmTableConfig = $ .extend（GlobalSettings.tableConfig，{order：[[6，asc]]}）;

$（'＃tblTeamActivity '）。DataTable（tmTableConfig）;

}）;

}

}



-----------------------

$（＃tblTeamActivity）。dataTable（{

sPaginationType：full_numbers，

bFilter：true，

sDom：lrtip

}） ;

var oTable;

oTable = $（'＃tblTeamActivity '）。dataTable（）;



$（'＃msds-select'）。change（function（）{

oTable.fnFilter （$（this）.val（））;

}）;

----------------

 <  选择    id   = ＃msds - 选择 >  
 <  选项    value   =  > 选择<   / option  >  
 <  选项    value   =  1 > 约会<   / option  >  
 <  选项    value   =  2 >  phonecall <   / option  >  
 <   / select  >  

决方案

（ ＃ddlTeamNames选项）长度>。 2）{

var TeamMemberSelection =

（＃ddlTeamNames）。val（）;

.get（'/ Home / GetTeamMemberActivityList /'+ TeamMemberSelection，function（data）{

var items ='';

function getTeamActivities() {
if ($("#ddlTeamNames option").length > 2) {
var TeamMemberSelection = $("#ddlTeamNames").val();
$.get('/Home/GetTeamMemberActivityList/' + TeamMemberSelection, function (data) {
var items = '';
$.each(data, function (i, TeamData) {
items += "";
});
items += "

	Lead Course	Subject	Activity Type	Activity Status	Priority	Due On	Assigned To
<input type='checkbox' value=" + TeamData.Regarding + " />	" + TeamData.LeadCourseName + "	" + TeamData.Subject + "	" + TeamData.ActivityTypeCode + "	" + TeamData.StateCode + "	" + TeamData.PriorityCode + "	" + $.format.date(TeamData.DueDate, "dd-MMM-yyyy hh:mm a") + "	" + TeamData.AssignedTo.Name + "

";
$('#dvTeamActivity').html(items);
var tmTableConfig = $.extend(GlobalSettings.tableConfig, { "order": [[6, "asc"]] });
$('#tblTeamActivity').DataTable(tmTableConfig);
});
}
}

-----------------------
$("#tblTeamActivity").dataTable({
"sPaginationType": "full_numbers",
"bFilter": true,
"sDom": "lrtip"
});
var oTable;
oTable = $('#tblTeamActivity').dataTable();

$('#msds-select').change(function () {
oTable.fnFilter($(this).val());
});
----------------

<select id="#msds-select">
                            <option value="">Select</option>
                            <option value="1">appointment</option>
                            <option value="2">phonecall</option>
                        </select>

解决方案

("#ddlTeamNames option").length > 2) {
var TeamMemberSelection =

("#ddlTeamNames").val();

.get('/Home/GetTeamMemberActivityList/' + TeamMemberSelection, function (data) {
var items = '';

这篇关于如何使用下拉列表过滤jquery数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！