0

I have custom post type with some ACF fields. I use ACF for extra properties of entity, and I use native wordpress taxonomies too for base category of entity. So I need to build query with meta_query and tax_query same time. It looks like:

WP_Query {
  "meta_query" => {
    "relation" => "OR",
    [
      "key" => "rating",
      "compare" => "LIKE",
      "value" => "AA"
    ]
  },

  "tax_query" => {
    "relation" => "OR",
    [
      "taxonomy" =>"currencies",
      "field" =>"slug",
      "terms" => [
        "eur",
        "usd"
      ],
      "operator" => "IN"
    ]
  }
}

If I searching only by taxonomies or only by meta-fields, all works fine. But how searching by taxonomies OR by meta-fields (by default, Wordpress use AND relation, i.e. post will finded only if all sub-queries will return true)? I.e. I need add relation between two type of queries in main WP_Query object.

Any suggestions?

0

This is not possible with the WP_Query. You can specify relationship inside the tax query and inside the meta query, but, you can't have the query where meta and tax query are connected by OR.

You can always build the SQL query the way you want it, not relying on the WP_Query at all to filter posts exactly the way you want it. Or, you can use two WP_Query objects, one with meta_query, other with tax_query, and merge the results. In case you have a lot of posts, or you need pagination, that will be a challenge to make optimized.

  • emphasis on "where meta and tax query are connected by OR". If you want them connected by an "AND", just provide both the meta query and the tax query to the WP_Query, and it will just work. – That Brazilian Guy Jan 17 at 3:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.