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!
I am expecting this plugin to establish a front-end Datatable for my client, who needs to perform CRUD on her organization's data. The query to retrieve this information is based on two wordpress tables: wp_users and wp_usermeta.
This is the nature of the query:
SELECT
u1.id,
u1.user_login,
u1.user_pass,
u1.user_email,
u1.display_name,
u1.user_registered,
m1.meta_value AS firstname,
m2.meta_value AS lastname,
m3.meta_value AS address,
m4.meta_value AS datesattendedfssg,
m5.meta_value AS city,
m6.meta_value AS state,
m7.meta_value AS zipcode,
m8.meta_value AS phone
FROM wp_users u1
LEFT JOIN wp_usermeta m1 ON (m1.user_id = u1.id AND m1.meta_key = 'first_name')
LEFT JOIN wp_usermeta m2 ON (m2.user_id = u1.id AND m2.meta_key = 'last_name')
LEFT JOIN wp_usermeta m3 ON (m3.user_id = u1.id AND m3.meta_key = '_streetAddress')
LEFT JOIN wp_usermeta m4 ON (m4.user_id = u1.id AND m4.meta_key = '_datesAttendedFSSG')
LEFT JOIN wp_usermeta m5 ON (m5.user_id = u1.id AND m5.meta_key = '_city')
LEFT JOIN wp_usermeta m6 ON (m6.user_id = u1.id AND m6.meta_key = '_state')
LEFT JOIN wp_usermeta m7 ON (m7.user_id = u1.id AND m7.meta_key = '_zipCode')
LEFT JOIN wp_usermeta m8 ON (m8.user_id = u1.id AND m8.meta_key = 'phone_number')
I expect the output to be in a table (column and row) which CRUD operations can be operated on. Additionally, I expect the capability to Print, Copy, Export to Excel, CSV either a selectd row or all the matching data. Can this product do this?