Public Ticket #2280349 Creating a table with user data/meta using "Generate a query to WordPress database" Closed
Comments blueelcipse started the conversationJanuary 24, 2020 at 2:11pmHi When in Generate a query to WordPress database. I don't see an option to select the users table (just post types).We really need the nice front-end builder to build reports based on user data. Is this possible or do we have to write our own sql queries? 2,498Aleksandar repliedJanuary 27, 2020 at 8:54amHello blueelcipseThank you for your purchase.You can try using the MySQL database, and it should find the wp_users table.However, this can only be done in back-end, and front end users will not be able to create new tables, only view and edit existing tables (if you allow editing, of course).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 Sign in to reply ...
Hi When in Generate a query to WordPress database. I don't see an option to select the users table (just post types).
We really need the nice front-end builder to build reports based on user data. Is this possible or do we have to write our own sql queries?
Hello blueelcipse
Thank you for your purchase.
You can try using the MySQL database, and it should find the wp_users table.
However, this can only be done in back-end, and front end users will not be able to create new tables, only view and edit existing tables (if you allow editing, of course).
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