Hello,

Sorry for my English, I'm french. I bought wpDataTables to list all entries of a Contact Form 7 form. I use Flamingo to record this. I tried but no result. It's very specific because Flamingo record this in 2 tables : wp_posts and wp_postmeta. We can filter the recording with wp_posts.post_type = 'flamingo_inbound'. After that, it's more complicated. 2 problems :

• To filter the good form, the id of the good form is into a caracter string in wp_posts.post_content with 2 cariage return (multiple lines) but if the id = 9242, the sql request with LIKE '% 9242 %' doesn't work.
• All of datas of a recording, is on wp_postmeta table, in multiple rows... I tried with sql request PIVOT but no results. There is a link between these 2 tables with wp_postmeta.post_id = wp_posts.id

Thanks for your help

Bests regards

Pierre

Hello,

All of these problems are solved :

• I can filter with an another query with character string (slug of the form)
• I created a nested query

Thanks

Pierre