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