ACF repeater order rows

Loops & Logic
1

Hi, how can I sort rows of an ACF repeater based on a subfield value ?

This expression doesn’t work for now :

<Loop acf_repeater=field_name orderby_field=subfield order=desc>
 <Field subfield />
</Loop>

Thank you !

3

Hi Guillaume,

I haven’t tested it, but I think it could work using sort_field, documented here.

<Loop acf_repeater=field_name sort_field=subfield sort_order=desc>

If the field value is a number, you can try adding sort_type=number.

The difference between sort_field and orderby_field is that the latter is converted to a direct database query, which is limited to raw field values - which means most ACF field types are not supported, other than plain text values. In contrast, sort_field will sort the loop items after the database query, using the same function as the Field tag, which should work with ACF repeater field’s subfields.

4

Yes, it works. Thanks !

1 Like
5

Hi Eliot,

I have tried this :

<Loop acf_repeater="wk_timeline_feed" sort_field="post_datetime" sort_type="date" sort_date_format="d/m/Y H:i" sort_order="desc">
<Field post_datetime /> 
<Field post_content />  
</Loop>

But the rows in the repeater aren’t sorted by desc date. Do you know if there is any limitation on this use case ?

Best

6

Anyone please ? @eliot thanks !

7

Hi @bikloz, there’s a new plugin version 4.2.3 with some improvements for sorting ACF repeater fields by date. Please try the following:

<Loop acf_repeater=wk_timeline_feed
  sort_field=post_datetime sort_type=date sort_order=desc>

The sort_date_format is not needed because ACF stores date field values in the format Y-m-d or Y-m-d H:i:s, regardless of the field settings.

1 Like
8

Thanks a lot @eliot it works indeed !

1 Like