Can you please try that query in phpmyadmin and see is it returning data that you need? If the answer is yes, my suggestion is to prepare a MySQL view (a stored query), call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
I want to create a table form a sql query dat retrieves all data form a table in Wordpress. It's a Custom post type made with Types. I use:
SELECT *
FROM wp_posts AS posts_beoordelingsform
WHERE 1=1
AND posts_beoordelingsform.post_type = 'beoordelingsform'
This only retrieves data form wp_posts.
Can you please help me.
Hi jaspijk,
Thank you for your purchase.
Can you please try that query in phpmyadmin and see is it returning data that you need? If the answer is yes, my suggestion is to prepare a MySQL view (a stored query), call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
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