[Gelöst] Order posts by date in repeating field group

[Author]

Artikel

[marcialB]

Hi there

I have several events, each event has several dates (added in a repeating field group). I want to show all my events in a list ordered by the date of the first event date.

It's a nested view: the outer view queries the events, the inner view returns the next upcoming date of that event.

I'd like to use the same logic I use in the inner view to order the outer view.

Thanks for your help!

[Nigel]

Hi there

Because of how the repeatable field groups are implemented, via child posts for each instance of a group of fields, the field values themselves belong to the child posts and not to the original post that the repeatable field group is assigned to.

And you can only order posts by properties of the posts (which is why you can order the date groups by their event date fields). You cannot order the outer events by fields of the inner date groups.

The simplest solution would be to add a field to the event posts that directly records the next upcoming event date, which can then be used to order the event posts.

Although that involves some duplication of data, it is the most effective way to achieve what you need.

You would probably want to automate storing the next date on the event post. If you were submitting content from the front-end only via Toolset Forms, you could likely use the cred_save_data hook to trigger the relevant code, but if the data may be input or edited in the back end (or via import) then you would need to use the more generic WordPress save_post hook.

[marcialB]

Thanks for your suggestions. I'll try to use the save_post hook to copy the upcoming date to the main post.