Orderby different meta_key than query

• daveoudshoorn

• December 22, 2017 at 8:31 pm

Hi there,

I’m using https://www.advancedcustomfields.com/resources/query-posts-custom-fields/ to query for a custom post type meta_key. However, i’d like to sort (orderby) a different meta_key than the one that is queried.

$locs = get_posts(array(
'posts_per_page'	=> -1,
'post_type'			=> 'locations',
'meta_key'			=> 'monday_start_time',
'orderby'			=> 'monday_start_time',
'order'				=> 'ASC'
));

This seems to work, but i’d like to query for meta_key Monday, and then sort by monday_start_time.

Is this possible? Alternatively a solution would be to hide (not query?) locations which do not have a monday_start_time set.

Hope someone can help me out. Thanks in advance!

Best,
Dave

• daveoudshoorn

• December 22, 2017 at 9:00 pm

Seemed to have fixed it by using this. Maybe someone knows if this is the correct way? Maybe there’s a cleaner way?

$locs = get_posts(array(
	'posts_per_page'	=> -1,
	'post_type'			=> 'locations',
	'orderby' 			=> 'monday_start_time',
    'order'				=> 'ASC',
	'meta_query' => array(
        array(
            'key'     => 'monday_start_time',
            'value'   => '',
            'compare' => '!=',
        ),
    )
));