WP_Query order by repeater subfield

• Konstantinos

• July 28, 2018 at 10:19 pm

Hello.

I want to order posts by a repeater sub field but i cant find the way…

Pic of fields: click here!
Repeater name: mdb_album
Repeater sub field name: mdb_album_field_number

So i try to add meta_key’ => ‘mdb_album_field_number as this example “Order posts by custom fields” but nothing…

Here is the code that load the post with no order.

$qobj = get_queried_object();
$repeater = get_field('repeater');
$args = array(
	'post_type'      => 'post',
	'posts_per_page' => 999,
	//'meta_key'       => 'mdb_album_field_number',
	'orderby'        => 'meta_value',
	'order'          => 'DESC',
	'tax_query'      => array(
		array(
			'taxonomy' => $qobj->taxonomy,
			'field'    => 'id',
			'terms'    => $qobj->term_id,
		)
	)
);
$query = new WP_Query( $args );

• John Huebner

• July 29, 2018 at 12:22 am

You cannot order by a repeater sub field. Ordering by any meta field requires that all of the values are stored with the same meta key and this is not how a repeater works. My suggestion is to read this https://acfextras.com/dont-query-repeaters/

• Konstantinos

• July 31, 2018 at 8:05 pm

I found a nasty js solution which works with tables.
How TO – Sort a Table

This case work nice ONLY if someone loads all the values in the same page.