WordPress.org

Ready to get started?Download WordPress

Forums

meta_query, how to search with using both relation OR & AND? (2 posts)

  1. senyoraangelica
    Member
    Posted 12 months ago #

    I have a custom post type, BOOKS. It has several custom fields, namely; TITLE, AUTHOR, GENRE, RATING. How do I fix my meta_query code below so that only books that have the search word in the custom fields; title, author, genre; WITH EXACTLY the rating specified in my search form, gets displayed in the results?

    I have made a custom search form; a text area that will search through the title, author, and genre; and a dropdown that will search for the rating. The meta_query I made below only searches through the title, author, and genre. But I am now stumped in how to add the code for the rating.

    This is how I visually imagined it with meta_query relation:
    (title OR author OR genre) AND rating

    $args = array(
            'relation' => 'OR',
              array(
                 'key' => 'title',
                 'value' => $searchvalue,
                 'compare' => 'LIKE'
              );
              array(
                 'key' => 'author',
                 'value' => $searchvalue,
                 'compare' => 'LIKE'
              );
              array(
                 'key' => 'genre',
                 'value' => $searchvalue,
                 'compare' => 'LIKE'
              );
    ),
            array(
            'relation' => 'AND',
              array(
                 'key' => 'rating',
                 'value' => $ratingvalue,
                 'compare' => '=',
                 'type' => 'NUMERIC'
              ));

    I would extremely appreciate your help and advice.

  2. senyoraangelica
    Member
    Posted 12 months ago #

    If I can't do it with meta_query, is there another way how I can do it?

Reply

You must log in to post.

About this Topic