Only Enable Visitors to Search Specific Column

Hi,

thanks for your post!

I’m not sure that I understood correctly, but limiting the search/filter to just one column is possible with a “Custom Command” for the DataTables JS library. Please try adding this to the “Custom Commands” textfield on the “Edit” screen of the table:

"aoColumnDefs": [ { "bSearchable": false, "aTargets": [ 1,2,3,4,5,6 ] } ]

The list in the aTargets parameter is the list of column number (important: counting starts with 0!) that shall not be searchable. You’ll just need to adjust that to the number of columns. In the example, column 1 would be searchable, while columns 2 through 7 would not be searchable.

Regards,
Tobias

You have the right idea, I would enter the following so that only column on e is searchable:

“aoColumnDefs”: [ { “bSearchable”: false, “aTargets”: [ 2,3,4,5,6 ] } ]

The problem is that the search box dissapears and all the content of the table appear.

See the site below:

https://gslandsurveying.com/?page_id=162

I think I figured it out, I didnt get the numbering right ??

I put the following and it worked:

“aoColumnDefs”: [ { “bSearchable”: false, “aTargets”: [ 1,2,3,4 ] } ]

You are amazing! How do I donate to your site?

One last question,

Can the filter be limited to recognize only whole values of the column.

Customer ID:
02-2016
03-2016
04-2016

When I enter just the number 6, all of the entries show up

I think it is more clear to say that the search box only recognizes exact terms on the columns, and doesn’t show any results until the all numbers are satisfied, ie only shows results when 02-2016 is typed. But if someone types in just 6 in the search nothing will show up.

Hi,

yes, for your table,

"aoColumnDefs": [ { "bSearchable": false, "aTargets": [ 1,2,3,4 ] } ]

is correct.

About searching whole values: Unfortunately, I don’t know if that is possible ?? That would probably require a change in the DataTables JS library from https://www.datatables.net, that TablePress uses for this.

To support TablePress with a donation, please see https://tablepress.org/donate/ . Thank you very much, I really appreciate it!

Regards,
Tobias

What if I set the search box to only show results when the enter button is pressed.

I found this code from one of your previous posts:

add_filter( ‘tablepress_datatables_command’, ‘tablepress_filter_on_enter’, 10, 5 );
function tablepress_filter_on_enter( $command, $html_id, $parameters, $table_id, $js_options ) {
$name = ‘DT_’ + str_replace( ‘-‘, ‘_’, $html_id );
$command = <<<JS
var {$name} = $(‘#{$html_id}’).dataTable({$parameters});
$(‘#{$html_id}_filter input’).unbind().bind(‘keyup’, function(e) {
if( 13 == e.keyCode )
{$name}.fnFilter( this.value );
});
JS;
return $command;
}

Im just not sure where in the functions.php it should go?

The code below worked, it just wasn’t closed when you posted it. Thanks for you help!! ??

<?php 

add_filter( 'tablepress_datatables_command', 'tablepress_filter_on_enter', 10, 5 );
function tablepress_filter_on_enter( $command, $html_id, $parameters, $table_id, $js_options ) {
 $name = 'DT_' . str_replace( '-', '_', $html_id );
 $command = <<<JS
var {$name} = $('#{$html_id}').dataTable({$parameters});
$('#{$html_id}_filter input').unbind().bind('keyup', function(e) {
 if( 13 == e.keyCode )
  {$name}.fnFilter( this.value );
});
JS;
 return $command;
}

?>

[Moderator Note: Please post code & markup between backticks or use the code button. Your posted code may now have been permanently damaged by the forum’s parser.]

Hi,

very nice! Yes, that code should help. It will not prevent someone from search for “6”, but it will stop the results from from showing up immediately, which might be enough already ??

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!