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:
