As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
Is there a way to show current user metadata in a column?
I see a placeholder for user ID and user First Name , Last Name etc.
I would like to add create a column to a table where every row has value of the current users usermeta from a specific key.
I can create a column of their ID with:
SELECT
%CURRENT_USER_ID% AS curent_user
I would like to do the same but with the value of a custom usermeta key:
SELECT
current_user_usermeta_key.`meta_value` As meta_data
Hi Carlen
Thank you for reaching out to us.
There are no built-in features or functions that will allow you to do this and unfortunately, we do not provide support for custom SQL queries, and we do not have any tutorials or documentation to cover this.
Please have a look at our WP database query constructor, Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible.
Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.