10th Nov '22
/
5 comments

Meta Box Relationship in Bricks

Updated on 19 Mar 2024

In BricksLabs' Facebook group a user asks:

I have a Product (Metabox CPT) that is connected to a Creator (Metabox CPT) via Relationships.

In the Product single page, I want to list 'Other products from the same Creator' using a loop item.

How do I query this?

From what I see, this is not possible to do using the built-in controls of the Query interface in Bricks.

We need to:

  • get connected creators from the current product
  • get products connected to the above creators
  • remove the current product from the above products
  • modify the query to show only the above products

With post type A to post type B Meta Box relationship, this Pro tutorial provides the steps to use Meta Box' API for querying items of post type B connected to the current item of post type A (forward query), then doing a backward query to get all items of post type A connected to the matching post type B items and removing any occurrences of current post type A items to finally pass them to Bricks' bricks/posts/query_vars filter.

In the Meta Box documentation, the example provided is Posts connected to Pages.

Per the original question, the relationship is: Products connected to Creators.

In the example below, we are going to do Events connected to Testimonials (I happen to have entries for these already present in my local test site and just went with this setup).

Here is the notes I put together of the problem statement:

Problem Statement

Relationship title: Event <-> Testimonial

Relationship ID: event-testimonial

Event 1 (2431): Frances Harper (2811)

Event 2 (2432): James Colley (2809) and Alicia Burke (2807)

Event 3 (4263): Frances Harper (2811) and James Colley (2809)

Event 4 (4264): Alicia Burke (2807)

Numbers in parentheses indicate the item ID.

Objective: In the Event single page, list other events having the same testimonial.

When viewing Event 3 which has testimonials by Frances Harper and James Colley, for example, show all other events that have testimonials by either of them i.e., Event 1 and Event 2.

We will also get the count of the matching events and ensure that the Section in which we have the Posts element (which could also be a Query Loop instead) only outputs if there is at least 1 event to be shown.

Step 1

Install and activate Meta Box and Meta Box AIO.

Create your two post types.

Go to Meta Box → Relationships and create one.

Step 2

Create a few testimonial entries:

and some event entries:

Step 3

Add a new Bricks template named "Single Event" of the type "Single" and edit it with Bricks.

Click the Settings (gear) icon → TEMPLATE SETTINGS → CONDITIONS and add a Post type = Events.

Add a Section and inside its Container, Post Title and Post Content elements.

Add another Section and inside its Container, a "Related Events" Heading.

Set up a Query Loop.

Click the Query loop icon and enable the PHP query editor.

Paste:

This is a BricksLabs Pro tutorial.

For full access login below or create your BricksLabs Pro account

Get access to all 630 Bricks code tutorials with BricksLabs Pro

Related Tutorials..

Pro
Meta Box Date Field Value Custom Format in Bricks

Meta Box Date Field Value Custom Format in Bricks

Updated on 3 Apr 2024 Note: A custom function is no longer needed. Use the date format filter, as mentioned in the Bricks documentation. Ex.:…
Categories:
Tags:
[Function] Current Term Has Children

[Function] Current Term Has Children

Updated on 20 Jul 2024 A user asks: I'm working on an archive template for WooCommerce products. I'm trying to hide a section if there…
Check if a given category has at least one post

Check if a given category has at least one post

There could be situations where you want to check if a given category (by its slug) has at least 1 post assigned to that category.…
Categories:
Pro
Filtering Cloneable Meta Box Group by Sub Field Value in Bricks

Filtering Cloneable Meta Box Group by Sub Field Value in Bricks

This Pro tutorial provides the steps to filter the rows of a Meta Box cloneable group to only those that have a date custom field…
Pro
Sorting ACF Relationship Posts by Date Meta in Bricks

Sorting ACF Relationship Posts by Date Meta in Bricks

Consider the following setup: CPT: Events ACF Fields:Event Date Information (Group)|__Event Date (Date Picker)Pick Sub Events (Relationship) An Event can have 1 or more related…
Pro
HappyFiles Folder Images via Meta Box Taxonomy Field in Bricks Image Gallery

HappyFiles Folder Images via Meta Box Taxonomy Field in Bricks Image Gallery

How to set the source of Bricks’ Image Gallery element on a post to images in the selected HappyFiles Folder(s) via a Meta Box Taxonomy…
Pro
Meta Box Group’s Number Sub Field Values Sum

Meta Box Group’s Number Sub Field Values Sum

In the Bricks Facebook group a user asked: We can define a custom function that takes a Meta Box group ID, the sub field ID…
Categories:
Tags: