[Resolved] Query select field

[Author]

Posts

[Puntorosso]

I have created a select custom field "Event of order" for WooCommerce orders .
This select field is populated with ids of a custom post "tc_events" using this function

add_filter( 'wpt_field_options', 'populate_eventoforder_dropdown', 10, 3);
 function populate_eventoforder_dropdown( $options, $title, $type ){
    switch( $title ){
        case 'Event of order':
            $options = array(
            array(
      '#value' => '',
      '#title' => '',
	  	)
	  );
            $args = array(
                'post_type'        => 'tc_events',
                'post_status'      => 'publish',
                'posts_per_page'   => -1,
                'orderby' => 'title',
				'order' => 'ASC'
      );
            $posts_array = get_posts( $args );
            foreach ($posts_array as $post) {
                $options[] = array(
                    '#value' => $post->ID,
                    '#title' => get_the_title( $post->ID ) . ' - ' . $post->ID
                );
            }
            break;
    }
    return $options;
}

I use then this query to extract all orders containing a specific value on this select field

$args = array(
    'post_type'  => 'shop_order',
    'posts_per_page' => -1,
    'meta_query' => array(
    	array(
           'key'   => 'wpcf-event-of-order',
           'value' => $event_id
        )
	)
);

$query = new WP_Query( $args );
if($query->have_posts()) :
        while($query->have_posts()) : $query->the_post();
        echo $query->post->ID;
        endwhile;
        wp_reset_postdata();
 endif;

but I don't get any results.

What I am doing wrong?

[Luo Yang]

Hello,

The WP_Query will query posts in "Published" status by default:
https://developer.wordpress.org/reference/classes/wp_query/#status-parameters

But Woocommerce order posts do not use WP default status, so you need to define the post status parameter in WP_Query.

For example:

$args = array(
    'post_type'  => 'shop_order',
    'post_status'  => 'wc-completed', // completed order
    'posts_per_page' => -1,
    'meta_query' => array(
        array(
           'key'   => 'wpcf-event-of-order',
           'value' => $event_id
        )
    )
);

More help:
hidden link

[Puntorosso]

Luo, you totally nailed it!
Works perfectly.
Thanks a lot