I still can't get filters to work on our data table. We switched to SQL from Excel due to the size, and it can pull the data, but the filters won't pull correctly. I've tried creating a view and pointing it there, creating multiple db connections, tried different settings on the column settings for the filters (string, etc.) and anything else I found, but no change. I noticed that when you try to get it to pull the filter fields from the database, that doesn't work, either. Thoughts?
Can You tell me which version of the plugin are You using?
Also, if it is at all possible, could You 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.
Make sure to tell me which table is giving You the issue.
I logged in and saw what You were talking about. This should definitely be resolved if You were to create a view, so I don't know why it wasn't. I saw that You have another SQL table [wpdatatable id=1] and that table searches without issues.
Now, this one has a lot of entries, so Server-side is a must. I'll ask You to create that View You were talking about, and let me know when You do (no rush on our side either, we won't be working for the next two days) so that I can go back in and take a look.
wpDataTables server probably has problems with parsing the query and building new queries dynamically (rarely happens, but does sometimes). Try a MySQL view, 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 trigger the sorting on the front-end, and having it in initial statement may cause the table to crash.
Sorry for the delay. I was out last week and I forgot that it didn't email me with updates. Let me check on this as soon as I can. I believe it is still setup for a view.
I still can't get filters to work on our data table. We switched to SQL from Excel due to the size, and it can pull the data, but the filters won't pull correctly. I've tried creating a view and pointing it there, creating multiple db connections, tried different settings on the column settings for the filters (string, etc.) and anything else I found, but no change. I noticed that when you try to get it to pull the filter fields from the database, that doesn't work, either. Thoughts?
Hello Brian.
Thank You for Your purchase.
Can You tell me which version of the plugin are You using?
Also, if it is at all possible, could You 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.
Make sure to tell me which table is giving You the issue.
Best regards.
Kind Regards,
Aleksandar Vuković
[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
Hello again Brian.
I logged in and saw what You were talking about. This should definitely be resolved if You were to create a view, so I don't know why it wasn't. I saw that You have another SQL table [wpdatatable id=1] and that table searches without issues.
Now, this one has a lot of entries, so Server-side is a must. I'll ask You to create that View You were talking about, and let me know when You do (no rush on our side either, we won't be working for the next two days) so that I can go back in and take a look.
wpDataTables server probably has problems with parsing the query and building new queries dynamically (rarely happens, but does sometimes). Try a MySQL view, 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, and a happy new Year!
Kind Regards,
Aleksandar Vuković
[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
Sorry for the delay. I was out last week and I forgot that it didn't email me with updates. Let me check on this as soon as I can. I believe it is still setup for a view.