获取状态为CMM批准的jQuery数据表格数据

huangapple go评论75阅读模式
英文:

Get data of jQuery datatable whose status is CMM Approved

问题

我有一个包含许多记录的jQuery数据表格。在其中有几列,其中一列的名称是STATUS。在该状态列中有许多状态信息。

所以我想要的是,我想要状态为CMM Approved的状态列的数据。

以下是相同的代码:

<link href="//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css" rel="stylesheet">
<script src="//cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<div class="table-responsive3"><div class="dataTables_scroll"><div class="dataTables_scrollHead" style="overflow: hidden; position: relative; border: 0px; width: 100%;"><div class="dataTables_scrollHeadInner" style="box-sizing: content-box; width: 1968px; padding-right: 0px;"><table class="sites myTable table table-striped table-bordered nowrap dataTable no-footer" ui-jq="dataTable" ui-options="dataTableOpt" cellspacing="0" width="100%" role="grid" style="margin-left: 0px; width: 1968px;"><thead><tr role="row"><th class="select-checkbox sorting_disabled" rowspan="1" colspan="1" style="width: 20px;" aria-label=""></th><th class="sorting" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 42px;" aria-label="Action: activate to sort column ascending">Action</th><th class="sorting_asc" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 103px;" aria-label="SAP ID: activate to sort column ascending">SAP ID</th><th class="sorting" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 132px;" aria-label="NETWORK ENTITY ID: activate to sort column ascending">NETWORK ENTITY ID</th><th class="sorting" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 122px;" aria-label="SITE NAME: activate to sort column ascending">SITE NAME</th><th class="sorting" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 103px;" aria-label="ASSESTS COUNT: activate to sort column ascending">ASSESTS COUNT</th><th class="sorting" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 91px;" aria-label="SERVICE CODE: activate to sort column ascending">SERVICE CODE</th><th class="sorting" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 426px;" aria-label="SHORT DESC: activate to sort column ascending">SHORT DESC</th><th class="sorting_asc" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 78px;" aria-label="SITE STATUS: activate to sort column ascending">SITE STATUS</th><th class="sorting" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 68px;" aria-label="RFE1 DATE: activate to sort column ascending">RFE1 DATE</th><th class="sorting" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 62px;" aria-label="RFR DATE: activate to sort column ascending">RFR DATE</th><th class="sorting" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 163px;" aria-label="VENDOR: activate to sort column ascending">VENDOR</th><th class="sorting_asc" tabindex="0" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 114px;" aria-label="STATUS: activate to sort column descending" aria-sort="ascending">STATUS</th></tr></thead></table></div></div><div class="dataTables_scrollBody" style="position: relative; overflow: auto; width: 100%;"><table id="certifyEFO" class="sites myTable table table-striped table-bordered nowrap dataTable no-footer" ui-jq="dataTable" ui-options="dataTableOpt" cellspacing="0" width="100%" role="grid" aria-describedby="certifyEFO_info" style="width: 100%;"><thead><tr role="row" style="height: 0px;"><th class="select-checkbox sorting_disabled" rowspan="1" colspan="1" style="width: 20px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;" aria-label=""><div class="dataTables_sizing" style="height:0;overflow:hidden;"></div></th><th class="sorting" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 42px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;" aria-label="Action: activate to sort column ascending"><div class="dataTables_sizing" style="height:0;overflow:hidden;">Action</div></th><th class="sorting_asc" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 103px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;" aria-label="SAP ID: activate to sort column ascending"><div class="dataTables_sizing" style="height:0;overflow:hidden;">SAP ID</div></th><th class="sorting" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 132px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;" aria-label="NETWORK ENTITY ID: activate to sort column ascending"><div class="dataTables_sizing" style="height:0;overflow:hidden;">NETWORK ENTITY ID</div></th><th class="sorting" aria-controls="certifyEFO" rowspan="1" colspan="1" style="width: 122px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;" aria-label="SITE NAME: activate to sort column ascending"><div class="dataTables_sizing" style="height:0;overflow:hidden;">SITE NAME</div

<details>
<summary>英文:</summary>

I have a jQuery datatable with many records. In this there are several columns also of which one column name is `STATUS`. In that status there are many status information.

