Hi, using the custom fields plugin I was able to add custom metadata to my posts. I created a table using this option:
Generate a query to WordPress database.
Create a MySQL-query-based table by generating a query to WordPress database (posts, taxonomies, postmeta) with a GUI tool.
The table is able to pull all the necessary information and display it properly. Then I enable filtering for each column. I use text for some, number range for others. But when I go ahead and use the filter, it shows no results. Even if I can see a word in the column, when I use the text search filter and type the exact same word, It returns no result.
Please note that this tool is not an ultimate query generator, it just constructs a suggestion of a query. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated the query is, the higher is the chance that it will not return exactly what you need or searching and filtering will not work correctly.
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 (rarely happens, 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″.
Hi, using the custom fields plugin I was able to add custom metadata to my posts. I created a table using this option:
Generate a query to WordPress database.
Create a MySQL-query-based table by generating a query to WordPress database (posts, taxonomies, postmeta) with a GUI tool.
The table is able to pull all the necessary information and display it properly. Then I enable filtering for each column. I use text for some, number range for others. But when I go ahead and use the filter, it shows no results. Even if I can see a word in the column, when I use the text search filter and type the exact same word, It returns no result.
Hi Anton,
Thank you for your purchase.
Please note that this tool is not an ultimate query generator, it just constructs a suggestion of a query. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated the query is, the higher is the chance that it will not return exactly what you need or searching and filtering will not work correctly.
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 (rarely happens, 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″.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables