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.
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.