Reply To: Sorting custom columns with custom fields sorts only by date

• alex_is

• March 18, 2016 at 8:00 pm

Ahh brilliant, that did it for me. Thank you, James!

For my case I’ve added:

        add_action( 'pre_get_posts', 'custom_orderby' );
	function custom_orderby( $query ) {
		if( ! is_admin() )
			return;

		$orderby = $query->get( 'orderby');

		if( 'featured' == $orderby ) {
			$query->set('meta_key','featured');
			$query->set('orderby','meta_value');
		}
		elseif ( 'staff_order' == $orderby ) {
			$query->set('meta_key','staff_order');
			$query->set('orderby','meta_value_num');
		}
		elseif ( 'department' == $orderby ) {
			$query->set('meta_key','department');
			$query->set('orderby','meta_value');
		}
	} 

I think this last function has to be added to the original Elliots article, maybe someone can pass it along :))

Thanks so much again!!!