callard

Hello Tobias,

Thank you kindly for bearing with me on this – it worked (of course)!

Kind Regards,
Callard

Tobias, Thank You.

When an apostrophe is inserted into Line 23 it returns the following error message:

Your PHP code changes were rolled back due to an error on line 23 of file wp-content/plugins/tablepress-shortcode-filter-get-parameter/tablepress-shortcode-filter-get-parameter.php. Please fix and try saving again.
syntax error, unexpected ‘]’, expecting ‘,’ or ‘)’

This is understandable as it is reading it as code instead of as a term. It is important the Apostrophe GET commands are working as they occur frequently; Is there a workaround?

Kind Regards,
Callard

re: 3. Shucks, I had hoped the GET parameter would respect variables applied to the tables themselves. Oh, well. ?? TablePress is still a powerful little extension!

Thank you for your patience and guidance. This is exactly why I don’t code.

With:
$filter_term = preg_replace( '#[^a-z0-9 , -]#i', '', $filter_term );
or Line 23 // :

Working w/ Line 23 & //: Two Words Word, Word1, Word2
Working w/ Line 23 but breaks //: =%22word1%20word2%22
Works // Not-working w/ Line 23: cross%2Dreference
Not-Working Either is Anything with an apostrophe: Word's

3. The filter_table employs:
"columnDefs": [ { "searchable": false, "targets": [0, 2, 3 ] } ]

This is working when the data is searched from the Search box. If searching data only in these columns there are no results. Yay! ??

However, when employing a GET filter through a URL using text only used in columns 0, 2, 3 it returns results for data in columns 0, 2, 3. The purpose of the GET & the columnDefs is to only show data from column 1. Is the GET supposed to respect the “searchable”: false, “targets”: ?

That makes sense, thank you once more! Variables for PHP, CSS, HTML and other options had been tried but URL had been missed; the URL one is the most logical. Your extension codes are beautifully replete.

The added URL terms have been added as follows:

$filter_term = preg_replace( '#[^a-z0-9 %27 %22 %2D %26 %20 %2C]#i', '', $filter_term );

I’ve been playing around and there are a couple strange issues, I’m sure they are straight forward but currently outside my scope:

1. =Cross =Cross%2D and =%2DReference are working, however =cross%2Dreference breaks the table.

2. apostrophe =word%27s breaks the table and =%27s returns everything as does ampersand =%26?

3. The GET filter is searching columnDefs false is there a way to make sure it does not search this column?

Kind Regards,
Callard

• This reply was modified 4 years, 3 months ago by callard.
• This reply was modified 4 years, 3 months ago by callard.
• This reply was modified 4 years, 3 months ago by callard.

Hello Tobias,

Thank you! That tip is working well, various symbols have been added as a test (dash, comma, etc) and are working on their own.

Is there a trick to getting special characters to work? Such as an apostrophe, non-breaking space, or ampersand working? IE.

https://example.com/?table_filter=apostrophe&pos;s

Does not return results with “apostrophe’s” but rather returns results with, “apostrophe” and seems to ignore the “‘s”. IE.

https://example.com/?table_filter=&

Returns the whole table instead of the single entry with an & symbol. Same with specific symbols such as π or § ?

And is there a way to search a phrase in GET? IE. “another word” or “anther’s word” or “§ yet another π”

A variety of combinations have been attempted but nothing seems to be working.

Kind Regards,
Tiffany

• This reply was modified 4 years, 3 months ago by callard.

Shucks, I was hoping your insider knowledge would come up with a hidden gem. But if you can code, why wouldn’t you?! ??

In regards to the GET function, is there a way to GET a short phrase? as in

?table_filter=more-than-one-word

If I’m understanding correctly this has to be alphanumeric; is there a way to allow it to include other characters? as in

?table_filter=symbol-for-pi

Sorry, if there are answers to these questions in the forums, I’ve looked but could very easily have missed them.

Kind Regards,
Callard

Thank you Tobias, that is something to think about! Options in that regard are currently being researched. As a non-coder it’s a bit of a patch and snap arrangement.

TablePress is perfect for a part of this project and discovering it has been exiting and promising in a variety of areas. I look forward to continuing its use and promotion to others.

Another part of the project requires a heavy data set that might work better with a unified database. Would you know of a database tool for a large (large) set of data that might lend itself well to someone not at all versed in coding?

Kind Regards,
Callard

Everything is very fine. Turning out a fine day ??

That is it indeed. I shall make a concerted effort to count properly (and triple-check full plugin names). As there are hidden columns they shall be made invisible using CSS instead of the Hide column button that way they can remain searchable.

This is a learning curve, thank you for making it an enjoyable one.

Kind Regards,
Callard

Oh, I feel so silly for wasting your time on that. My sincere apology. I must have read row order as row filter. The row filter is active now, it and the GET function works flawlessly (of course).

Thank you kindly for taking the time to provide such stellar support.

Upright quotes you say? *ponders* Something new to learn all the time!

[table id=1 filter=” advent || advent.” /] works like a charm.

Coders have impeccable attention to details. ??

Kind Regards,
Callard

Thank you very much Tobias!

I feel so silly. I had thought to try quotes and it didn’t work and spaces but for some reason not quotes and space. *facepalm*

Is there a way to employ this technique with Row Filtering?

ie. The word “advent” may show in a cell with a full sentence “Today is advent.” And another that says, “This is an adventure.” There are ~6,000 rows with lets say ~22 usages of the word “Advent.” I would like to filter a table to show only cells that contain “Advent.”

[table id=1 filter=”advent” /] Shows “Advent” and “Adventure”
[table id=1 filter= ” advent “/] breaks the table

DataTables looks like a more ideal solution but as a non-coder TablePress should suffice nicely. Once again, thank you for making life easier. ?? Your kindness is greatly appreciated.

Many Thanks,
Callard