Hi I'm pulling some data from a table with server-side processing but when I search for a word that is clearing in the table I'm getting no results. I've tried creating a "view" but that also hasn't worked. If I disable server-side processing search will work but loading the table is very slow. Does anyone know how to fix this?
basically you have to create a view and strip all the formatting when running the query. ie. you query should look like this in wpDataTables SELECT * FROM view1
Ok, so now the issue is back. If I do a basic SQL query as a VIEW ie SELECT * FROM Table, it works fine. But I need to use Concat in my query, and when I use it, I get the desierd result, but the search will not work for any of the columns. Does anyone know why this would happen when using Concat?
I've just notcied another issue. Some people have been telling me they cannot see the table. And it looks like my table is only being displayed for logged in admin users. My other tables seem to display OK though. How can I make this table display to everyone?
Hi
I'm pulling some data from a table with server-side processing but when I search for a word that is clearing in the table I'm getting no results. I've tried creating a "view" but that also hasn't worked. If I disable server-side processing search will work but loading the table is very slow. Does anyone know how to fix this?
Thanks
Kahl
Ok, I just saw how to solve this via this video
basically you have to create a view and strip all the formatting when running the query. ie. you query should look like this in wpDataTables SELECT * FROM view1Ok, so now the issue is back. If I do a basic SQL query as a VIEW ie SELECT * FROM Table, it works fine. But I need to use Concat in my query, and when I use it, I get the desierd result, but the search will not work for any of the columns. Does anyone know why this would happen when using Concat?
Hi, Kahlil
Thanks for reaching out to us.
It was a good call to go for the View to solve filtering issues with our Parser.
Yes. With the CONCAT, it can create issues for the Search specifically, even if the filtering works correctly.
You have to check which is the column that is derived from the CONCAT function,
go to this column settings, and disable this column from "global search".
Let me know if that solves the issue?
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 Milos
Thank you for the solution! I can confirm removing the field from global search has worked :)
Kahlil
Hello again
I've just notcied another issue. Some people have been telling me they cannot see the table. And it looks like my table is only being displayed for logged in admin users. My other tables seem to display OK though. How can I make this table display to everyone?
Link: https://slabd.com.au/bgs-grades/
Thanks
Kahlil
Hi, Kahlil
if you mean this table, ID 6 , from the page https://slabd.com.au/bgs-grades/ , i can see it from incognito browser,
and from a regular browser as well, i don't see any errors in the console as well.
Perhaps it was some kind of a caching issue, or a permissions issue - but i am not able to replicate it from my end.
Did you do something to fix it in the meantime, or can any of the people still replicate it?
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