使用meta_query对WP_Query进行“orderby”（ASC和DESC）筛选的方法-PHP中文网问答

我正在尝试使用自定义元数据'like_count_on_post'按'DESC'筛选帖子，然后收集所有空的'like_count_on_post'和'dislike_count_on_post'，最后按'dislike_count_on_post'的'ASC'排序，但我只能得到按降序排列的赞，或者如果我删除：

'custom_field_value' => 'DESC'

我可以得到按踩升序排列，但不能同时得到两者。

查询参数代码：

$args = array(
        'post_status' => 'publish',
        'post_type' => 'sveikinimai',
        'meta_query' => array(
            "relation" => "and",
            'likes' => array(
                "relation" => "or",
                'custom_field_value' => array(
                    'key' => '_like_count_on_post_',
                ), 
                'custom_field' => array(
                    'key' => '_like_count_on_post_',
                    'compare' => 'NOT EXISTS',
                ),
            ),
            'dislikes' => array(
                "relation" => "or",
                'custom_field_value_2' => array(
                    'key' => '_dislike_count_on_post_',
                ), 
                'custom_field_2' => array(
                    'key' => '_dislike_count_on_post_',
                    'compare' => 'NOT EXISTS',
                ),
            ),
        ),
        'orderby' => array(
            'custom_field_value' => 'DESC',
            'custom_field_value_2' => 'ASC'
        ),
        'posts_per_page' => 20,
        'paged' => $paged,
    );

更新，如果你想要过滤掉不存在的元数据字段，这是代码：

$args = array(
            'post_status' => 'publish',
            'post_type' => 'sveikinimai',
            'meta_query' => array(
                "relation" => "and",
                'custom_field_value' => array(
                    'key' => '_like_count_on_post_',
                ), 
                'custom_field_value_2' => array(
                    'key' => '_dislike_count_on_post_',
                ), 
            ),
            'orderby' => array(
                'custom_field_value' => 'DESC',
                'custom_field_value_2' => 'ASC'
            ),
            'posts_per_page' => 20,
            'paged' => $paged,
        );

add_action('save_post', 'add_post_custom_meta'); function add_post_custom_meta() { global $post; $post_id = $post->ID; update_post_meta($post_id, '_like_count_on_post_', 0); update_post_meta($post_id, '_dislike_count_on_post_', 0); }