Answers

• colin Posts: 15,240Questions: 1Answers: 2,599

  February 2018

  Hi Feraud,

  Yep, you can create a custom search which when triggered calls one of the search methods - this can be on the entire table, a single column, or a set of columns. If you specify a regex search (true for the second parameter), and wrap the search text between a '^' (start of text) and a '$' (end of text), you'll get the behaviour you want!

  So, something like

  $('#example').DataTable().column(0).search('^' + searchString + '$',true).draw()
  

  Hope that helps,

  Cheers,

  Colin
• kthorngren Posts: 21,343Questions: 26Answers: 4,954

  February 2018

  Not sure I understand the question but maybe this example will help you:
  https://datatables.net/examples/api/regex.html

  Kevin
• Feraud Posts: 20Questions: 6Answers: 0

  February 2018

  @colin, @kthorngren: thanks for answering.

  Defining a RegEx executes always the same logic. I need an "if".

  If the search encounters a complete hit (as in @colin's regex) only this row is shown.
  If there is no complete hit, all rows containing search expression are shown.
• colin Posts: 15,240Questions: 1Answers: 2,599

  February 2018

  Ah, sorry @Feraud, yep, I missed that bit about the "OF" showing the two.

  Take a look at this live example, this should do what you're looking for.

  C
• colin Posts: 15,240Questions: 1Answers: 2,599

  February 2018 Answer ✓

  @Feraud - please reload if you've looked at it already, I've made a slight tweak. This is the final code here, for prosperity!

  $(document).ready( function () {
    var table = $('#example').DataTable({
      "dom": '<"top"i>rt<"bottom"><"clear">'
    });
    
    $('#mySearch').on( 'keyup click', function () {
          table.column(0).search('^' + $(this).val() + '$', true);
          if (table.page.info().recordsDisplay != 1) {
            table.column(0).search('^' + $(this).val(), true);
          }
      
          table.draw();
      } );
  } );
  
• Feraud Posts: 20Questions: 6Answers: 0

  February 2018 edited February 2018

  @colin: That looks very, very promising. I will check it out during the week-end.

  I wasn't aware about recordsDisplay. Nice 2 step procedure!

  Will inform you about the final outcome
• colin Posts: 15,240Questions: 1Answers: 2,599

  February 2018

  Excellent, don't work too hard over the weekend! Shout if you have any more questions...

  C
• Feraud Posts: 20Questions: 6Answers: 0

  February 2018

  It's not work - it's fun using datatables!
• Feraud Posts: 20Questions: 6Answers: 0

  February 2018

  @colin : the symbol search:

  https://dividendstocks.cash/dividend-calendar

  
• colin Posts: 15,240Questions: 1Answers: 2,599

  February 2018

  Hi Torsten,

  Nice, that looks good! Glad to see you got it up and running!

  Cheers,

  Colin