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 626 Bricks code tutorials with BricksLabs Pro

Leave the first comment

 

Related Tutorials..

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
Meta Box Image Advanced Field Images in Bricks Query Loop

Meta Box Image Advanced Field Images in Bricks Query Loop

Updated on 3 Feb 2025 A user asked: Do you know what the best way to query an image from metabox gallery? I would like…
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
Meta Box Relationship Posts Filtered by a Taxonomy Term in Bricks

Meta Box Relationship Posts Filtered by a Taxonomy Term in Bricks

Updated on 17 Feb 2025 In the Inner Circle a user asks: Hello, I have a relationship made in metabox between two Post Types “Travel”…
Categories:
Pro
Filtering posts by a group field’s subfield value with Meta Box when using a custom table in Bricks

Filtering posts by a group field’s subfield value with Meta Box when using a custom table in Bricks

Filtering a query loop to output only those posts with the value of a Select subfield of a Group field set to Yes when using…
Categories:
Tags:
Pro
Meta Box Checkbox List Query Type in Bricks

Meta Box Checkbox List Query Type in Bricks

This Pro tutorial provides the steps to add a new query type in Bricks builder for displaying the values of a Checkbox List type of…
Categories:
Pro
Meta Box Taxonomy Field’s Image Value in Posts

Meta Box Taxonomy Field’s Image Value in Posts

In a project I am currently working on, the requirement is to show the image of an "Image Advanced" type attached to a taxonomy in…
Categories:
Tags:
Pro
Bricks Forms + Meta Box: Auto-Create Post Relationships on Form Submission

Bricks Forms + Meta Box: Auto-Create Post Relationships on Form Submission

How to link a Bricks post-creation form on a post to a newly created post of another post type using Meta Box relationship.