I'm trying to use WP_Query to create a query that contains a meta_query element and a tax_query element. More critically, I don't want to find results that satisfy both conditions (and AND clause), I want to find results that satisfy one or the other of them (OR clause).
$loop = new WP_Query( array(
'post_type' => 'tickets',
'paged' => $paged,
'order' => $order,
'orderby' => $orderby,
'meta_query' => array(
array(
'key' => 'tps_email', // Use 'key' for author
'value' => 'web@data.com', // Replace with the author ID you want to query
'compare' => 'LIKE', // Use '=' to match the author ID
),
),
'tax_query' => array(
array(
'taxonomy' => 'topic', // Replace with your custom taxonomy name
'field' => 'slug', // You can use 'id', 'slug', or 'name' depending on how you want to identify the term
'terms' => 'housekeeping', // Replace with the slug of the specific term you want to query
),
),
)
);
I accept this output
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Here's how to set up the "OR" relationship between meta_query and tax_query:
$args = array( 'post_type' => 'tickets', 'paged' => $paged, 'order' => $order, 'tax_query' => array( 'relation' => 'OR', // Set the relationship to OR array( 'taxonomy' => 'topic', 'field' => 'slug', 'terms' => 'housekeeping', ), array( 'taxonomy' => 'your_taxonomy_2', 'field' => 'slug', 'terms' => 'term_slug_2', ), ), 'meta_query' => array( 'relation' => 'OR', // Set the relationship to OR array( 'key' => 'tps_email', 'value' => 'web@data.com', 'compare' => '=' ), array( 'key' => 'custom_field_2', 'value' => 'custom_value_2', 'compare' => '=' ), ), );