Querry with repeater-sub-fields

• TobiasHeuken

• August 8, 2017 at 7:08 am

Hi there,

I’m working with ACF Pro 5.6.1 on the website of a little open air theatre – http://www.reckenfeld-freilichtbuehne.de

There are 2 custom post-types, filed with ACF-fields.

1. actor-overview
2. play-overview

1. actor-overview
Every actor has it’s own profile page with a list of plays he/she takes part – with the year, name of the play and the name of the theatric part. For example – the profile page of Miriam: https://th-url.de/OiBRd

ACF-Field-group: actors
repeater-field: saison

repeater-subfields of saison:
1. year -> when you can see the play on stage (choice box)
2. play-name -> name of the play (choice box)
3. actor name -> first and last Name of the actor (choice box)
4. theatric part -> the name of the part in the play (1-row-text-field)

Example on Miriams profile page: https://th-url.de/OiBRd

Here you can see (example):
(2017) “Michel in the soup bowl”: participant of the…

2017 = field “year”
“Michel in the soup bowl” = field name of the play
participant = field theatric part

The field “3. actor name” is hidden on the profile pages, but it’s available.

2. play-overview

Every play has it’s own detail-page with description, images, play-dates, prices etc. – and a list of the actors. Example of the play 2017: “Michel in the soup bowl”: https://th-url.de/JWSbC

The play-plages has an own group of ACF-fields like description, prices, image-galleries, dates etc.

My plans are now like this:

create a dynamic list of actors of the play – with the theatric part

There are some information, which are identical in the background:

Every actor post and every play-post are in the same category. The name of the categories equals the name of the play.

Example in angled brackets:
play-name: [Michel in the soup bowl]
category-name: [Michel in the soup bowl]
repeater sub-field “play-name” @ actor-profiles: [Michel in the soup bowl]

My idea is now … and I’ve got a problem with the php-querry (should be insered in the play-template):

1. Get the title/name of the play => Michel in the soup bowl
2. compare the play-title from 1. with the repeater-sub-field “play-name”

play-title: [Michel in the soup bowl] = repeater-sub-field “play-name” [Michel in the soup bowl]

alternative: compare the play-post-category with the repeater-sub-field “play-name”
3. show me the ACF-repeater-sub-fields: “theatric part”: actor name

In the end, I need a dynamic list on the play-posts of the actors and their theatric parts. A friend (for 3 weeks on holidays now) told me, it’s verry simple and easy with 3 or 4 querries … but … damm … I’ve got a blockade with this querry.

• TobiasHeuken

• August 13, 2017 at 5:01 pm

Has anyone any ideas?

• TobiasHeuken

• September 24, 2017 at 8:48 am

I found a solution with ACF … topic solved