I built a MySql table, everything is working (including filters), but not the global search. I am using a mysql view just like in the video. Anything that I could be missing?
select a.meta_value as Date, b.meta_value as School, c.meta_value as Farmer, d.meta_value as Coordinator, e.meta_value as WaterOn,f.meta_value as GardenProblems, g.meta_value as DropBox, h.meta_value as Score, CONCAT("https://dev-gop-connect.pantheonsite.io/farmer-manager-report/entry/",a.item_id) AS Action from wp_frm_item_metas a LEFT JOIN wp_frm_item_metas b ON a.item_id=b.item_id AND b.field_id=3017 LEFT JOIN wp_frm_item_metas c ON a.item_id=c.item_id AND c.field_id=3018 LEFT JOIN wp_frm_item_metas d ON a.item_id=d.item_id AND d.field_id=3138 LEFT JOIN wp_frm_item_metas e ON a.item_id=e.item_id AND e.field_id=3048 LEFT JOIN wp_frm_item_metas f ON a.item_id=f.item_id AND f.field_id=3056 LEFT JOIN wp_frm_item_metas g ON a.item_id=g.item_id AND g.field_id=3087 LEFT JOIN wp_frm_item_metas h ON a.item_id=h.item_id AND h.field_id=3093 where a.field_id=3021
and then in the wpDatatable SQL Query I used SELECT * FROM VIEW1, which works perfectly. Just not the main global search. Any help would be appreciated.
To be fully honest with you, i am not 100% sure what is the exact root of this issue. Usually both filtering and search don't work, and most of the times the View solves it;
But i can see you are pulling data from a Formidable form, it does require advanced knowledge of SQL and our parser to determine the issue.
We will need help from our developers on this.
We are going to escalate it with them, and as soon as they respond i will advise you immediately with new informations.
-
They are going to need to investigate the WP-Admin side, if that is OK?
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
And point us to the table ID, please?
-
I am not sure, but they might need to take a look at your database, too. If you could send us Access to the database, that can help.
I will certainly keep you posted on their investigation.
I built a MySql table, everything is working (including filters), but not the global search. I am using a mysql view just like in the video. Anything that I could be missing?
Wrong ticket name, since I ended up going with a mysql table...
Should be: Formidable Forms mySQL table
Might help someone in the future.
Just for reference, I created this view:
select a.meta_value as Date, b.meta_value as School, c.meta_value as Farmer, d.meta_value as Coordinator, e.meta_value as WaterOn,f.meta_value as GardenProblems, g.meta_value as DropBox, h.meta_value as Score,
CONCAT("https://dev-gop-connect.pantheonsite.io/farmer-manager-report/entry/",a.item_id) AS Action
from wp_frm_item_metas a
LEFT JOIN wp_frm_item_metas b ON a.item_id=b.item_id AND b.field_id=3017
LEFT JOIN wp_frm_item_metas c ON a.item_id=c.item_id AND c.field_id=3018
LEFT JOIN wp_frm_item_metas d ON a.item_id=d.item_id AND d.field_id=3138
LEFT JOIN wp_frm_item_metas e ON a.item_id=e.item_id AND e.field_id=3048
LEFT JOIN wp_frm_item_metas f ON a.item_id=f.item_id AND f.field_id=3056
LEFT JOIN wp_frm_item_metas g ON a.item_id=g.item_id AND g.field_id=3087
LEFT JOIN wp_frm_item_metas h ON a.item_id=h.item_id AND h.field_id=3093
where a.field_id=3021
and then in the wpDatatable SQL Query I used SELECT * FROM VIEW1, which works perfectly. Just not the main global search. Any help would be appreciated.
Thank you,
Shawn
Hi, Shawn
Thanks for reaching out to us
-
To be fully honest with you, i am not 100% sure what is the exact root of this issue. Usually both filtering and search don't work, and most of the times the View solves it;
But i can see you are pulling data from a Formidable form, it does require advanced knowledge of SQL and our parser to determine the issue.
We will need help from our developers on this.
We are going to escalate it with them, and as soon as they respond i will advise you immediately with new informations.
-
They are going to need to investigate the WP-Admin side, if that is OK?
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
And point us to the table ID, please?
-
I am not sure, but they might need to take a look at your database, too. If you could send us Access to the database, that can help.
I will certainly keep you posted on their investigation.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi, Shawn
Thank you for the access
Despite best efforts, i am still not able to isolate the root of the issue with global search of that table.
I hope you don't mind, i made a Test copy of the table, and i will look into it more.
I also sent all the details to our developers, they will assist us in the investigation.
I will keep you posted on our progress.
Apology for the waiting time.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables