How to Save and Query Repeater Fields as Separate Fields

At first, we go to the WordPress Dashboard > JetEngine > Post Types directory to create a Custom Post Type.

We give it a name (“Registered Teams”), adjust its settings, and move the Meta Fields section to add some meta fields.

To add a meta field, press the “New Meta Field” button.

Initially, we add a “Text” field called “Website” and a “Clinics logo” “Media” field.

Then, we add a “Repeater” field called “Participant.” Among its sub-fields are three “Text” fields: “Name,” “Passport No,” and “Position.”

Every time you need a new sub-field, press the “New Meta Field” button.

We also activate the Save as separate fields toggle to save all the repeater field items in the separate fields in the database.

Save the post type by pressing the “Add/Update Post Type” button.

Now, head to the just-built post type and add the needed amount of posts.

For instance, we added three posts for three teams correspondingly. 

To edit the post, hover over the item and click the “Edit” button.

During the post editing, we also adjusted the repeater fields. We added participants, their passport numbers and positions.

To save the changes, press the “Update” button.

Head to WordPress Dashboard > JetEngine > Query Builder and press the “Add New” button to build a new query.

This query is needed so we can later display only clinics with surgeons in their team delegation in the listing template. 

We set the “Clinics with Surgeons” Name and scroll down to the Posts Query tab.

In the General tab, we select the “Registered Teams” Post Type to fetch the data from there.

Open the Meta Query tab. 

There, press the “Add new” button to adjust a meta query.

Set the Field key/name for the repeater sub-field. In our case, “participant_position.”

Then, we pick the “Equal” Compare operator. You can also use the “Contain” one if the position may consist of a few words.

Next, we set the Value. We want to pull out the teams that include participants with positions set to “surgeon,” so we insert it in the field.

Press the “Add Query” button.

Now, we go to WordPress Dashboard > JetEngine > Listings/Components and press the “Add new listing” button to create a new listing based on the above query.

In the given case, we create a listing template with a “Query Builder” Listing source, specify the built Query (“Clinics with Surgeons” in our case,) complete the Listing item name, and set its Listing view to “Elementor.”

Press the “Create Listing Item” button.

We fill in the template with the needed content. In our case, it is the Dynamic Image widget that displays the clinic logo and two Dynamic Fields with the team name and their website.

All the data in the added widgets is pulled from the meta fields we created earlier.

Once ready, press the “Publish/Update” button to save the listing template.

We want to display the listing on the page, so we move to WordPress Dashboard > Pages and press the “Add new” button.

For instance, we will work with the Elementor Page Builder.

Add a Listing Grid widget to the page. Select the just-built Listing.

Customize the page according to your needs and press the “Publish/Update” button.

Open the page on the front end. Now, the items in the Listing Grid are queried; only those teams that include participants whose position is set to “surgeon” are displayed.