get select value in meta query

• takide

• July 23, 2016 at 8:02 pm

hi everyone,

i want to get my post with custom query, but when i filter posts with the meta value that has an array, my posts doesn’t show anymore.

$args = array(
  'post_type'      => 'cafe',
  'posts_per_page' => 12,
  'rewrite' => array( 'slug' => 'cafe', 'with_front' => true),
  'meta_query' => array(
    array(
      'key'     => 'cafe_state',
      'value'   => $cafe_state,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_area',
      'value'   => $cafe_area,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_name',
      'value'   => $cafe_name,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_facilities',
      'value'   => array( 'test' ),
      'compare' => 'IN',
    ),
  ),
);

$query = new wp_query( $args );

• John Huebner

• July 23, 2016 at 10:42 pm

I’m guessing that you mean the cafe_facilities field? Is this a checkbox field or some other type of field that has multiple values?

• takide

• July 23, 2016 at 11:01 pm

@hube2 it’s a checkbox field, return multiple values

• John Huebner

• July 24, 2016 at 5:53 am

Querying a checkbox field is similar to querying a relationship field because it stores a serialized array https://www.advancedcustomfields.com/resources/querying-relationship-fields/

$args = array(
  'post_type'      => 'cafe',
  'posts_per_page' => 12,
  'rewrite' => array( 'slug' => 'cafe', 'with_front' => true),
  'meta_query' => array(
    array(
      'key'     => 'cafe_state',
      'value'   => $cafe_state,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_area',
      'value'   => $cafe_area,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_name',
      'value'   => $cafe_name,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_facilities',
      'value'   => '"test"',
      'compare' => 'LIKE',
    ),
  ),
);

• takide

• July 30, 2016 at 11:20 pm

@hube2 how can i select multiple value?

for example: ‘test’, ‘tests’

• John Huebner

• August 1, 2016 at 1:07 am

That depends on if you want to get posts with both values or with either value (AND/OR).

// AND
$args = array(
  'post_type'      => 'cafe',
  'posts_per_page' => 12,
  'rewrite' => array( 'slug' => 'cafe', 'with_front' => true),
  'meta_query' => array(
    array(
      'key'     => 'cafe_state',
      'value'   => $cafe_state,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_area',
      'value'   => $cafe_area,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_name',
      'value'   => $cafe_name,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_facilities',
      'value'   => '"test"',
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_facilities',
      'value'   => '"tests"',
      'compare' => 'LIKE',
    ),
  ),
);

// OR

$args = array(
  'post_type'      => 'cafe',
  'posts_per_page' => 12,
  'rewrite' => array( 'slug' => 'cafe', 'with_front' => true),
  'meta_query' => array(
    array(
      'key'     => 'cafe_state',
      'value'   => $cafe_state,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_area',
      'value'   => $cafe_area,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_name',
      'value'   => $cafe_name,
      'compare' => 'LIKE',
    ),
    array(
      'relation' => 'OR',
          array(
            'key'     => 'cafe_facilities',
            'value'   => '"test"',
            'compare' => 'LIKE',
          ),
          array(
            'key'     => 'cafe_facilities',
            'value'   => '"tests"',
            'compare' => 'LIKE',
          ),
     ),
  ),
);

You should be cautious when adding additional meta queries because the slow down site performance.