I only want to construct table using wpDataTables from users tables in WordPress, Actually I tried that but roles of the users did not displayed because on other table called usermeta , I want your help on doing that.
My first question in this post if you review that is:
"I only want to construct table using wpDataTables from users tables in WordPress, Actually I tried that but roles of the users did not displayed because on other table called usermeta , I want your help on doing that."
I was not able by wpDataTables to display users table exactly like that displayed on word press users list which attached to this post containing role for each user, the data of that user list is consisting of two tables as appeared in PhPAdmin, user table and usermeta table. You may ask why I need that table since it is available in WordPress? The answer: Actually I need separate table for each users according to their roles, therefore I bought wpDataTables for doing that, as I read in the documentation that can be done using your product.
Also I attached another screen shot of wpDataTables in which I tried to construct table from two tables which will solve my problem if it works,I need your help in fixing that.
If you take a look at our documentation you will see this notice
Please note that MySQL query constructor is not an ‘ultimate generator’, it should be treated as helper for constructing a suggestion of a query, by trying to ‘guess’ what you want. We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.
Unfortunately due to our support policy writing queries are not included in the regular support of the plugin. Included support covers help with bugs and general inquiries for the plugin features, but not writing custom code. As you're developing some custom solution if you need our assistance we can offer you our paid customization service.
using wpDataTables , I need to display users with their roles for example , roles like author , editor , contributor.
Hi Hamed,
Thank you for your purchase.
Do you have any example of the table where you want to apply this so I can give you my suggestion.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Thank you for your quick response
I only want to construct table using wpDataTables from users tables in WordPress, Actually I tried that but roles of the users did not displayed because on other table called usermeta , I want your help on doing that.
HI Hamed,
Sorry but I did not quite understand what are you trying to achieve. Can you please send me some example or screenshot of this so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
The WordPress user list is attached now which contains user Id, user name , email and roles
I bought the wpDataTables so as to make seperate table of subscribers and table of contributors, etc
How to do that using wpDataTables.
Hi Hamed,
To create a table from that table you can use this query
SELECT * FROM wp_users
This is my result. ( attachment)
Best regards
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
My first question in this post if you review that is:
"I only want to construct table using wpDataTables from users tables in WordPress, Actually I tried that but roles of the users did not displayed because on other table called usermeta , I want your help on doing that."
I was not able by wpDataTables to display users table exactly like that displayed on word press users list which attached to this post containing role for each user, the data of that user list is consisting of two tables as appeared in PhPAdmin, user table and usermeta table. You may ask why I need that table since it is available in WordPress? The answer: Actually I need separate table for each users according to their roles, therefore I bought wpDataTables for doing that, as I read in the documentation that can be done using your product.
Also I attached another screen shot of wpDataTables in which I tried to construct table from two tables which will solve my problem if it works,I need your help in fixing that.
Hi Hamed,
If you take a look at our documentation you will see this notice
Please note that MySQL query constructor is not an ‘ultimate generator’, it should be treated as helper for constructing a suggestion of a query, by trying to ‘guess’ what you want. We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.
Unfortunately due to our support policy writing queries are not included in the regular support of the plugin.
Included support covers help with bugs and general inquiries for the plugin features, but not writing custom code. As you're developing some custom solution if you need our assistance we can offer you our paid customization service.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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