BuddyPress.org

update: I wrote the code. It all seems to work fine (except), it doesn’t seem to affect the query (i.e. the results in members index page are not right). Not sure why ?

Any input would be hugely appreciated:

function add_groups_to_members_search(  $query_args  ) {
    
    $search = esc_sql($_REQUEST['search_terms']);  // search box on members index page
    
    global $wpdb;
    
    // get users in groups that search term is like
    $sql = "SELECT m.user_id FROM wp_bp_groups g, wp_bp_groups_members m where g.id = m.group_id and g.name like '%$search%'"; 
    
    $myrows = $wpdb->get_results( $sql );
       
    $user_ids = array();
    
    foreach ($myrows as $obj ) {        
        $user_ids[] = $obj->user_id;      
    }
    
    $query_args['include'] = $user_ids;
    
    return $query_args;
    
}

add_filter( 'bp_before_has_members_parse_args', 'add_groups_to_members_search', 999999, 1 );