I've a wp table 'made' by Toolset. A CPT called 'beoordelingen' with about 25 fields. I want tot make a table in Wpdatatable form 'beoordelingen'. That's working fine with about 10 fields. After that it gets slow and slower in the Table Creation Wizard. After some more fields it's not working anymore and the wizard doesn't respond anymore.
WE are not familiar with CPT,so can you tell me is he save the table in database of wordpress?
If is yes you should first check in phpmyadmin is that query returning results. If is returning the data that you need and you have a complicated query my suggestion is to make a just a VIEW in phpmyadmin like
Thank You for the answer. The Custom Post Type is rely straight forward. In WPdatatables I can see the table when I want to make a wpdatatable with a sql query in the wizard. I can choose the fields and WPdatatables makes the new table. The problem is that when I choose more then 12 fields WPdatatables keeps on processing and no result shows up.
The table is in the WP database. How do I make a view?
I saw that you used wpdatatables constructor and if you take a look at our documentation you can see that wpDataTables Constructor is just a helper:
"Please note that WPDB query constructor 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. So play around with the resulting query."
So our suggestion is when you have queries like this, can you please make a VIEW in phpmyadmin or any other database management system and see if filtering is working. You can find on this linkhow to make a view.
If the VIEW is returning the desired data and filtering is working you can use that query as Add from data source option to create tables.
I did the 'trick' with wp all export. This plugins exports the data perfect and easy. This tool sees the table and exports alle fields tot a CSV file. I use the file as an datasource for wpdatatables. Rather strange that you plugin can't do this. It's a flat table that shows in the wizard. An SQL query by hand is complex because the data is storen in wp-posts.
I've a wp table 'made' by Toolset. A CPT called 'beoordelingen' with about 25 fields. I want tot make a table in Wpdatatable form 'beoordelingen'. That's working fine with about 10 fields. After that it gets slow and slower in the Table Creation Wizard. After some more fields it's not working anymore and the wizard doesn't respond anymore.
Hi jaspijk,
Thank you for your purchase.
WE are not familiar with CPT,so can you tell me is he save the table in database of wordpress?
If is yes you should first check in phpmyadmin is that query returning results. If is returning the data that you need and you have a complicated query my suggestion is to make a just a VIEW in phpmyadmin like
SELECT*FROM view_name
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
Hi Milan,
Thank You for the answer. The Custom Post Type is rely straight forward. In WPdatatables I can see the table when I want to make a wpdatatable with a sql query in the wizard. I can choose the fields and WPdatatables makes the new table. The problem is that when I choose more then 12 fields WPdatatables keeps on processing and no result shows up.
The table is in the WP database. How do I make a view?
Hi jaspijk,
I saw that you used wpdatatables constructor and if you take a look at our documentation you can see that wpDataTables Constructor is just a helper:
"Please note that WPDB query constructor 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. So play around with the resulting query."
So our suggestion is when you have queries like this, can you please make a VIEW in phpmyadmin or any other database management system and see if filtering is working. You can find on this linkhow to make a view.
If the VIEW is returning the desired data and filtering is working you can use that query as Add from data source option to create tables.
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
Milan,
I did the 'trick' with wp all export. This plugins exports the data perfect and easy. This tool sees the table and exports alle fields tot a CSV file. I use the file as an datasource for wpdatatables. Rather strange that you plugin can't do this. It's a flat table that shows in the wizard. An SQL query by hand is complex because the data is storen in wp-posts.
Hi jaspijk,
Glad that you solved the issue.
If you have any more issues feel free to open a new ticket, we will gladly help.
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