Order by the first array within a meta_query

Question

Order by the first array within a meta_query

lcsqntl

2022年5月23日 08:36

I would like to sort the output of my WP Query. I want the events that are coming up soon to be at the beginning. The events that have already taken place should be at the end. So the first array in my meta_query should be output first, then the second array.

    $the_query = new WP_Query( 
        array( 
            'post_type'         = 'page',
            'post_status'       = 'publish',
            'posts_per_page'    = $posts,
            'meta_key'          = 'datum-von',
            'orderby'           = 'meta_value upcoming_events',
            'order'             = 'ASC',
            'post__in'          = array(22888,23062,23065,23348),
            'meta_query'        = array(
                'relation' = 'OR',
                'upcoming_events' = array(
                    'key' = 'datum-von',
                    'value' = date('Y-m-d'),
                    'compare' = '=',
                    'type' = 'DATE'
                ),
                'past_events' = array(
                    'key' = 'datum-von',
                    'value' = date('Y-m-d'),
                    'compare' = '=',
                    'type' = 'DATE'
                )
            ),
        )
    );

Does anyone have an idea how I can control the sorting? Thanks for reading!

Topic meta-query wp-query custom-field Wordpress

Category Web

lcsqntl · Accepted Answer · 2022年5月23日 08:36

Thanks for the input! That's how I built my code now. But the "posts_per_page" can't be controlled by the arrays now. It will always output all posts.

add_shortcode( 'display_events', 'display_events' );
function display_events( $atts ) {
    
    extract( shortcode_atts( array (
        'posts' => -1,
    ), $atts ) );
    
    $args1 = array(
            'post_type'         => 'page',
            'post_status'       => 'publish',
            'posts_per_page'    => $posts,
            'meta_key'          => 'datum-von',
            'orderby'           => 'meta_value',
            'order'             => 'ASC',
            'post__in'          => array(22888,23062,23065,23348),
            'meta_query'        => array(
                array(
                    'key' => 'datum-von',
                    'value' => date('Y-m-d'),
                    'compare' => '>=',
                    'type' => 'DATE'
                )
            )
    );
 
    $loop1 = new WP_Query($args1);
 
    $args2 = array(
            'post_type'         => 'page',
            'post_status'       => 'publish',
            'posts_per_page'    => $posts,
            'meta_key'          => 'datum-von',
            'orderby'           => 'meta_value',
            'order'             => 'ASC',
            'post__in'          => array(22888,23062,23065,23348),
            'meta_query'        => array(
                array(
                    'key' => 'datum-von',
                    'value' => date('Y-m-d'),
                    'compare' => '<=',
                    'type' => 'DATE'
                )
            )
    );
 
    $loop2 = new WP_Query($args2);

    $the_query = new WP_Query();
    $the_query->posts = array_merge($loop1->posts, $loop2->posts);
    $the_query->post_count = $loop1->post_count + $loop2->post_count;

        while ($the_query->have_posts()) {
            $the_query->the_post();   
            
            // display the data
            the_title();
        } else {
        // no posts found
        }
    wp_reset_postdata();
}

Any idea how to limit the posts_per_page in this situation?

Abhik · Accepted Answer · 2022年5月19日 10:16

You can use get_posts() for both event types and merge them.

$merged_events = array();

$upcoming = get_posts(array(
    /* Your upcoming events args here. */
));

$past = get_posts(array(
    /* Your past events args here. */
));

$merged_events = array_merge( $upcoming, $past);

foreach( $merged_events as $merged_event ) {
    //Your loop
}

Order by the first array within a meta_query

About