Can you please show me how the database looks like?
This looks like a form (the attachment you shared with us), is that correct?
Please share as much info about the database table, and the wpDataTables table you created, and let me know what you'd like to hide and show. I'm guessing you are creating the table using SQL queries, correct?
After you do that, you would have to create a MySQL View, and use it to create a table in wpDataTables.
Unfortunately, pulling the data via shortcodes is not possible with the plugin's built-in features, and the result would also be a table, only pivoted, so rows are turned into columns and vice versa.
Please note that creating custom queries is not included in the support of the plugin which only refers to advice.
Hello,
how it is possible to hide the table and show only the result from this database row in the front end?
And i would like to customize them in the divi theme.
Thank you and best regards. David
Hello David.
Thank you for your purchase.
Can you please show me how the database looks like?
This looks like a form (the attachment you shared with us), is that correct?
Please share as much info about the database table, and the wpDataTables table you created, and let me know what you'd like to hide and show. I'm guessing you are creating the table using SQL queries, correct?
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,
thank you for trying to help me.
Take a look here https://www.hsn-tsn-suche.de/test-new/ and I would like to show the result like on the bottom of the site.
I create the database using the wpdatatabels and import an excel file. The database is fine, but I like to show the result different in the front-end.
Perfekt would be a shortcode or something else.
The hole SQl database is in the attachment.
Thank you very much.
David
Hello again David.
I see what you mean.
In order to do this, you would have to create a PIVOT table, like explained in here:
https://stackoverflow.com/questions/13944417/mysql-convert-column-to-row-pivot-table
After you do that, you would have to create a MySQL View, and use it to create a table in wpDataTables.
Unfortunately, pulling the data via shortcodes is not possible with the plugin's built-in features, and the result would also be a table, only pivoted, so rows are turned into columns and vice versa.
Please note that creating custom queries is not included in the support of the plugin which only refers to advice.
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