11th Dec '23
/
0 comments

Limiting the Query Loop Posts Output to Post IDs From a Custom Field in Bricks

A user asks:

I have a list of posts (IDs) in a custom field of a CPT. On a Bricks template, I need to run a query for the IDs in the custom field only. How can I tell the query loop builder to use the IDs from the custom field only?

In PHP, I’d add this (custom field is an array):

post__in => $custom_field

But How can I add this to Bricks? Do I have to create a custom Query in PHP and hook that into the builder, or is there an easier way?

Recently Bricks introduced the PHP query editor that lets us modify the query parameters right within the query dialog of the builder rather than having to do it outside using a code snippets plugin or child theme’s functions.php.

Generally speaking, a “Post” type of Meta Box field or a Relationship is better suited when the requirement is to select one or more posts (of any post type) when editing a post (of any post type). But in this case, let’s go with a “Select advanced” field type per the user’s question.

The above field group’s location is set to Post type = Page (page).

Post IDs field being populated on a sample Page:

Set up a query loop in the Bricks template that applies to all single pages of the page post type.

Click on the query icon and toggle “Query editor (PHP)” on.

Paste:

return [
  'post__in' => rwmb_meta( 'post_ids' ),
  'posts_per_page' => '-1',
];

where post_ids is the ID of the field group.

That will tell Bricks (to tell WordPress) to fetch all the posts whose IDs are in the array of posts returned by the value of that custom field.

Get access to all 610 Bricks code tutorials with BricksLabs Pro

Leave the first comment

 

Related Tutorials..

Pro
Meta Box Relationship in Bricks using Posts Query Loop

Meta Box Relationship in Bricks using Posts Query Loop

This Pro tutorial is similar to the recent ACF Relationship in Bricks using Posts Query Loop guide but for Meta Box. In the past, we…
Categories:
Pro
Meta Box Color Picker to CSS Custom Property Workflow in Bricks

Meta Box Color Picker to CSS Custom Property Workflow in Bricks

This Pro tutorial provides the steps to declare a custom property (CSS variable) whose value is equal to the post-specific color set via a custom…
Categories:
Tags:
Random Meta Box Image

Random Meta Box Image

Displaying a random image from a set of images from a Meta Box Images Advanced-type field.
Categories:
Tags:
Pro
Bricks Dynamic Data Tag for Text-type Custom Field Value with Word Limit

Bricks Dynamic Data Tag for Text-type Custom Field Value with Word Limit

How to register a new dynamic tag for setting excerpt word limits and outputting an ellipsis (...) at the end.
Categories:
Pro
Dynamic Post-specific Templates in Bricks using Meta Box/ACF Select Field

Dynamic Post-specific Templates in Bricks using Meta Box/ACF Select Field

Update on 23 Aug 2023: Added steps for ACF. Bricks builder v1.8.4 introduced an pretty useful filter called bricks/active_templates that flew under the radar. This…
Pro
Post Data for the Current User in Bricks with Meta Box

Post Data for the Current User in Bricks with Meta Box

How to configure a query loop to output the post data of the SalesRep CPT associated with the current user.
Categories: