Reply To: Sorting posts by two custom fields

• jhamaker

• June 2, 2023 at 5:39 pm

My question is where does this go, and how would I get the sort to carry over to an Elementor archive?

I have a staff directory page which I would like to sort by department and position (manager, supervisor, staff). So My array would look like below, but I don’t know where to save it or implement it.

Also, I’m not sure if it would be better to set up my department and position fields as text or use a numeric id. If I was doing this in a database I would select the ID and output the label.

$posts = get_posts( array(
		'numberposts' 	=> -1,
		'post_type'  	=> 'Staff-Member',
                    'meta_query'    =>  array(
                        'relation'  =>  'AND',
                        'department'  =>  array(
                            'key'       => 'department',
                            'value'     =>  array(1,2,3),
                            // 1='Admin', 2='Fiscal', 3='Maintenance'
                        ),
                        'position'    => array(
                            'key'       => 'position',
                            'value'   =>  array(1,2,3)
                            // 1='Manager', 2='Supervisor', 3='Staff'
                        )
                    ),
                    'orderby'   =>  array(
                        'department' =>   "ASC",
                        'position' =>   "ASC",
                    ),
				) );