[Resolved] Query on checkboxes field

[Author]

Posts

[leonD-4]

I am trying to create a form search with select options
I get value of option but i have problem with query on multi checkboxs:

array(
'relation' => 'OR',
array(
'key' =>wpcf-size,
'value' => $_GET['size'],
'compare' => 'LIKE'
)
)

the problem is that wpcf-size is array...

[Shane]

Hi Leon,

Thank you for contacting our support forum.

Could you try using IN instead of LIKE.

Take a look at this example

array(
			'key'     => 'age',
			'value'   => array( 3, 4 ),
			'compare' => 'IN',
		),

Please let me know if this helps.
Thanks,
Shane

[leonD-4]

Hi, thank you but not work,
key is array checkboxes
value is a single value

[leonD-4]

This is my complete code:

echo '<form role="search" method="get" id="searchform" class="searchform" action="' . esc_url( home_url( '/'  ) ) . '">
echo'<select name="size" class="dropdown"> 
<option value="all">All</option>';
global $wpdb;
$values2 = $wpdb->get_col("SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key ='wpcf-size'" );
foreach( $values2 as $valore2)  {
$opzioni2[]=(unserialize($valore2));
	}
array_walk_recursive($opzioni2, function ($value, $key) use (&$list2) {
   $list2[] = $value;
});
foreach( array_unique ($list2) as $valore2)  {
echo '<option value="'.$valore2.'">'.$valore2.'</option><br>';
}
echo'</select></form>';

and this is a query

$meta_query[] = array(
		   array(
 array(
  'relation' => 'OR',
												    array(
		'key'       => 'wpcf-size',
		'value'   => $_GET['size'],
    'compare' => 'IN'
				)	
)
				)
				);

[Minesh]

Could you please try to use meta_compare => 'LIKE' in the parameters.

For example:

$meta_query[] = array(
           array(
 array(
  'relation' => 'OR',
                                                    array(
        'key'       => 'wpcf-size',
        'value'   => $_GET['size'],
    'compare' => 'LIKE'
                )   )));

More help:
https://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters

[leonD-4]

Sorry but not work.
I have create a post child with a multicheckboxes field called 'size' (wpcf-size).
Post child of products woocommerce.
I want display all product with a selected size for example 12,40.
I have create this function

add_action( 'woocommerce_product_query', 'so_27971630_product_query' );

function so_27971630_product_query( $q ){

    $meta_query = $q->get( 'meta_query' );

$meta_query[] = array(
           array(
 array(
  'relation' => 'OR',
                                                    array(
        'key'       => 'wpcf-size',
        'value'   => $_GET['size'],
    'compare' => 'IN'
                )   
)
                )
                );

$q->set( 'meta_query', $meta_query );
}

[Minesh]

Can I have problem URL and access details?

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I would additionally need your permission to de- and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important. If you agree to this, please use the form fields I have enabled below to provide temporary access details (wp-admin and FTP).

I have set the next reply to private which means only you and I have access to it.