The Filters in the wpDataTables are not working when they have brackets in the Selection Options. Eg. AVIDES (Amazon), Staples (DE), FDMV Handel (Amazon), Sallis Shop (eBay DE) but works perfectly fine, if the options are simple text. Eg. Bol.com, Hobby Gigant
Please provide a solution for values with brackets to work with filters.
Can you please check wpdatatables support table that I created on your site (ID 48) and tell me do you have the same issue.
I think the issue is in the query because you used WHERE in the query.
If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (happens rarely, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Please note some this when working with the server-side processing feature:
Please do not use “LIMIT” in the SELECT statement. wpDataTables adds it automatically and it will be overridden.
Please do not use “ORDER BY” in the SELECT statement. wpDataTables has its own sorting engine so it makes no sense to use MySQL’s sorting, since it will be overridden. Also server-side processing feature adds this part of statement automatically when users triggers the sorting on the front-end, and having it in initial statement may cause the table to crash.
I forgot to add the table Alias eg. PR_PRICE_DAILY_USER_VW A is also needed to be removed. So removed A.Fieldname from all the and replace with only fieldname.
Hi Team,
The Filters in the wpDataTables are not working when they have brackets in the Selection Options. Eg. AVIDES (Amazon), Staples (DE), FDMV Handel (Amazon), Sallis Shop (eBay DE) but works perfectly fine, if the options are simple text. Eg. Bol.com, Hobby Gigant
Please provide a solution for values with brackets to work with filters.
Hi Team,
Awaiting a reply for this, it is urgent.
Hi Aditya,
Thank you for your purchase.
Can you please send me the link of that table, so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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 Aditya,
Can you please check wpdatatables support table that I created on your site (ID 48) and tell me do you have the same issue.
I think the issue is in the query because you used WHERE in the query.
If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (happens rarely, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Please note some this when working with the server-side processing feature:
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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 Aditya,
Like I said in the reply below it can happen.
Also please keep in mind that ticks like ' sign can cause an issue.
Try to execute your query below without the ' and let me know the result.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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 removed the ticks and it worked. One more point, I had to keep the Server Side Processing ON too.
I forgot to add the table Alias eg. PR_PRICE_DAILY_USER_VW A is also needed to be removed. So removed A.Fieldname from all the and replace with only fieldname.
Hi Aditya,
After that changes can you please tell me do you still have the same issue when the server side is turned on.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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