Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
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?