query post by author gender

Question

I'm using utimate member plugin on my website. for each member (author), I have a field to store the member gender. (Homme / Femme).

the data is stored in my database, inside wp_usermeta.

meta key is "gender" and meta value is either "Homme", or "Femme".

I'm trying to write a wp-query to display all posts from all the authors, but only "Homme" authors, and another with only "Femme".

here is my wp-query to display all the posts without filtering by gender :

<?php $custom_query_args = array(

    'post_type' => 'post', 
    'posts_per_page' => -1,
    'post_status' => 'publish',
    'order' => 'DESC',
    'orderby' => 'date',
);
$custom_query = new WP_Query( $custom_query_args ); ?>

works fine.

Here is what I've tried so far to get only the posts from "Homme" gender, but it's not working... I think I need to add a reference to post author ID somewhere but I can't find the solution.

<?php $custom_query_args = array(

    'post_type' => 'post', 
    'posts_per_page' => -1,
    'post_status' => 'publish',
    'meta_query'             => array(
    array(
              'key' => 'gender',
            'value' => 'Homme',
            'compare' => '='
    ),
  ),
    'order' => 'DESC',
    'orderby' => 'date',
);
$custom_query = new WP_Query( $custom_query_args ); ?>

I don't know if there's a way of doin it with the plugin itself, but i'm pretty sure it can be done with a simple wp-query.

Can anybody help me with this ?

thanks.

---

here is what I tried, It displays ID of author who are "Homme".

<?php
$blogusers = get_users( array( 
  'meta_key'     => 'gender',
  'meta_value'   => 'Homme',
  'meta_compare' => '='
  ) ); ?>

<?php foreach ( $blogusers as $user ) {
  echo '<span>' . esc_html( $user->ID ) . '</span>';
}

?>

works fine.

What I don't know how to do, is to store in my post query the authors ID from this users query, and then use thoses ID in my query like this

array( 'author' => '2,6,17,38' ) )

where '2,6,17,38' should be the ID's of the authors.

Answer 1

If I get it right you are storing this data in user meta. WP_Query would have no remote idea how to retrieve that, since it's only aware of post meta. The two are completely separate and there is no native way to involve one in queries for another.

Likely you will have to do this in a two step process:

1. Use get_users() to retrieve IDs for all authors of one gender and then another.
2. Use author__in argument of WP_Query to limit posts to such set of authors.

Working of what you got so far:

$blogusers = get_users( array( 
  'meta_key'     => 'gender',
  'meta_value'   => 'Homme',
  'meta_compare' => '=',
   'fields' => 'ID',
  ) );

$custom_query_args = array(

    'post_type' => 'post', 
    'posts_per_page' => -1,
    'post_status' => 'publish',
    'author__in' => $blogusers,
    'order' => 'DESC',
    'orderby' => 'date',
);
$custom_query = new WP_Query( $custom_query_args ); ?>