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:

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! 

Okay
  Public Ticket #3515693
Need Help
Closed

Comments

  • David Hammond started the conversation

    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?

  •   Miloš replied privately