Drop-down menu sorting and widget searching

Hi,

Thanks for the great plugin! I am having some trouble with the prefiltering. I have installed the DataTables Automatic Filtering plugin and I’m trying to create a hyperlink within my widgets to filter the table by search criteria. Here are two examples:

<a href="http://digital805.com/beai/datasheets_sds/adhesive-by-properties/?table_filter=ELECTRICALLY CONDUCTIVE">ELECTRICALLY CONDUCTIVE</a>
<a href="http://digital805.com/beai/datasheets_sds/adhesive-by-properties/?table_filter=FLEXIBLE">FLEXIBLE</a>

I’m a bit lost by the instructions. Can you help?

Thank you!

I went ahead and added the row filtering extension and still no luck.

I also applied the code change, in the GET parameter plug in, where 'filter' is changed to 'datatables_auto_filter', like this:
$attributes['datatables_auto_filter'] = $filter_term;

Per the instructions row filtering not needed and has been disabled.

I’m sorry for the multiple submissions. This is my final step before launching. Thank you!

• This reply was modified 8 years, 11 months ago by Digital 805. Reason: additional changes made

Hi, The table filter shortcode is working fine on the page. I’m trying to create a simple text link from elsewhere within the site like this:

<a href="http://digital805.com/beai/datasheets_sds/adhesive-by-properties/?table_filter=FLEXIBLE">FLEXIBLE</a>

I have installed Shortcode Filter from GET parameter plugin and DataTables Automatic Filtering.

Using the shortcode would work too, but I want the drop down to display on it’s own page and then filter when directing to the page that contains the data.

I hope that is clear. Thanks!

Ok, thank you. If the drop-down wont work out of the box, I’ll stick with the direct link. You said, “So something in the chain of Extensions is not yet set-up properly.” What do you mean by that? Is it something in your plugin or something that I didn’t do? Can you provide direct instructions on this type of link? Thank you.

Yes, I changed the code. Here is the entire php.

<?php
/*
Plugin Name: TablePress Extension: Shortcode Filter from GET parameter
Plugin URI: https://tablepress.org/extensions/shortcode-filter-get-parameter/
Description: Custom Extension for TablePress to use the Row Filter extension with a filter term from a $_GET parameter
Version: 1.0
Author: Tobias Bäthge
Author URI: https://tobias.baethge.com/
*/

/*
 * The Shortcode: [table_filter id=123 /]
 * will be filtered for http://example.com/?table_filter=myfilterword
 */

function tablepress_filter_shortcode( $attributes, $content ) {
	if ( ! empty( $_GET['table_filter'] ) ) {
		$filter_term = $_GET['table_filter'];
		/*
		 * Only allow characters a-z, A-Z, 0-9, and spaces in the filter term.
		 * This regular expression needs to be extended if other characters shall be allowed.
		 */
		$filter_term = preg_replace( '#[^a-z0-9 ]#i', '', $filter_term );
		$attributes['datatables_auto_filter'] = $filter_term;
	}
	return tablepress_get_table( $attributes );
}

if ( ! is_admin() ) {
	add_shortcode( 'table_filter', 'tablepress_filter_shortcode' );
}

Here is my shortcode for the page:

[table_filter id=4 datatables_columnfilterwidgets=true datatables_columnfilterwidgets_exclude_columns=1,3,4,5 /]

Thanks for your help.

• This reply was modified 8 years, 11 months ago by Digital 805.

Here is my shortcode:
[table_filter id=4 datatables_columnfilterwidgets=true datatables_columnfilterwidgets_exclude_columns=1,3,4,5 /]

The plugins I have activated are:
TablePress Extension: DataTables Automatic Filtering
TablePress Extension: DataTables ColumnFilterWidgets
TablePress Extension: Shortcode Filter from GET parameter

I see what it doing now. It is pulling keywords from the description, rather than displaying the property category ‘flexible’ as the drop down does. How can I get it to display to exclude_columns=1,3,4,5 and function like the drop down on that page?