I have a large data table with 14,915 entries. There is a column in each row labelled "sports" that can have several possible entries i.e.... "Men's Ice Hockey, Men's Basketball, Women's Ice Hockey, Soccer" There is a select box that contains all the possible values but user can only select one.
If a user selects "Men's Ice Hockey" it returns all the rows that contain "Men's Ice Hockey" as expected but it also returns rows that only have "Women's Ice Hockey" in there respective sports column.
I need to be able to search on the exact and entire string and only return the records that have that exact wording in the Sports column. It is okay if there are additional items in the Sports column but it must have at least the entire substring in the column to be a valid find. (See Attachment)
I have already updated class.wpdatatable.php to use LIKE instead of = and that works fine.
$search .= '`'.$aColumns[$i]."` LIKE '%".addslashes($_GET['sSearch_'.$i])."%' ";
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID so I can test it. Thank you.
I noticed that you are using 1.6.0 version of our plugin and the 1.7.2 version is out. Can you please update it to latest version so we will be able to investigate. You can automatically update the plugin by entering the purchase code in wpdatatables settings page or you can manually update the plugin following this steps:
When I updated to 1.7.2 2 weeks ago, it broke a lot of functionality that was already built in the site. The new tagging completely failed for pre-defined filter values and was unusable in the latest chrome browser. I had to completely rebuild the site with back up files from the day before.
Can we mover forward with addressing this issue without upgrading?
Also, I am not receiving any email notifications when you actually post a reply, so if my response seem delayed that is why. The system is also extremely sluggish today. Click on "Post A Reply" takes sometimes up to 30 seconds to load page.
Can you please check now and tell me does the exact search works. I am avare that Tiksy was not working at all in past 4-5 days, but that is not on our side and we can not control it. We are using Tiksy as a third party ticketing system and this is our external solution for helping customers, so we are very frustrated too when it is not working for some hours,or sometimes for days. Sorry for any inconvenience and thank you for understanding.
I don't know if they are going to want to remove the apostrophes, we're a liberal arts college with 80% of our community are scholars in literature and writing. Is there now other way to get around this?
I will ask, but I highly doubt it. I only removed them from the test instance to see if that was the issue.
Regards
David
PS...the tickets system today, is traveling at light speed...Yay! Yesterday it was like being back in 1985 using a 1200 bps modem
If they do not want to change apostrophes in select box the solution will be to change the data in the columns. Because now the filtering is set to do the EXACT search and if you have the apostrophes in select box and you do not have them in cells the filter will not find anything.
PS. It is working, but there are a lot of tickets to cover and reply because of the yesterday shutdown.
Maybe I am not understanding or following the logic correctly. If the query is attempting to do an exact match, then why are there no successful results on the live page...http://selectassignments.colgate.edu/
When you first load the site the first row has "Men's Cross Country" when I select that from the drop down sports list the results is empty????
Okay I checked and I can remove the apostrophes from the data.
But I think there are still some issues
Some records have multiple sports in the sports column like the list below
Women's Basketball, Women's Soccer, Softball
Women's Basketball, Women's Lacrosse, Volleyball
Women's Basketball, Women's Ice Hockey, Softball
Crew Team (pre-2001), Field Hockey, Women's Ice Hockey, Softball
So if I was searching through this data above and....
If choose "Women's Lacrosse" I should get 1 result
If choose "Women's Basketball" I should get 3 result
If choose "Softball" I should get 3 result
But I should not get any results if I choose "Men's Basketball"
So what I need to do, is search through an entire string, like the one below for the term "Women's Ice Hockey", which it should find because.... "Women's Ice Hockey" is part of the whole string. But if I search on "Men's Ice Hockey" it would not find that in the same string.
"Crew Team (pre-2001), Field Hockey, Women's Ice Hockey, Softball
Unfortunately the search field can only do EXACT or LIKE search. That means if you have for example:
Women's Basketball, Women's Soccer, Softball
Women's Soccer
And the filtering is EXACT and you enter Women's Soccer you will get only Women's Soccer displayed not Women's Basketball, Women's Soccer, Softball column. The LIKE filtering will find all similar searches.
Your table and data is in some hand "different" because you have sports where Man and Women participate, so my suggestion will be to create another column where you enter the person's gender and for filtering you choose checkbox. So the user select man or woman and then choose the sport by LIKE search. I hope you can understand me. Let me know if I did not quite understand. Thank you.
No I did not change anything but now I can see that search is working and it is LIKE search. Can you please test it by yourself and tell me the result.
I have a large data table with 14,915 entries. There is a column in each row labelled "sports" that can have several possible entries i.e....
"Men's Ice Hockey, Men's Basketball, Women's Ice Hockey, Soccer"
There is a select box that contains all the possible values but user can only select one.
If a user selects "Men's Ice Hockey" it returns all the rows that contain "Men's Ice Hockey" as expected but it also returns rows that only have "Women's Ice Hockey" in there respective sports column.
I need to be able to search on the exact and entire string and only return the records that have that exact wording in the Sports column. It is okay if there are additional items in the Sports column but it must have at least the entire substring in the column to be a valid find. (See Attachment)
I have already updated class.wpdatatable.php to use LIKE instead of = and that works fine.
$search .= '`'.$aColumns[$i]."` LIKE '%".addslashes($_GET['sSearch_'.$i])."%' ";
Hi baddogtwo,
Thank you for your purchase.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID so I can test it.
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 baddogtwo,
I noticed that you are using 1.6.0 version of our plugin and the 1.7.2 version is out.
Can you please update it to latest version so we will be able to investigate.
You can automatically update the plugin by entering the purchase code in wpdatatables settings page or you can manually update the plugin following this steps:
1.) Download zip from this link
2.) Use FTP to open /yourwordpressfolder/wp-content/plugins
3.) Delete existing wpdatatables folder.
4.) Upload previously downloaded wpdatatables folder through FTP to plugins folder (unzip it)
5.) Go to WP-admin panel, open Plugins section.
6.) Deactivate wpDataTables, and then activate it again.
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
When I updated to 1.7.2 2 weeks ago, it broke a lot of functionality that was already built in the site. The new tagging completely failed for pre-defined filter values and was unusable in the latest chrome browser. I had to completely rebuild the site with back up files from the day before.
Can we mover forward with addressing this issue without upgrading?
Also, I am not receiving any email notifications when you actually post a reply, so if my response seem delayed that is why. The system is also extremely sluggish today. Click on "Post A Reply" takes sometimes up to 30 seconds to load page.
Hi David,
Can you please check now and tell me does the exact search works.
I am avare that Tiksy was not working at all in past 4-5 days, but that is not on our side and we can not control it.
We are using Tiksy as a third party ticketing system and this is our external solution for helping customers, so we are very frustrated too when it is not working for some hours,or sometimes for days.
Sorry for any inconvenience and thank you for understanding.
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
Hello Bogdan,
Well it looks like that test page is working but now the live site does not find anything. What exactly did you update
http://selectassignments.colgate.edu/
In this version of the data the apostrophes are still in the sports titles, if this makes a difference?
Hi David,
Now I see the issue, you are right.
The apostrophes are making the difference. Can you please try to remove them and see if it is working.
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
I don't know if they are going to want to remove the apostrophes, we're a liberal arts college with 80% of our community are scholars in literature and writing. Is there now other way to get around this?
I will ask, but I highly doubt it. I only removed them from the test instance to see if that was the issue.
Regards
David
PS...the tickets system today, is traveling at light speed...Yay! Yesterday it was like being back in 1985 using a 1200 bps modem
Hi David,
If they do not want to change apostrophes in select box the solution will be to change the data in the columns.
Because now the filtering is set to do the EXACT search and if you have the apostrophes in select box and you do not have them in cells the filter will not find anything.
PS.
It is working, but there are a lot of tickets to cover and reply because of the yesterday shutdown.
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,
Maybe I am not understanding or following the logic correctly. If the query is attempting to do an exact match, then why are there no successful results on the live page...http://selectassignments.colgate.edu/
When you first load the site the first row has "Men's Cross Country" when I select that from the drop down sports list the results is empty????
Okay I checked and I can remove the apostrophes from the data.
But I think there are still some issues
Some records have multiple sports in the sports column like the list below
So if I was searching through this data above and....
If choose "Women's Lacrosse" I should get 1 result
If choose "Women's Basketball" I should get 3 result
If choose "Softball" I should get 3 result
But I should not get any results if I choose "Men's Basketball"
So what I need to do, is search through an entire string, like the one below for the term "Women's Ice Hockey", which it should find because.... "Women's Ice Hockey" is part of the whole string. But if I search on "Men's Ice Hockey" it would not find that in the same string.
Hi David,
Unfortunately the search field can only do EXACT or LIKE search.
That means if you have for example:
And the filtering is EXACT and you enter Women's Soccer you will get only Women's Soccer displayed not Women's Basketball, Women's Soccer, Softball column.
The LIKE filtering will find all similar searches.
Your table and data is in some hand "different" because you have sports where Man and Women participate, so my suggestion will be to create another column where you enter the person's gender and for filtering you choose checkbox. So the user select man or woman and then choose the sport by LIKE search.
I hope you can understand me.
Let me know if I did not quite understand.
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
So did you change the code back to EXACT on the site. I cannot get the filter to work on anything now
Hi David,
No I did not change anything but now I can see that search is working and it is LIKE search.
Can you please test it by yourself and tell me the result.
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
Okay, now it is working. I swear I tested this 10 minutes ago and nothing was working....
Thanks