Search

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

This table is very nice and automatically generates items for drop down choices: https://datatables.net/examples/api/multi_filter_select.html But I have table cells with much content and I wish to create dropdown searches for each column with a restricted list of keywords. Is there an example of multi_filter_select.html with self created list of search items?