So what I want is, I want the data of status column whose status is `CMM Approved`.

Below is the code for the same:

&lt;!-- begin snippet: js hide: false console: true babel: false --&gt;

&lt;!-- language: lang-html --&gt;

    &lt;link href=&quot;//cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css&quot; rel=&quot;stylesheet&quot;/&gt;
    &lt;script src=&quot;//cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js&quot;&gt;&lt;/script&gt;
    &lt;div class=&quot;table-responsive3&quot;&gt;&lt;div class=&quot;dataTables_scroll&quot;&gt;&lt;div class=&quot;dataTables_scrollHead&quot; style=&quot;overflow: hidden; position: relative; border: 0px; width: 100%;&quot;&gt;&lt;div class=&quot;dataTables_scrollHeadInner&quot; style=&quot;box-sizing: content-box; width: 1968px; padding-right: 0px;&quot;&gt;&lt;table class=&quot;sites myTable table table-striped table-bordered nowrap dataTable no-footer&quot; ui-jq=&quot;dataTable&quot; ui-options=&quot;dataTableOpt&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot; role=&quot;grid&quot; style=&quot;margin-left: 0px; width: 1968px;&quot;&gt;&lt;thead&gt;&lt;tr role=&quot;row&quot;&gt;&lt;th class=&quot;select-checkbox sorting_disabled&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 20px;&quot; aria-label=&quot;&quot;&gt;&lt;/th&gt;&lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 42px;&quot; aria-label=&quot;Action: activate to sort column ascending&quot;&gt;Action&lt;/th&gt;&lt;th class=&quot;sorting_asc&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 103px;&quot; aria-label=&quot;SAP ID: activate to sort column ascending&quot;&gt;SAP ID&lt;/th&gt;&lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 132px;&quot; aria-label=&quot;NETWORK ENTITY ID: activate to sort column ascending&quot;&gt;NETWORK ENTITY ID&lt;/th&gt;&lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 122px;&quot; aria-label=&quot;SITE NAME: activate to sort column ascending&quot;&gt;SITE NAME&lt;/th&gt;&lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 103px;&quot; aria-label=&quot;ASSESTS COUNT: activate to sort column ascending&quot;&gt;ASSESTS COUNT&lt;/th&gt;&lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 91px;&quot; aria-label=&quot;SERVICE CODE: activate to sort column ascending&quot;&gt;SERVICE CODE&lt;/th&gt;&lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 426px;&quot; aria-label=&quot;SHORT DESC: activate to sort column ascending&quot;&gt;SHORT DESC&lt;/th&gt;&lt;th class=&quot;sorting_asc&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 78px;&quot; aria-label=&quot;SITE STATUS: activate to sort column ascending&quot;&gt;SITE STATUS&lt;/th&gt;&lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 68px;&quot; aria-label=&quot;RFE1 DATE: activate to sort column ascending&quot;&gt;RFE1 DATE&lt;/th&gt;&lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 62px;&quot; aria-label=&quot;RFR DATE: activate to sort column ascending&quot;&gt;RFR DATE&lt;/th&gt;&lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 163px;&quot; aria-label=&quot;VENDOR: activate to sort column ascending&quot;&gt;VENDOR&lt;/th&gt;&lt;th class=&quot;sorting_asc&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 114px;&quot; aria-label=&quot;STATUS: activate to sort column descending&quot; aria-sort=&quot;ascending&quot;&gt;STATUS&lt;/th&gt;&lt;/tr&gt;&lt;/thead&gt;&lt;/table&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;dataTables_scrollBody&quot; style=&quot;position: relative; overflow: auto; width: 100%;&quot;&gt;&lt;table id=&quot;certifyEFO&quot; class=&quot;sites myTable table table-striped table-bordered nowrap dataTable no-footer&quot; ui-jq=&quot;dataTable&quot; ui-options=&quot;dataTableOpt&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot; role=&quot;grid&quot; aria-describedby=&quot;certifyEFO_info&quot; style=&quot;width: 100%;&quot;&gt;&lt;thead&gt;&lt;tr role=&quot;row&quot; style=&quot;height: 0px;&quot;&gt;&lt;th class=&quot;select-checkbox sorting_disabled&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 20px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 42px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;Action: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;Action&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting_asc&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 103px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;SAP ID: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;SAP ID&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 132px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;NETWORK ENTITY ID: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;NETWORK ENTITY ID&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 122px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;SITE NAME: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;SITE NAME&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 103px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;ASSESTS COUNT: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;ASSESTS COUNT&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 91px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;SERVICE CODE: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;SERVICE CODE&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 426px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;SHORT DESC: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;SHORT DESC&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting_asc&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 78px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;SITE STATUS: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;SITE STATUS&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 68px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;RFE1 DATE: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;RFE1 DATE&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 62px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;RFR DATE: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;RFR DATE&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 163px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;VENDOR: activate to sort column ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;VENDOR&lt;/div&gt;&lt;/th&gt;&lt;th class=&quot;sorting_asc&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 114px; padding-top: 0px; padding-bottom: 0px; border-top-width: 0px; border-bottom-width: 0px; height: 0px;&quot; aria-label=&quot;STATUS: activate to sort column descending&quot; aria-sort=&quot;ascending&quot;&gt;&lt;div class=&quot;dataTables_sizing&quot; style=&quot;height:0;overflow:hidden;&quot;&gt;STATUS&lt;/div&gt;&lt;/th&gt;&lt;/tr&gt;&lt;/thead&gt;&lt;tbody id=&quot;datagrdbody&quot;&gt;&lt;tr role=&quot;row&quot; class=&quot;odd&quot;&gt;&lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&lt;td class=&quot;sorting_3&quot;&gt;I-AP-AMRP-ENB-6000&lt;/td&gt;&lt;td&gt;INAPAMRPAMRPTW6001&lt;/td&gt;&lt;td&gt;AMARAPURAM&lt;/td&gt;&lt;td&gt;0&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;&lt;td&gt;09/07/2019&lt;/td&gt;&lt;td&gt; &lt;/td&gt;&lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;&lt;td class=&quot;sorting_1&quot;&gt;ASSIGNED TO VENDOR&lt;/td&gt;&lt;/tr&gt;&lt;tr role=&quot;row&quot; class=&quot;even&quot;&gt;&lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&lt;td class=&quot;sorting_3&quot;&gt;I-AP-AMRP-ENB-6001&lt;/td&gt;&lt;td&gt;INAPAMRPXXXXTW6003&lt;/td&gt;&lt;td&gt;BASAVANAHALLI&lt;/td&gt;&lt;td&gt;0&lt;/td&gt;&lt;td&gt;3310744&lt;/td&gt;&lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;&lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;&lt;td&gt;09/07/2019&lt;/td&gt;&lt;td&gt; &lt;/td&gt;&lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;&lt;td class=&quot;sorting_1&quot;&gt;ASSIGNED TO VENDOR&lt;/td&gt;&lt;/tr&gt;&lt;tr role=&quot;row&quot; class=&quot;odd&quot;&gt;&lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&lt;td class=&quot;sorting_3&quot;&gt;I-AP-AMRP-ENB-6002&lt;/td&gt;&lt;td&gt;INAPAMRPXXXXTW6002&lt;/td&gt;&lt;td&gt;THAMMADEHALLI&lt;/td&gt;&lt;td&gt;0&lt;/td&gt;&lt;td&gt;3310744&lt;/td&gt;&lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;&lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;&lt;td&gt;09/07/2019&lt;/td&gt;&lt;td&gt; &lt;/td&gt;&lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;&lt;td class=&quot;sorting_1&quot;&gt;ASSIGNED TO VENDOR&lt;/td&gt;&lt;/tr&gt;&lt;tr class=&quot;disableRow even&quot; role=&quot;row&quot;&gt;&lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-6001&lt;/td&gt;&lt;td&gt;INAPAGLIXXXXTW6002&lt;/td&gt;&lt;td&gt;INAGALORE&lt;/td&gt;&lt;td&gt;0&lt;/td&gt;&lt;td&gt;3310744&lt;/td&gt;&lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;&lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;&lt;td&gt;09/07/2019&lt;/td&gt;&lt;td&gt; &lt;/td&gt;&lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;&lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;&lt;/tr&gt;&lt;tr class=&quot;disableRow odd&quot; role=&quot;row&quot;&gt;&lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-6002&lt;/td&gt;&lt;td&gt;INAPAGLIXXXXTW6003&lt;/td&gt;&lt;td&gt;KODIHALLI&lt;/td&gt;&lt;td&gt;0&lt;/td&gt;&lt;td&gt;3310744&lt;/td&gt;&lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;&lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;&lt;td&gt;09/07/2019&lt;/td&gt;&lt;td&gt; &lt;/td&gt;&lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;&lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;&lt;/tr&gt;&lt;tr class=&quot;disableRow even&quot; role=&quot;row&quot;&gt;&lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-9004&lt;/td&gt;&lt;td&gt;INAPHDPRXXXXTW0007&lt;/td&gt;&lt;td&gt;Thumakunta Check Post&lt;/td&gt;&lt;td&gt;0&lt;/td&gt;&lt;td&gt;3310744&lt;/td&gt;&lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;&lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;&lt;td&gt;09/07/2019&lt;/td&gt;&lt;td&gt; &lt;/td&gt;&lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;&lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;&lt;/tr&gt;&lt;tr class=&quot;disableRow odd&quot; role=&quot;row&quot;&gt;&lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-9005&lt;/td&gt;&lt;td&gt;INAPAGLIXXXXTW0003&lt;/td&gt;&lt;td&gt;P.bedagira village&lt;/td&gt;&lt;td&gt;0&lt;/td&gt;&lt;td&gt;3310744&lt;/td&gt;&lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;&lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;&lt;td&gt;09/07/2019&lt;/td&gt;&lt;td&gt; &lt;/td&gt;&lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;&lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;&lt;/tr&gt;&lt;tr class=&quot;disableRow even&quot; role=&quot;row&quot;&gt;&lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-9006&lt;/td&gt;&lt;td&gt;INAPAGLIXXXXTW0004&lt;/td&gt;&lt;td&gt;H D HALLI THANDA&lt;/td&gt;&lt;td&gt;0&lt;/td&gt;&lt;td&gt;3310744&lt;/td&gt;&lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;&lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;&lt;td&gt;09/07/2019&lt;/td&gt;&lt;td&gt; &lt;/td&gt;&lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;&lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;&lt;/tr&gt;&lt;tr class=&quot;disableRow odd&quot; role=&quot;row&quot;&gt;&lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-9007&lt;/td&gt;&lt;td&gt;INAPAGLIAGLITW0001&lt;/td&gt;&lt;td&gt;sira road&lt;/td&gt;&lt;td&gt;0&lt;/td&gt;&lt;td&gt;3310744&lt;/td&gt;&lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;&lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;&lt;td&gt;09/07/2019&lt;/td&gt;&lt;td&gt; &lt;/td&gt;&lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;&lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;&lt;/tr&gt;&lt;tr class=&quot;disableRow even&quot; role=&quot;row&quot;&gt;&lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;&lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;&lt;td class=&quot;sorting_3&quot;&gt;I-AP-AMLD-ENB-6000&lt;/td&gt;&lt;td&gt;INAPAMLDAMLDTW0001&lt;/td&gt;&lt;td&gt;AMIDALAGONDI&lt;/td&gt;&lt;td&gt;0&lt;/td&gt;&lt;td&gt;3310744&lt;/td&gt;&lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;&lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;&lt;td&gt;09/07/2019&lt;/td&gt;&lt;td&gt; &lt;/td&gt;&lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;&lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;

