As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
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?