如何使用值添加jquery过滤数据表 [英] How to filter datatable with value add with jquery

问题描述

Hello

Hello

 我正在使用Datatable，我试图在文本红色或白色值上过滤我最后一个td colomun上的值..

 I m using Datatable and i trying to filter value on my last td colomun on text Red or white value..

当我点击箭头的过滤器时，没有任何事情发生（没有过滤器动作）..

When i clicked on arrow's filter nothing is happening (no filter action)..

你知道为什么吗？

Do you know why?

 $('#sst-table-all-contracts').DataTable 
                            ({
                            'createdRow': function (row, data) {
                                $(row).find("td:eq(1)").attr("id", data[6]);

                                if (data[7] == null )
                                {
                                    $(row).find('td:last').css("background", "white");
                                    $(row).find('td:last').text("white");
                                    $(row).find('td:last').css("color", "white");

                                }
                                else {

                                    $(row).find('td:last').css("background", "red");
                                    $(row).find('td:last').text("red");
                                    $(row).find('td:last').css("color", "red");

                                }

                                },
                            "aaData": contractsList,
                            "aoColumns": [ {}, {}]

                                  });

推荐答案

您好，

您可以查看以下演示，为jQuery DataTable添加过滤器标头。

<script type="text/javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
    <script src="https://nightly.datatables.net/js/jquery.dataTables.js"></script>
    <script src="https://cdn.datatables.net/responsive/2.2.1/js/dataTables.responsive.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.20.1/moment.min.js"></script>
    <script src="/_layouts/15/js/dataTables.fixedHeader3.11.js"></script>   
    <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />     
    <link href="https://cdn.datatables.net/responsive/2.2.1/css/responsive.dataTables.min.css" rel="stylesheet" type="text/css" />
    <link href="https://cdn.datatables.net/fixedheader/3.1.3/css/fixedHeader.dataTables.min.css" rel="stylesheet" type="text/css" />
    <link href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css" />
    
    <script>
        //alert('start script');

（document）.ready（function（）{
ExecuteOrDelayUntilScriptLoaded（retrieveListItems，" sp.js"） ;
sortDatePlugin（）;
}）;
//函数是根据DD / MM / YYYY
函数sortDatePlugin（）{

(document).ready(function () { ExecuteOrDelayUntilScriptLoaded(retrieveListItems, "sp.js"); sortDatePlugin(); }); // Function is to Sort the Date Column based on DD/MM/YYYY function sortDatePlugin() {

.fn.dataTable.moment = function（格式）对Date列进行排序，locale）{
var types =

.fn.dataTable.moment = function (format, locale) { var types =

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