&lt;!-- end snippet --&gt;

Also the fiddle is provided for the same.

[JS Fiddle][1]


  [1]: https://jsfiddle.net/3an8pqkd/1/

</details>


# 答案1
**得分**: 1

我假设您想要在DataTable中进行`filter`操作并获取JSON数组。尽管没有直接的解决方案来满足您的需求,但我们可以通过一些jQuery技巧来实现。

在我的fiddle中,我首先获取了来自DataTable的所有行,并从这个数组中删除了不必要的数据。

完成这一步后,我使用jQuery获取了列的列表。

最后一步是通过循环遍历行和列来创建最终的JSON数组。因此,最后的`filtered_data`是您想要的输出。

如果这不是您想要的,请告诉我。

您也可以查看以下的fiddle链接。

[JS FIDDLE][1]

[1]: https://jsfiddle.net/3dkgbc20/


<details>
<summary>英文:</summary>

I assume you want to `filter` the DataTable and get the `JSON` array. Though there is no such direct solution to your need, we can do it with some `jQuery` trick.

What I have done in my fiddle is that I am first getting all the `rows` from `DataTable` and have removed unnecessary data from this array.

Once this is complete, I am getting the list of columns using `jQuery`.

The final step is to create the final `JSON` array by looping through rows and columns. Hence, in the end, `filtered_data` is your desired output.

