WP Query – Order by number and then time

• ForbiddenChunk

• January 10, 2022 at 11:11 am

I have a CPT called classes and you I am looking to order the classes by number (e.g. 1,2,3 etc.) and then by time (e.g. 9:am, 11am, 8pm etc.)

I can get the number order but not by time and not sure where I’m going wrong;

$args = array( 
	'post_type' => 'classes', 
	'posts_per_page' => $number_of_classes,
	'post_status' => 'publish',
	'meta_query' => array(
		'relation' => 'AND',
		'date_clause' => array(
			'key' => 'date',
			'compare'	=> '=',
		),
		'time_clause' => array(
			'key' => 'from_time',
			'compare'	=> '=',
		),
	),
	'orderby' => array(
		'date_clause' => 'ASC',
		'time_clause' => 'ASC',
	),
);

Any ideas or help would be great, thanks.

• jarvis

• January 10, 2022 at 12:25 pm

How are you storing the values? I’ve previously found storing a date or time in a text field has caused some issues. Are they dedicated date/time fields?

• ForbiddenChunk

• January 10, 2022 at 12:27 pm

Thanks for commenting @jarvis.

The number field is a select field which is working fine in the query.

The time field uses the ‘Time Picker’ field.

• jarvis

• January 10, 2022 at 2:42 pm

Do you need to declare the type?

'time_clause' => array(
	'key'		=> 'from_time',
	'compare'	=> '=',
	'type'		=> 'time',
),

What does the time field return? Is it HH:MM:SS?

• ForbiddenChunk

• January 11, 2022 at 4:09 am

Hi @jarvis,

That worked, thanks!