How can I query and sort custom-post type using WP_Query

admin管理员组

文章数量:1386701

guys, I have a custom post type called "game" and it has some custom fields (get_post_meta) which I access by their keys "_game_date_key", "_game_home_goals_key" and "_game_away_goals_key".

How do I use the WP_Query() to return posts sorted by the "_game_date_key" and ("_game_home_goals_key" and "_game_away_goals_key") are numbers ?

guys, I have a custom post type called "game" and it has some custom fields (get_post_meta) which I access by their keys "_game_date_key", "_game_home_goals_key" and "_game_away_goals_key".

How do I use the WP_Query() to return posts sorted by the "_game_date_key" and ("_game_home_goals_key" and "_game_away_goals_key") are numbers ?

• custom-post-types
• wp-query
• custom-field

Share Improve this question asked May 8, 2020 at 9:14 Isakiye AfashaIsakiye Afasha 13711 silver badge88 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

You should add arguments to WP_Query to sort by your keys in the order you want. The compare value can be your filter (larger, smaller, etc)

$args = [
    'meta_query' => array(
        'relation' => 'AND',
        'event_start_date_clause' => array(
            'key'     => '_game_date_key',
            'compare' => 'EXISTS',
        ),
        'event_start_time_clause' => array(
            'key'     => '_game_home_goals_key',
            'compare' => 'EXISTS',
        ), 
        'event_start_time_clause' => array(
            'key'     => '_game_away_goals_key',
            'compare' => 'EXISTS',
        ),
     ),
    'orderby' => array(
        '_game_date_key' => 'ASC',
        '_game_home_goals_key' => 'ASC',
        '_game_away_goals_key' => 'ASC',
    ),
];

本文标签： How can I query and sort custompost type using WPQuery