Kindly let me know if this is not what you are looking form.

Also, You can check the following fiddle.

[JS FIDDLE][1]


  [1]: https://jsfiddle.net/3dkgbc20/

&lt;!-- begin snippet: js hide: false console: true babel: false --&gt;

&lt;!-- language: lang-js --&gt;

    var table = $(&#39;#certifyEFO&#39;).DataTable();
    var raw_data = table.rows().data().toArray();
    for (var i in raw_data){
    	raw_data[i].splice(0,2);
    }
    var columns=[];
    $(&quot;#certifyEFO thead tr th&quot;).each(function(){
            columns.push(this.innerHTML.replace(&#39;\n&#39;, &#39;&#39;).replace(&#39;                                &#39;, &#39; &#39;).trim());
        });
    columns.splice(0, 2);
    // console.log(raw_data);
    var final_raw_data = [];
    raw_data.filter(function(item){
    	var row_item = {}
    	item.filter(function(item_inner, index){
      	row_item[columns[index]] = item_inner;
        return item_inner;
      });
      final_raw_data.push(row_item);
      return item;
    });
    var filtered_data = final_raw_data.filter(function(item){
    	return item[&quot;STATUS&quot;].toLowerCase() == &#39;cmm approved&#39;;
    })
    console.log(filtered_data);
    // Create new DataTable from filtered_data
    var columns_for_new_dt = [];
    columns.filter(function(item){
    	columns_for_new_dt.push({ &quot;data&quot; : item, &quot;title&quot; : item })
    });
    table = $(&#39;#new_data_table&#39;).DataTable( {
            columns: columns_for_new_dt,
            data:    filtered_data
    });


&lt;!-- language: lang-html --&gt;

    &lt;script src=&quot;https://cdn.datatables.net/1.10.0/css/jquery.dataTables.css&quot;&gt;&lt;/script&gt;

    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/jquery/1.9.1/jquery.min.js&quot;&gt;&lt;/script&gt;

    &lt;script src=&quot;https://cdn.datatables.net/1.10.0/js/jquery.dataTables.js&quot;&gt;&lt;/script&gt;
    &lt;table id=&quot;certifyEFO&quot;&gt;
        &lt;thead&gt;
                            &lt;tr role=&quot;row&quot;&gt;
                                &lt;th class=&quot;select-checkbox sorting_disabled&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot; style=&quot;width: 20px;&quot;
                                    aria-label=&quot;&quot;&gt;&lt;/th&gt;
                                &lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 42px;&quot; aria-label=&quot;Action: activate to sort column ascending&quot;&gt;Action
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting_asc&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 103px;&quot; aria-label=&quot;SAP ID: activate to sort column ascending&quot;&gt;SAP ID
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 132px;&quot; aria-label=&quot;NETWORK ENTITY ID: activate to sort column ascending&quot;&gt;
                                    NETWORK ENTITY ID
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 122px;&quot; aria-label=&quot;SITE NAME: activate to sort column ascending&quot;&gt;SITE
                                    NAME
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 103px;&quot; aria-label=&quot;ASSESTS COUNT: activate to sort column ascending&quot;&gt;
                                    ASSESTS COUNT
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 91px;&quot; aria-label=&quot;SERVICE CODE: activate to sort column ascending&quot;&gt;
                                    SERVICE CODE
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 426px;&quot; aria-label=&quot;SHORT DESC: activate to sort column ascending&quot;&gt;SHORT
                                    DESC
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting_asc&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 78px;&quot; aria-label=&quot;SITE STATUS: activate to sort column ascending&quot;&gt;SITE
                                    STATUS
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 68px;&quot; aria-label=&quot;RFE1 DATE: activate to sort column ascending&quot;&gt;RFE1 DATE
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 62px;&quot; aria-label=&quot;RFR DATE: activate to sort column ascending&quot;&gt;RFR DATE
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 163px;&quot; aria-label=&quot;VENDOR: activate to sort column ascending&quot;&gt;VENDOR
                                &lt;/th&gt;
                                &lt;th class=&quot;sorting_asc&quot; tabindex=&quot;0&quot; aria-controls=&quot;certifyEFO&quot; rowspan=&quot;1&quot; colspan=&quot;1&quot;
                                    style=&quot;width: 114px;&quot; aria-label=&quot;STATUS: activate to sort column descending&quot;
                                    aria-sort=&quot;ascending&quot;&gt;STATUS
                                &lt;/th&gt;
                            &lt;/tr&gt;
                            &lt;/thead&gt;
        &lt;tbody id=&quot;datagrdbody&quot;&gt;
                        &lt;tr role=&quot;row&quot; class=&quot;odd&quot;&gt;
                            &lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_3&quot;&gt;I-AP-AMRP-ENB-6000&lt;/td&gt;
                            &lt;td&gt;INAPAMRPAMRPTW6001&lt;/td&gt;
                            &lt;td&gt;AMARAPURAM&lt;/td&gt;
                            &lt;td&gt;0&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;
                            &lt;td&gt;09/07/2019&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;
                            &lt;td class=&quot;sorting_1&quot;&gt;ASSIGNED TO VENDOR&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;tr role=&quot;row&quot; class=&quot;even&quot;&gt;
                            &lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_3&quot;&gt;I-AP-AMRP-ENB-6001&lt;/td&gt;
                            &lt;td&gt;INAPAMRPXXXXTW6003&lt;/td&gt;
                            &lt;td&gt;BASAVANAHALLI&lt;/td&gt;
                            &lt;td&gt;0&lt;/td&gt;
                            &lt;td&gt;3310744&lt;/td&gt;
                            &lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;
                            &lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;
                            &lt;td&gt;09/07/2019&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;
                            &lt;td class=&quot;sorting_1&quot;&gt;ASSIGNED TO VENDOR&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;tr role=&quot;row&quot; class=&quot;odd&quot;&gt;
                            &lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_3&quot;&gt;I-AP-AMRP-ENB-6002&lt;/td&gt;
                            &lt;td&gt;INAPAMRPXXXXTW6002&lt;/td&gt;
                            &lt;td&gt;THAMMADEHALLI&lt;/td&gt;
                            &lt;td&gt;0&lt;/td&gt;
                            &lt;td&gt;3310744&lt;/td&gt;
                            &lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;
                            &lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;
                            &lt;td&gt;09/07/2019&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;
                            &lt;td class=&quot;sorting_1&quot;&gt;ASSIGNED TO VENDOR&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;tr class=&quot;disableRow even&quot; role=&quot;row&quot;&gt;
                            &lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-6001&lt;/td&gt;
                            &lt;td&gt;INAPAGLIXXXXTW6002&lt;/td&gt;
                            &lt;td&gt;INAGALORE&lt;/td&gt;
                            &lt;td&gt;0&lt;/td&gt;
                            &lt;td&gt;3310744&lt;/td&gt;
                            &lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;
                            &lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;
                            &lt;td&gt;09/07/2019&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;
                            &lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;tr class=&quot;disableRow odd&quot; role=&quot;row&quot;&gt;
                            &lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-6002&lt;/td&gt;
                            &lt;td&gt;INAPAGLIXXXXTW6003&lt;/td&gt;
                            &lt;td&gt;KODIHALLI&lt;/td&gt;
                            &lt;td&gt;0&lt;/td&gt;
                            &lt;td&gt;3310744&lt;/td&gt;
                            &lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;
                            &lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;
                            &lt;td&gt;09/07/2019&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;
                            &lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;tr class=&quot;disableRow even&quot; role=&quot;row&quot;&gt;
                            &lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-9004&lt;/td&gt;
                            &lt;td&gt;INAPHDPRXXXXTW0007&lt;/td&gt;
                            &lt;td&gt;Thumakunta Check Post&lt;/td&gt;
                            &lt;td&gt;0&lt;/td&gt;
                            &lt;td&gt;3310744&lt;/td&gt;
                            &lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;
                            &lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;
                            &lt;td&gt;09/07/2019&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;
                            &lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;tr class=&quot;disableRow odd&quot; role=&quot;row&quot;&gt;
                            &lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-9005&lt;/td&gt;
                            &lt;td&gt;INAPAGLIXXXXTW0003&lt;/td&gt;
                            &lt;td&gt;P.bedagira village&lt;/td&gt;
                            &lt;td&gt;0&lt;/td&gt;
                            &lt;td&gt;3310744&lt;/td&gt;
                            &lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;
                            &lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;
                            &lt;td&gt;09/07/2019&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;
                            &lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;tr class=&quot;disableRow even&quot; role=&quot;row&quot;&gt;
                            &lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-9006&lt;/td&gt;
                            &lt;td&gt;INAPAGLIXXXXTW0004&lt;/td&gt;
                            &lt;td&gt;H D HALLI THANDA&lt;/td&gt;
                            &lt;td&gt;0&lt;/td&gt;
                            &lt;td&gt;3310744&lt;/td&gt;
                            &lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;
                            &lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;
                            &lt;td&gt;09/07/2019&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;
                            &lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;tr class=&quot;disableRow odd&quot; role=&quot;row&quot;&gt;
                            &lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_3&quot;&gt;I-AP-AGLI-ENB-9007&lt;/td&gt;
                            &lt;td&gt;INAPAGLIAGLITW0001&lt;/td&gt;
                            &lt;td&gt;sira road&lt;/td&gt;
                            &lt;td&gt;0&lt;/td&gt;
                            &lt;td&gt;3310744&lt;/td&gt;
                            &lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;
                            &lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;
                            &lt;td&gt;09/07/2019&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;
                            &lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;tr class=&quot;disableRow even&quot; role=&quot;row&quot;&gt;
                            &lt;td class=&quot;select-checkbox&quot;&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;a class=&quot;actionIcon&quot; id=&quot;discripancy&quot;&gt;&lt;i class=&quot;fa fa-flag&quot;&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
                            &lt;td class=&quot;sorting_3&quot;&gt;I-AP-AMLD-ENB-6000&lt;/td&gt;
                            &lt;td&gt;INAPAMLDAMLDTW0001&lt;/td&gt;
                            &lt;td&gt;AMIDALAGONDI&lt;/td&gt;
                            &lt;td&gt;0&lt;/td&gt;
                            &lt;td&gt;3310744&lt;/td&gt;
                            &lt;td&gt;SMALL CELL INDOOR WITHOUT DGS / SMALL CELL INDOOR WITHOUT DGS&lt;/td&gt;
                            &lt;td class=&quot;sorting_2&quot;&gt;ACTIVE&lt;/td&gt;
                            &lt;td&gt;09/07/2019&lt;/td&gt;
                            &lt;td&gt;&lt;/td&gt;
                            &lt;td&gt;Delton Infra P Limited - 396475&lt;/td&gt;
                            &lt;td class=&quot;sorting_1&quot;&gt;CMM APPROVED&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;/tbody&gt;
    &lt;/table&gt;
    &lt;b&gt;NEW DataTable from filtered_data&lt;/b&gt;
    &lt;table id=&quot;new_data_table&quot;&gt;&lt;/table&gt;

&lt;!-- end snippet --&gt;

**EDIT**

Also, You can check the following fiddle which has new Data Table for filtered data..

[JS FIDDLE][1]


  [1]: https://jsfiddle.net/xv9ewuna/1/

</details>



huangapple
  • 本文由 发表于 2020年1月3日 13:44:49
  • 转载请务必保留本文链接:https://go.coder-hub.com/59573724.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定