Search

textbox there is no filtering and datatables shows all

Hi, First of all, thanks for your help in advance and datatable is great. I have question about the following code: if (idx === 3) { dt.column(3, { search: 'applied' }) .data(toString) .unique() .sort() .each(function (d, j) { { if (renderFunction == null) { select.append('' + d + ''); } else { select .append('' + renderFunction(d, 'display', null) + ''); } } }); } The issue is the column.data is actually a list of string from view model. In this case, it is an array, and from other posts I know unique does not work for arrays. I tried to use tostring to convert the data before calling unique, but it's not working. I can't really figure this out. Could anyone help on that? Thanks!

I want to load the data on the server side (server side) but when looking for any content I do not want to be server side with sql queries for example: Quiero cargar los datos del lado del servidor (server side) pero a la hora de buscar cualquier contenido no quiero que se haga del lado del servidor con consultas sql por ejemplo: if( !empty($params['search']['value']) ) { $where .=" WHERE ( nombre LIKE '%".$params['search']['value']."%' )"; $where .=" OR employee_salary LIKE '".$params['search']['value']."%' "; $where .=" OR employee_age LIKE '".$params['search']['value']."%' )"; } Is there any way to do this?

I used this https://datatables.net/blog/2014-10-22#Released-code to add highlighting to my datatable and it works great using the main search input, but my datatable also use column search/filter. How can I get the highlighting to also work with the column search input.

Hi, while programming simple variants yourself is not a too big thing, it leads to code dependencies, testing, covering different use cases and so on. it would be very nice to have that built in for simpler cases like , input field with datatype format, select box, with row values (like excel), or set datasource , date widget, and so on. Planning for that ? Thanks for informing, Michael

And set .withColumnFilter for filtering tables. .withColumnFilter({ aoColumns: [ null,

I need to implement functionality to update searchable property value dynamically. I am able to set option dynamically, it is setting but search is not updating. dtObj.settings()[0].aoColumns[0].bSearchable = true; By default, Let take column 1 is searchable. I am changing its searchable to false. It is not updating. I mean datatable based on this search update it is not working. To apply this search changes, I need to clear datatable, and rebind whole data. Then only it is working. Is there any other option to make it work with our clearing of data.

hi, i am using angularjs in django template html and in that i am used data table but searching,sorting not work in that my tempalte is {% extends "base.html" %} {% block ngapp %} ng-app="premisesApp" {% endblock %} {% block js %} <script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.5.8/angular.min.js"></script> <script src="/static/js/country_angular.js"></script> <script src="https://code.jquery.com/jquery-1.12.4.js"></script> <script src="https://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js"></script> <script type="text/javascript"> $(document).ready(function(){ $('#areaTable').DataTable(); }); </script> {% endblock %} {% block content %} <div class="content"> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <div class="card"> <div class="header"> <h4 class="title">Premises List</h4> </div> <div class="content table-responsive table-full-width"> <table id="areaTable" class="table table-hover table-striped" ng-controller="PremiseCtrl"> <thead> <tr> <th>name</th> <th>description</th> <th>Edit</th> <th>Delete</th> </tr> </thead> <tbody> {% verbatim %} <tr ng-repeat="premise in premises.premises"> <td>{{premise.name}}</td> <td>{{premise.description}}</td> <td><a href="/app/edit-premises/{{premise.id}}/">Edit</a></td> <td> <a href="#" ng-click="premiseDelete(premise.id)">Delete</button></td> </tr> {% endverbatim %} </tbody> </table> </div> </div> </div> </div> </div> </div> {% endblock %}

Datatable plugin for Column Filtering in my Angular Datatable.

plz give the entair code for full length code