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
Hello
This query works in phpMyAdmin, вut it gives empty table in the plugin
select le.id, lead_id,
(select value from wp_rg_lead_detail f where f.lead_id = l.lead_id and f.field_number = 34 ) strah,
(select value from wp_rg_lead_detail f where f.lead_id = l.lead_id and f.field_number = 37 ) naim,
(select value from wp_rg_lead_detail f where f.lead_id = l.lead_id and f.field_number = 36 ) inn
from wp_rg_lead_detail l, wp_rg_lead le
WHERE l.lead_id = le.id
AND status='active'
AND l.form_id = '12' or l.form_id = '18' or l.form_id = '14' or l.form_id = '15' or l.form_id = '16' or l.form_id = '17'
group by lead_id
Wow!
This code works!
select le.id, lead_id,
(select value from wp_rg_lead_detail f where f.lead_id = l.lead_id and f.field_number = 34 ) strah,
(select value from wp_rg_lead_detail f where f.lead_id = l.lead_id and f.field_number = 37 ) naim,
(select value from wp_rg_lead_detail f where f.lead_id = l.lead_id and f.field_number = 36 ) inn
from wp_rg_lead_detail l, wp_rg_lead le
WHERE l.lead_id = le.id
AND status='active'
AND l.form_id in('12','18' ,'14' ,'15' ,'16' ,'17')
group by lead_id
Hi Alex,
Thank you for the purchase and sorry for delayed replay.
I am glad that you have found the solution. My recommendation is when you have complex queries to create MySQL View from that query in the database and then to use this MySQL View as table input.