Babstonks

Hey,

I’m back. The plugins work well but i found a bug. When you want to export entries with 2 filters or more the exportation doesn’t work and give an empty file.

Thanks

Hi,

Oh but I understand that you have a lot of work! I must not be the only one asking you for plugins.
Thank you for listening to my request.
I await your news.

Kind Regards

Hi,

dnschecker doesn’t found any problem especially just a warning on SMTP.

How can I update Mail records ? Because the mailbox works but not when email comes from WP.

Best regards

Hi,

I’ll try to re-explain what I’m trying to achieve :
I would like to search with several filters on different fields.
For example, two fields : Name and City. I would like, when i search in the filter field : James, London all entries that combine these two words. Not all James and all London but the both (AND logic). There is the code you gave to me : `<?php

<?php

add_filter( 'forminator_query_entries_where', 'wpmudev_allow_multiple_filters', 10, 2 );
function wpmudev_allow_multiple_filters( $where, $args ){
	global $wpdb;

	if( !isset( $args['search'] ) ){
		return $where;
	}

	if( strpos( $args['search'], ',' ) == false ) {
		return $where;
	}

	$search = explode(',', $args['search']);
	foreach( $search as $key => $value ){
		if( $key == 0 ){
			continue;
		}
		$where = str_replace( $value,'', $where );
		$where.= $wpdb->prepare( " AND metas.meta_value LIKE '%s'", '%' . $wpdb->esc_like( trim( $value ) ) . '%' );
	}

	$where = str_replace( ',','', $where );
	
	return $where;
}

Here’s an export of my form : https://docs.google.com/document/d/1TBg-xBHzmASLrIbHZgXyaWs415WzwUVtkCQ5Makhmns/edit?usp=sharing

Maybe it’s clearer now, I’m bot native english speaker so it’s not the easiest way for me to find a solution.

Best regards.

• This reply was modified 3 years, 11 months ago by Babstonks.
• This reply was modified 3 years, 11 months ago by Babstonks.

Thanks for your answer, but,
I replaced “OR” by “AND” and I tested this but when I wrote, for exemple : “Primo, Caen” nothing appeared, only research with one word works.
I added screenshots to the gdoc if you want

Best Regards.

Hi,

Thanks for your answer.

I followed the tutorial to implement the plugin. In my “must use” plugin section the “multi-filters” file that I’ve created is activate and it’s write that the plugin will be launch automatically. So I tried the plugin for filter submissions and I dind’t get succes ^^. Here a link to my screen captures : https://docs.google.com/document/d/127GycK4nH7_1ur7Cr-ngJ9ooshtKZh7FNCyhkdQIu74/edit?usp=sharing
Hope you will understand my problem.
Thanks a lot.
Best Regards.

Ok thanks for your answer, I think it can be a good additional function for the plugin :D.

Kind Regards.