WP查询：如何从特定作者或具有特定元值的作者处获取帖子

Question

我想检索那些作者（post表字段）是给定作者或具有给定元值（postemda表字段）的所有帖子。

如果“author”是一个元值，我知道我可以使用元查询来实现它。这里的问题是它不是。。。因此，我认为我不能在meta_查询中使用“author”字段，而使用“relation”键。

我要找的东西是：

$args = array(
    'post_type'  => array('post'),
    'orderby'    => 'ASC',
    'order'      => 'date',
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'relation'    => 'AND',
            array(
                'field'   => 'author',
                'value'   => $author_id,
                'compare' => '==',
            ),
            array(
                'key'     => '_meta_field_name',
                'compare' => 'NOT EXISTS',
            ),
        ),
        array(
            'relation'    => 'AND',
            array(
                'key'     => '_meta_field_name',
                'compare' => 'EXISTS',
            ),
            array(
                'key'     => '_meta_field_name',
                'value'   => $meta_field_value,
                'compare' => '==',
            ),
        ),
    ),
);

$data = new WP_Query( $args );

关于如何使用WP_Query实现这一目标的任何建议？

谢谢！

Answer 1

您可能想尝试一种类似的方法。其思想是查询要搜索的两个条件，然后将这两个查询合并为一个成品。

//Get posts with the author you're looking for
$args1 = array(
    'author_name' => 'testuser', //or 'author' => $author_id or something else
     );
$data1 = get_posts( $args1 );

//Get posts with the meta data you're looking for
$args2 = array(
    'meta_query' => array(
        array(
            'key'     => 'meta_field_name',
            'compare' => 'EXISTS',
        ),
        array(
            'key'     => 'meta_field_name',
            'value'   => $meta_field_value,
            'compare' => '==',
        ),
    ),
);
$data2 = get_posts( $args2 );

//Merge both arrays
$allData = array_merge( $data1, $data2 );

//Get just the IDs of all the posts found, while also dropping any duplicates
$postIDs = array_unique( wp_list_pluck( $allData, 'ID' ) );

//Do a new query with these IDs to get a properly sorted array of post objects
$args3 = array(
    'post__in' => $postIDs,
    'order' => 'ASC',
    'orderby' => 'date',
    );
$finalAnswer = get_posts( $args3 ); //This is your array of post objects. Ta-Da!