I would like to be able to build a WP page that uses the plugin so I can see some data points from our mySQL database. I would also like to be able to edit some simple data points in the data base from the WP page. Do need "front end" or "back end" edit capability of plugin for this?
What WP access level does this page need to be able to edit the DB?
"Admin" or would "Editor" be sufficient, or can I just do a password access for this page?
Will the "wpDataTables - lite" version support this?
First - you wouldn't be able to do this with the Lite version of the plugin, as SQL query based tables aren't included there. Also, in the Lite version you cannot edit any tables, only create tables linked to an existing data source, like Excel, CSV or Google Spreadsheet.
You would need to construct a query which will create the table pulling the data you need from the database. Then, you need to enable Editing, and define which user roles will be able to edit the table.
wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look and behave the same both in back-end and in front-end, so if you allow editing, the table will be editable from both back and front-end.
After entering your sandbox site I found the difference btw lite and premium etc. You may want to publish this on your website (I could not find any info on this)
I'm still wondering about:
What WP access level does this page need to be able to edit the DB tables?
Would "Admin" be needed or would "Editor" access level be sufficient to be editing the wpDatatTables page I built in WP?
Only administrators of your website can create tables, and they can decide which user role(s) will be able to edit that table from front-end:
So they can choose who will be able to edit the table.
Please note, though, that SQL query based tables that have JOINs and CONCATs cannot be edited properly. Our developers are working on resolving this, but at the moment it's a limitation.
Hi,
I'm relatively new to wpData tables and mySQL.
I would like to be able to build a WP page that uses the plugin so I can see some data points from our mySQL database. I would also like to be able to edit some simple data points in the data base from the WP page. Do need "front end" or "back end" edit capability of plugin for this?
What WP access level does this page need to be able to edit the DB?
"Admin" or would "Editor" be sufficient, or can I just do a password access for this page?
Will the "wpDataTables - lite" version support this?
Thanks,
Jorgen
Hello Jorgen
Thank you for your interest in wpDataTables.
First - you wouldn't be able to do this with the Lite version of the plugin, as SQL query based tables aren't included there. Also, in the Lite version you cannot edit any tables, only create tables linked to an existing data source, like Excel, CSV or Google Spreadsheet.
You would need to construct a query which will create the table pulling the data you need from the database. Then, you need to enable Editing, and define which user roles will be able to edit the table.
wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look and behave the same both in back-end and in front-end, so if you allow editing, the table will be editable from both back and front-end.
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
Thanks Alex for reply,
After entering your sandbox site I found the difference btw lite and premium etc. You may want to publish this on your website (I could not find any info on this)
I'm still wondering about:
What WP access level does this page need to be able to edit the DB tables?
Would "Admin" be needed or would "Editor" access level be sufficient to be editing the wpDatatTables page I built in WP?
Thx,
Jorgen
Hi again Jorgen
Only administrators of your website can create tables, and they can decide which user role(s) will be able to edit that table from front-end:
So they can choose who will be able to edit the table.
Please note, though, that SQL query based tables that have JOINs and CONCATs cannot be edited properly. Our developers are working on resolving this, but at the moment it's a limitation.
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