custom filtering function

Hi,

thanks for your question, and sorry for the trouble.

Your best chance for this is to do the DataTables integration manually, i.e. let TablePress only produce the table HTML code. Then, load and call the DataTables JavaScript code manually.

Regards,
Tobias

Hi I have one more question,

Some columns have too many data, is there any function allow us to show the first 2 rows of words in one cell and ppl can see more data when they click the “show more” button?

Here is the table,
https://35.224.75.211/927-2/

We want to show 2 investors first, then ppl can click show more button if they want to see more details.

Thank!

Sorr, can you explain more on DataTables integration?

How can I load and call the JavaScript code manually? Does it mean that we should add the code to the plugin editor page?

Hi Tobiasbg,

I am using your plugin and it is exactly what I was looking for.
I have seen dozens of video-tutorials and read the FAQ, but I can’t show-up filters above my table. What am I doing wrong? Which extension do I need to install in order to show-up the filter table as on the demo?

Thanks

Hi,

connie18hall: Unfortunately, I can only refer you to the DataTables documentation at https://datatables.net/manual/installation here. TablePress will deliver the HTML code, but you have to add the code to load the JS files and command (e.g. by putting that below the table Shortcode on the page).

arwingia: Most likely, there’s an error in the JS code on the page. Can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!

Regards,
Tobias

Hi,

I have just tried installing the plugin on a dummy live server and actually, it works without any other extension so definitely, there is a coding problem on my site.

Unfortunately, I am running locally the site as it is the company WIKI.
Can you please tell me the procedure to fix this issue?

Thanks,
Arwin

Hi,

yes, this is a regular feature, no extra code necessary.
To find the cause, you could check for JavaScript errors, in the error log console of your browser.
Alternatively, please try again after temporarily deactivating all other plugins and after switching to a WordPress default theme like Twenty Sixteen. That way, you can find what’s causing this, by reactivating them one by one.

Regards,
Tobias

Thanks for the help,

I checked and following is the error that I am getting:

JQMIGRATE: Migrate is installed, version 1.4.1
jquery.datatables.min.js?ver=1.9:89 Uncaught TypeError: Cannot read property ‘mData’ of undefined
at HTMLTableCellElement.<anonymous> (jquery.datatables.min.js?ver=1.9:89)
at Function.each (jquery.js?ver=1.12.4:2)
at a.fn.init.each (jquery.js?ver=1.12.4:2)
at HTMLTableElement.<anonymous> (jquery.datatables.min.js?ver=1.9:89)
at Function.each (jquery.js?ver=1.12.4:2)
at a.fn.init.each (jquery.js?ver=1.12.4:2)
at a.fn.init.m [as dataTable] (jquery.datatables.min.js?ver=1.9:82)
at HTMLDocument.<anonymous> ((index):1520)
at i (jquery.js?ver=1.12.4:2)
at Object.fireWith [as resolveWith] (jquery.js?ver=1.12.4:2)
?
The table that is not able to show-up the filter has been imported from an excel 97-03 format. I have just realized that if I create a brand new table and refresh the page, the filters now come up.
Do you think this information can help you?

Thanks!

Hi,

are you using #colspan# or #rowspan# in this table? These are not compatible to the DataTables JS library.

If that’s not it, there is HTML code in your table (e.g. for links or images) which has wrong or missing quotation marks.

Regards,
Tobias

You are simply a genius!!!!!!!!!!!
It was due #colspan# in my table content
Many thanks for your prompt help!!!

Arwin

Hi,

no problem! Good to hear that it’s working now!

Best wishes,
Tobias

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