Answers

• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  March 2016

  Thanks for your question - however, per the forum rules can you link to a test case showing the issue please. This will allow the issue to be debugged.

  Information on how to create a test page], if you can't provide a link to your own page can be found here.

  Thanks,
  Allan
• vertisan Posts: 7Questions: 2Answers: 0

  March 2016

  Ofc, here is website, where is implemented DataTables and where is problem.
  http://demo.vrs-factory.pl/DT/
  If is needed PHP Code - tell me.
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  March 2016

  The client is sending the following to the server for the column search:

  columns[1][search][value]:^Florence Figueroa$
  

  Is your server-side processing script configured to accept regular expressions? I suspect not and that is the issue.

  I would suggest, at least in the first instance, that you drop the regular expressions - I doubt you need it with server-side processing.

  Allan
• vertisan Posts: 7Questions: 2Answers: 0

  March 2016

  Here is my PHP code (I using CodeIgniter)
  Controller (creating array for DataTables)
  http://pastebin.com/wq7s9XqH

  Model (getting data from DB)
  http://pastebin.com/SU32GmFF
• vertisan Posts: 7Questions: 2Answers: 0

  March 2016

  REF
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  March 2016

  I'm afraid I don't support custom server-side code, but on a quick scan it looks like it isn't configured to support regular expressions. Either you need to change your server-side code to accept regular expressions (and the performance penalty that comes with that in SQL) or you need to not send a regular expression to the server-side.

  Allan
• alderhernandez Posts: 33Questions: 11Answers: 1

  April 2016 edited April 2016

  hey @vertisan, you solve the problem??? i want do the same thing in my proyect
• equinox Posts: 1Questions: 0Answers: 0

  May 2016

  i found the way how to do this on
  http://coderexample.com/datatable-custom-column-search/

  but i must specify what column i want to have custom search one by one in model and view :x
  and this still show first page data only

  on my view im using initcomplete

  $(document).ready(function() { 
                        lengthMenu: [[5, 10, 25, -1], [5, 10, 25, "All"]],
                        processing: true, //Feature control the processing indicator.
                        serverSide: true, //Feature control DataTables' server-side processing mode.
                ajax: {
                                   "url": "<?php echo site_url('Barang/ajax_list');?>",
                                   "type": "POST"
                         },
                         language: {
                                  "url": "<?php echo base_url();?>assets/lang/Indonesian.json"
                          },
                   initComplete: function () {
  
              this.api().columns([1]).every( function () {// i tried this on one column only
                  var column = this;
                  var select = $('<select><option value=""></option></select>')
                                      .appendTo( $(column.footer()).empty() )
                                       .on( 'change', function () {
                                       var val = $.fn.dataTable.util.escapeRegex(
                              $(this).val()
                          );
    
                          column
                             .search(val)
                              .draw();
                      } );
    
                  column.data().unique().each( function ( d, j ) {
                      //console.log(d);
                      //console.log(j);
                      select.append( '<option value="'+d+'">'+d+'</option>' )
                  } );
              } );
          },
  etcetc
  

  my controller
  http://pastebin.com/LRuNHYbv
  my model
  http://pastebin.com/XtaKDTMG

  just add this code above if($_POST['search']['value']) to get request from datatable based on selected column at "this.api().columns([1])"

  if($_POST['columns']['1']['search']['value'])
              {
                  if($i===0) // first loop
                  {
                      
                      $this->db->group_start(); 
                      $this->db->like($item, $_POST['columns']['1']['search']['value']);
                  }
                  else
                  {
                      $this->db->or_like($item, $_POST['columns']['1']['search']['value']);
                  }
  
                      if(count($this->column) - 1 == $i) //last loop
                      $this->db->group_end(); //close bracket 
                  
              }
  

  the example result
  https://goo.gl/photos/EMN3NhWNiYHSQNRz7