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?
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?