merge two query arguments into one WP_Query call

Question

I'm overriding WooCommerce's default search query to include searching by SKU as well.

// default search query
$query_default_search = new WP_Query(
    array(
        "post_type" => "product",
        "s" => $search_query
    )
);

// SKU query
$query_search_by_sku = new WP_Query(
    array(
        "post_type" => "product",
        "meta_query" => array(
            array(
                "key" => "_sku",
                "value" => $search_query,
                "compare" => "LIKE"
            )
        )
    )
);

If the default search query doesn't return any posts, I assume that an SKU has been entered and I run the SKU query. However, I want to merge both query arguments into one WP_Query call, rather than merging the results of both queries using array_merge. If both queries had meta-query, I could use an OR relation, but this is different.

How can this be done?

Noman · Accepted Answer · 2015-08-09 19:42:17Z

1

What about this ?

$query_withMeta_search = new WP_Query(
    array(
        "post_type" => "product",
        "s" => $search_query,
        "meta_query" => array(
                "key" => "_sku",
                "value" => $search_query,
                "compare" => "LIKE"
        )
    )
);

answered Aug 9, 2015 at 19:42

Noman

1596 bronze badges

this doesn't work.

adi
– adi

2015-08-13 14:11:00 +00:00
Commented Aug 13, 2015 at 14:11
Well, it does work. The only problem is that it returns products that have search query in title AND in SKU. And most probably you wanted to get OR instead of AND ;)

Krzysiek Dróżdż
– Krzysiek Dróżdż

2019-02-15 07:28:16 +00:00
Commented Feb 15, 2019 at 7:28

Add a comment |

Simon · Accepted Answer · 2019-10-18 17:01:46Z

1

Create the array you'd like to use in it's entirety before running. Something like

if($search_query) {
     // create the basic query array
} else {
     // create the more advanced query array
}

// then run the query on the one you want
new WP_Query($args);

Hope that helps.

answered Oct 18, 2019 at 17:01

Simon

4273 silver badges9 bronze badges

Add a comment |

Stack Exchange Network

merge two query arguments into one WP_Query call

2 Answers 2

Your Answer

Hot Network Questions

merge two query arguments into one WP_Query call

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions