How to set the default text value of a columnfilter for the datatables jquery api

Question

How can I set the default text value for the input field for the columnfilter plugin for the datatables api?

 $(document).ready(function () {

         var t1 = $( '#test').dataTable({

         }).columnFilter();

My table has several columns and I have tried setting the input box to have a default serach value as:

 $("input:eq(6)").val("myDefaultValue");

But this just displays myDefultValue in the search box , but doe not apply the filter.

I also tried triggering change and keydown, but both fail.

I am testing in Chrome, any ideas?

M'sieur Toph' · Accepted Answer · 2014-05-14 07:59:31Z

3

Sorry for my first post. I red wrong the api doc.

See this page : http://datatables.net/reference/api/column().search()

You need to select the column and then use the search() method.

$( '#test')
    .columns(6) // to select the sixth column
    .search('myDefaultValue')
    .draw();

It should work better.

I delete my first post.

answered May 14, 2014 at 7:59

M'sieur Toph'

2,6761 gold badge25 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

shelbypereira Over a year ago

This works also! Thanks, and as you point it is a cleaner solution, which directly exploits the existing API.

shelbypereira · Accepted Answer · 2014-05-14 08:06:59Z

0

UPDATE: Following the idea from Msieur Toph to try to trigger the search event, I have found the solution (by looking at the columnfilter source code), which is to trigger the keyup event.

$("input:eq(6)").val("myDefaultVal").trigger('keyup');

answered May 14, 2014 at 8:06

shelbypereira

2,2753 gold badges32 silver badges56 bronze badges

1 Comment

M'sieur Toph' Over a year ago

As I said in the new post I have made, he should better use the search function on the column. Your solution propably works (I guess it does the exact same thing), but it is kind of dirty, no ? I think it is better to use the native API methods.

Collectives™ on Stack Overflow

How to set the default text value of a columnfilter for the datatables jquery api

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related