I have added the 'show clear filters button' under the 'sorting and filtering' tab - and the button works fine in the 'table preview and columns set up' window. But, it doesn't work in the front end on the page with the same table - I click it and there is no buffering when filters should be cleared.
So, in order to clear any of the filters in the front end where i have entered text or numbers I have to manually use backspace key.
I am going to make some changes to my tables so I don't need your help on this matter now. If I still have a problem I will let you know.
But I now have two more questions:
1. Is there other prefilter code that works with columns with numbers?
For example if I use ?wdt_column_filter[1]=1 it will return rows in column 1 with 1,11,12 etc. What I want is just the row with 1 in it.
At the moment I am using a different text column as a work around which works fine, but would rather use an id column with numbers in it.
(Note - I have to say the prefilter option has really improved my site, as it applies to all tables on the page, I now only need one product template page, rather than 60 individual pages with their own tables with placeholders. It's a very, very good function!!)
2. If I have two tables and they are on different pages, is it possible to apply the same filter to both in some way?
1. Please enable "Exact filtering" for that column in column settings panel under "Filtering" tab to achieve this. Please take a look at the screenshot from the attachment.
2. I didn't quite understand your question. Can you please try to explain in more details?
1. I should have guessed that - thanks for the answer.
2. I have two wpdatatables - they both have the exactly the same information in column 1 but the other columns are different. Is it possible for users to filter them both at the same time using the same search word or number? So in other words, if a user enters 'apples' in the search field for one table can it also apply to the second one?
3. One other question - is it possible to increase the print area to include the advanced search form above the table?
2. This is not possible out of the box, but it can be achieved with small custom coding. If you are familiar with jQuery it can be done very easily.
3. Unfortunately this is not possible. Export tools (PDF, Excel, Print and CSV) feature is native DataTables (library that we are using) feature and it is very limited for customization.
2. Actually, there are two things I would like to do. The first is to be able to apply the same filter to more than one table and the second is to be able to save that filter for use again.
So, a client would be able to log in to the site and look at their filter history.
Is this quite simple using jquery too? I know that on another site that I use as a customer myself, when I click to look at my product filter history the url shows ?cf= 'an integer' (1,2,3....). So, that looks like they are saving my filter history in a table.
Filtering two tables is simple customization, but if you want to save user history it is much more complex and it requires not just jQuery than also PHP (back-end) and MySQL (Saving and fetching data from database).
Are you sure that this is not browser history than they are saving search results that you've been searching before?
They have a summary table that lists all the available products in rows.
Each product row also has a checkbox in the first visible column in the front end.
You click the checkbox on each product row that you want to see more information on.
You then click a 'compare' button - this takes you to a new page which shows only those productsrows from the summary table that have been checked. The url for the new page contains ?cf=120 for example.
If I return to the site and click on the saved search the url is the same ?cf=120.
It would be great if I could find a simple solution to do something similar.
Using wpdatables, editable tables with user_ids, url prefilters and foreign keys I have already solved all of my problems - except the one above. Perhaps there is an easier workaround, but maybe it can only be done with a lot of development work as you say.
Unfortunately something like that is not possible out of the box and as you said it can be done just with a custom work.
Our customization service price is 50$/hour. If you are interested in option like that you have to provide us you full requirements with much more details that you can provide and screenshots so we can give you accurate quote for this kind of work.
Otherwise we can recommend this service for customizations: https://wpkraken.io/?tms-plugins (by this link they would know you come from us) - they do develop such custom solutions also.
I am going to get as far as I can with wpdatables out of the box. With the latest upgrade, I will be able to do almost all of what I need.
Once I have done that I will be able to provide you with the screenshots and other information to get a rough estimate of how much it would cost to develop the customized solution.
I will also have a look a learning a little jquery so that I can use the same filter on two tables - do you have any links that would help with this specific task?
"I will also have a look a learning a little jquery so that I can use the same filter on two tables - do you have any links that would help with this specific task?"
- I don't have but this is small piece of code that you can use as example. So on event keyup you have to update the value of the second input field:
Foreign keys that link to a table with data in a column formatted as a URL link.
I have tried to set up a table that uses foreign keys to link to another table that contains a column data formatted as a URL link.
When I set up the foreign key the data is linked as a string in the new table. So, I changed the data format in the new table column to 'URL link' and the linked data appears the same as in the original table. In each row the linked text is highlighted in blue and the cursor changes to a hand, but the link isn't working.
Is this not possible or am I doing something wrong?
Can you please provide me a temporary WP-admin login for your site so I can take a better look on what you wrote me. You can write credentials here, just check PRIVATE so nobody can see it except us.
Please also provide me ID's and name of the columns of these two tables that you are trying to connect.
This issue is fixed. We'll include it in the next update. I have fixed it on your website also, but until update you'll have to keep unchecked Use minified wpDataTables Javascript option on wpDataTables settings page.
Do you still have an issue with Clear Filters feature? I want to investigate to be able to fix it for the next release, but I can't reproduce it on my local machine.
I've logged in with these credentials on the site, I can't login on Dashboard. Can you please provide me admin login credentials, because I can't find table with ID 14 on your pages.
1. Thank you for that answer - I will now only try and use foreign keys which link to 'string' columns. I was hoping I could link a column in one table with 'integer' or 'float' columns in another table . The reason for this is so that when I update numbers in the main table it updates the numbers in the tables with the foreign keys - saving me a lot of time.
2. I have a workaround solution where table A is linked to mysql version of table B. When I have completed my work on this I will send you the details so you can take a look.
One more quick thing:
3. Is it possible in an 'integer' or 'float' column to not show '0' values? In the input .csv file the cells are blank, but in the table the blank cells have a '0'.
Please forget my last message - I didn't realise I hadn't made the changes to the '/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wpdatatables.js' file for this website, which we already know is the solution to 'url' problem. Sorry.
I am doing so much work at the moment I am forgetting things!
But I would still like an answer to this if possible -
Is it possible in an 'integer' or 'float' column to not show '0' values? In the input .csv file the cells are blank, but in the table the blank cells have a '0'.
Is it possible in an 'integer' or 'float' column to not show '0' values? In the input .csv file the cells are blank, but in the table the blank cells have a '0'.
- Unfortunately not out of the box, but it can be done with little plugin file customization. Maybe you should take a look files:
And try to change so blank cell will be returned instead of 0.
If you don't manage to do this, I will help you to achieve it but I am currently very busy with releasing version 2.0.2 and few add-ons, so I will be able to help you next week. Is that fine for you?
I did have a few questions about the 'Report Builder' Add-on. But, it's very cheap to buy so I will just get it and try it on my test site to see how it works.
You can test Report Builder on our sandbox site: http://sandbox.wpdatatables.com/wp-admin/ - you can find a fully functional version there to try out all plugin features.
You can find demo examples and all documentation at this page - link.
I am going to create a detailed specification for some custom code work that I would like to have done.
I would like to solve the hide the filter form issue, but the main thing I'd like to solve is to allow users to store their filter results. Because of the way wpdatatables works it would only need to save the results in the wdt_id column. But, as I say, I will send you a detailed explanation.
Hopefully, you can give me an estimate for the work or I believe there is another company that you are linked to that could look at it for me.
If we can't get it done, or it's a bit expensive it's not a problem - with your plugin I have managed to achieve far more than I initially thought possible.
Yes something like that requires custom coding. I can't give you accurate quote without detail requirements but our customization service price is 50$/hour. Can you send me the requirements in details and we will give you the estimate for this kind of work?
I will be back to you with custom coding requirement at a later date.
One question - when i set a table display setting to 'limit table to page width' I sometimes lose the borders/gridlines for a column. The data in the column is fine. Do you know how I can stop this?
I have added the 'show clear filters button' under the 'sorting and filtering' tab - and the button works fine in the 'table preview and columns set up' window. But, it doesn't work in the front end on the page with the same table - I click it and there is no buffering when filters should be cleared.
So, in order to clear any of the filters in the front end where i have entered text or numbers I have to manually use backspace key.
Chris
Hi Chris,
Thank you for your purchase.
Can you please send me the link of that table so I can take a look.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bogdan,
I am going to make some changes to my tables so I don't need your help on this matter now. If I still have a problem I will let you know.
But I now have two more questions:
1. Is there other prefilter code that works with columns with numbers?
For example if I use ?wdt_column_filter[1]=1 it will return rows in column 1 with 1,11,12 etc. What I want is just the row with 1 in it.
At the moment I am using a different text column as a work around which works fine, but would rather use an id column with numbers in it.
(Note - I have to say the prefilter option has really improved my site, as it applies to all tables on the page, I now only need one product template page, rather than 60 individual pages with their own tables with placeholders. It's a very, very good function!!)
2. If I have two tables and they are on different pages, is it possible to apply the same filter to both in some way?
Kind regards
Chris
Hi Chris Pearce,
1. Please enable "Exact filtering" for that column in column settings panel under "Filtering" tab to achieve this. Please take a look at the screenshot from the attachment.
2. I didn't quite understand your question. Can you please try to explain in more details?
Hi Milos,
1. I should have guessed that - thanks for the answer.
2. I have two wpdatatables - they both have the exactly the same information in column 1 but the other columns are different. Is it possible for users to filter them both at the same time using the same search word or number? So in other words, if a user enters 'apples' in the search field for one table can it also apply to the second one?
3. One other question - is it possible to increase the print area to include the advanced search form above the table?
Kind regards
Chris
Hi Chris,
1. You are welcome.
2. This is not possible out of the box, but it can be achieved with small custom coding. If you are familiar with jQuery it can be done very easily.
3. Unfortunately this is not possible. Export tools (PDF, Excel, Print and CSV) feature is native DataTables (library that we are using) feature and it is very limited for customization.
Hi Milos,
Thank you again for your quick reply.
2. Actually, there are two things I would like to do. The first is to be able to apply the same filter to more than one table and the second is to be able to save that filter for use again.
So, a client would be able to log in to the site and look at their filter history.
Is this quite simple using jquery too? I know that on another site that I use as a customer myself, when I click to look at my product filter history the url shows ?cf= 'an integer' (1,2,3....). So, that looks like they are saving my filter history in a table.
Kind regards
Chris
Hi Chris Pearce,
Filtering two tables is simple customization, but if you want to save user history it is much more complex and it requires not just jQuery than also PHP (back-end) and MySQL (Saving and fetching data from database).
Are you sure that this is not browser history than they are saving search results that you've been searching before?
Hi Milos,
They have a summary table that lists all the available products in rows.
Each product row also has a checkbox in the first visible column in the front end.
You click the checkbox on each product row that you want to see more information on.
You then click a 'compare' button - this takes you to a new page which shows only those productsrows from the summary table that have been checked. The url for the new page contains ?cf=120 for example.
If I return to the site and click on the saved search the url is the same ?cf=120.
It would be great if I could find a simple solution to do something similar.
Using wpdatables, editable tables with user_ids, url prefilters and foreign keys I have already solved all of my problems - except the one above. Perhaps there is an easier workaround, but maybe it can only be done with a lot of development work as you say.
Kind regards
Chris
Hi Chris Pearce,
Unfortunately something like that is not possible out of the box and as you said it can be done just with a custom work.
Our customization service price is 50$/hour. If you are interested in option like that you have to provide us you full requirements with much more details that you can provide and screenshots so we can give you accurate quote for this kind of work.
Otherwise we can recommend this service for customizations: https://wpkraken.io/?tms-plugins (by this link they would know you come from us) - they do develop such custom solutions also.
Hi Milos,
Thanks again for that answer.
I am going to get as far as I can with wpdatables out of the box. With the latest upgrade, I will be able to do almost all of what I need.
Once I have done that I will be able to provide you with the screenshots and other information to get a rough estimate of how much it would cost to develop the customized solution.
I will also have a look a learning a little jquery so that I can use the same filter on two tables - do you have any links that would help with this specific task?
Kind regards
Chris
Hi Chris,
"I will also have a look a learning a little jquery so that I can use the same filter on two tables - do you have any links that would help with this specific task?"
- I don't have but this is small piece of code that you can use as example. So on event keyup you have to update the value of the second input field:
jQuery('#input1').on('keyup', function() { jQuery('#input2').val(jQuery(this).val()); });This is just an example and it might not work for you but you can experiment with it.
Hi Milos,
Excellent - I'll have a close look at that later. In the meantime I must give you guys a good review.
Kind regards
Chris
Hi Chris.
Thank you. You can leave a review on CodeCanyon on this link. If you have any more question don't hesitate to ask.
Hi Milos,
I've just added a five star rating.
It really is very good...
Thanks for your help.
Chris
Hi Milos,
Foreign keys that link to a table with data in a column formatted as a URL link.
I have tried to set up a table that uses foreign keys to link to another table that contains a column data formatted as a URL link.
When I set up the foreign key the data is linked as a string in the new table. So, I changed the data format in the new table column to 'URL link' and the linked data appears the same as in the original table. In each row the linked text is highlighted in blue and the cursor changes to a hand, but the link isn't working.
Is this not possible or am I doing something wrong?
Kind regards
Chris
Hi Milos,
Foreign keys that link to a table with data in a column formatted as a URL link.
Please see previous message.
I notice that if I turn off front-end editing the foreign key URLs now work, but I would like to be able to edit a different column. Is this possible?
Kind regards
Chris
Hi Chris Pearce,
Can you please provide me a temporary WP-admin login for your site so I can take a better look on what you wrote me. You can write credentials here, just check PRIVATE so nobody can see it except us.
Please also provide me ID's and name of the columns of these two tables that you are trying to connect.
Hi Chris Pearce,
This issue is fixed. We'll include it in the next update. I have fixed it on your website also, but until update you'll have to keep unchecked Use minified wpDataTables Javascript option on wpDataTables settings page.
Hi Chris Pearce,
Just in file ../wp-content/plugins/wpdatatables/assets/js/wpdatatables/wpdatatables.js around line #1108 find
var clickEvent = function (e) {and after that remove these three lines:
Also you'll have to uncheck Use minified wpDataTables Javascript option on wpDataTables settings page.
Hi Milos,
I made the change to the file for the main website and unchecked the minify option, created a test table and it worked fine.
Thanks for your help.
Chris
Hi Chris Pearce,
Do you still have an issue with Clear Filters feature? I want to investigate to be able to fix it for the next release, but I can't reproduce it on my local machine.
Hi Chris Pearce,
Ok, this issue will be fixed in version 2.0.2 that should be released at the beginning of the next weak.
Hi Chris Pearce,
This website is password protected. Can you please send me login credentials so I can take a look.
Hi Chris Pearce,
I've logged in with these credentials on the site, I can't login on Dashboard. Can you please provide me admin login credentials, because I can't find table with ID 14 on your pages.
Hi Chris Pearce,
Sorry for delayed reply. We are closed on weekends. Can you please send me FTP account of that website so I can investigate issue?
Hi Milos,
As the other support website and my main website are fine, this isn't so important at the moment - so, no need to do anything now.
One other question - your plugin uses '?' with hover text to give explanations. Is this pretty simple to do?
Kind regards
Chris
Hi Chris Pearce,
It is not really hard to implement. It is built-in bootstrap method. You can take a look at it at these links:
https://www.w3schools.com/bootstrap/bootstrap_tooltip.asp
https://v4-alpha.getbootstrap.com/components/tooltips/
Hi Milos,
I hope you had a good vacation.
1. Thank you for that answer - I will now only try and use foreign keys which link to 'string' columns. I was hoping I could link a column in one table with 'integer' or 'float' columns in another table . The reason for this is so that when I update numbers in the main table it updates the numbers in the tables with the foreign keys - saving me a lot of time.
2. I have a workaround solution where table A is linked to mysql version of table B. When I have completed my work on this I will send you the details so you can take a look.
One more quick thing:
3. Is it possible in an 'integer' or 'float' column to not show '0' values? In the input .csv file the cells are blank, but in the table the blank cells have a '0'.
Kind regards
Chris
Hi Milos,
Please forget my last message - I didn't realise I hadn't made the changes to the '/wp-content/plugins/wpdatatables/assets/js/wpdatatables/wpdatatables.js' file for this website, which we already know is the solution to 'url' problem. Sorry.
I am doing so much work at the moment I am forgetting things!
But I would still like an answer to this if possible -
Is it possible in an 'integer' or 'float' column to not show '0' values? In the input .csv file the cells are blank, but in the table the blank cells have a '0'.
Kind regards
Chris
Hi Chris Pearce,
Is it possible in an 'integer' or 'float' column to not show '0' values? In the input .csv file the cells are blank, but in the table the blank cells have a '0'.
- Unfortunately not out of the box, but it can be done with little plugin file customization. Maybe you should take a look files:
../wpdt.plugin/wp-content/plugins/wpdatatables/source/class.float.wpdatacolumn.php
and
../wpdt.plugin/wp-content/plugins/wpdatatables/source/class.int.wpdatacolumn.php
And try to change so blank cell will be returned instead of 0.
If you don't manage to do this, I will help you to achieve it but I am currently very busy with releasing version 2.0.2 and few add-ons, so I will be able to help you next week. Is that fine for you?
Hi Milos,
That's fine for me, thanks again for your help.
I did have a few questions about the 'Report Builder' Add-on. But, it's very cheap to buy so I will just get it and try it on my test site to see how it works.
Chris
Hi Chris Pearce,
You can test Report Builder on our sandbox site: http://sandbox.wpdatatables.com/wp-admin/ - you can find a fully functional version there to try out all plugin features.
You can find demo examples and all documentation at this page - link.
Hi Milos,
A quick question - I like to use the 'hide the table before it is fully loaded' button as it looks more professional.
Is it also possible to hide a 'filters in a form' shown above the table before it is loaded too?
Kind regards
Chris
Hi Chris Pearce,
Unfortunately something like that is not possible out of the box and it would require some jQuery custom coding that should not be to complicated.
Hi Milos,
Thanks for that answer.
I am going to create a detailed specification for some custom code work that I would like to have done.
I would like to solve the hide the filter form issue, but the main thing I'd like to solve is to allow users to store their filter results. Because of the way wpdatatables works it would only need to save the results in the wdt_id column. But, as I say, I will send you a detailed explanation.
Hopefully, you can give me an estimate for the work or I believe there is another company that you are linked to that could look at it for me.
If we can't get it done, or it's a bit expensive it's not a problem - with your plugin I have managed to achieve far more than I initially thought possible.
Kind regards
Chris
Hi Chris Pearce,
Yes something like that requires custom coding. I can't give you accurate quote without detail requirements but our customization service price is 50$/hour. Can you send me the requirements in details and we will give you the estimate for this kind of work?
Hi Milos,
I will be back to you with custom coding requirement at a later date.
One question - when i set a table display setting to 'limit table to page width' I sometimes lose the borders/gridlines for a column. The data in the column is fine. Do you know how I can stop this?
Kind regards
Chris
Hi Chris Pearce,
Can you send me the table where this is happening so I can take a look?