Wp query by postmeta in array field [0]

Question

I'm trying to query a post type by meta value, but the value is [0] field in array.

$args = array('post_type'=>'event','meta_query' => array(
    array(
        'key' => 'my_post_multicheckbox', 
         // The right value should be my_post_multicheckbox[0] 
         // and it's serialized
        'value' => serialize($current_post_ID)
    )
));
$events = new WP_Query($args);
while ($events->have_posts()):$events->the_post(); 
the_title();
endwhile;
wp_reset_query();

Obviously it does not show any post, any idea?

What does `my_post_multicheckbox[0]` have to do with anything? And why do you have `$current_post_ID` in your meta query? And you don't have to `serialize` - WP handles that automagically - just put the raw value. — random_user_name, Oct 30 '17 at 21:50
I'm using CMB2 attachment post, to make a relation between the post type 'event' and the post type 'locations'. For every events I attach the ID of its location. Now in the my single-location I wanna the events of the location. $current_post_ID is the id of the location, if the event's attached id is the same id of the current location i have magically my events list! my idea is query events by meta value,where the key is my post meta (my_post_multicheckbox) and the value is the current location id. — Gozer, Oct 30 '17 at 22:30

score 1 · Accepted Answer · edited Dec 17 '17 at 01:41

When you store multiple selected value as meta value, its value are being store in serialise form like

a:2:{i:0;s:2:"53";i:1;s:2:"54";} // where 53 and 54 are 2 selected ids.

Now, if you want to get post which has selected id = 53, then you need to pass "compare" parameter in your meta query with "Like". By default it will compare with "=" condition.

So your Wp_query should be as follow:

$args = array('post_type'=>'event','meta_query' => array(
    array(
        'key' => 'my_post_multicheckbox', 
         // The right value should be my_post_multicheckbox[0] 
         // and it's serialized
        'value' => $current_post_ID, // this should not be serialise value.
        'type' => 'CHAR',
        'compare' => 'LIKE',
    )
));
$events = new WP_Query($args);

If you want to fetch post by multiple Id, instead of 'Like', you need to pass 'IN' and in value, you need to pass array of ids by which you want to get the posts.

Wp query by postmeta in array field [0]

1 Answers1