Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

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

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