Hey everyone!
With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:
Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.
We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.
In the meantime, if you need help, feel free to:
-
Use the support widget on the bottom right of our websites (Amelia and wpDataTables) — our AI-powered assistant is available 24/7 and can help with many common questions.
-
Visit our documentation, articles, or YouTube channels for quick answers and step-by-step guides.
https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos
https://www.youtube.com/@wpDataTables/videos
Thank you for being so understanding, and we hope you enjoy the long weekend!
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.