Query Loop Based on Pods Relationship

How To
1

Does Bricks support Pods relationships? Watching videos based on ACF it looks like Bricks adds a new type of query that can be based on the relationship, but nothing is showing up for me with Pods.

Specifically, I have a cpt called Programs, with a relationship field that links to another cpt called Courses. I want to be able to pull in a few courses on the single Program template based on that relationship.

2

bricks query loop very powerfull you can create any relationships

why not make your relationship as a taxonomy and show related posts when they share the same taxonomy?

there is so many ways to build relationship with cpts and tax.

good thing is making post type and taxonomy based relationships are more optimized and performant as well.

3

I was able to sort of solve this using this code. Modified from this comment. That said, it works by using a relationship established by the course. It would be much better if I could set the relationship at the program and query from that. If anyone can help with this it would be appreciated!

return [
 'post_type' => 'course', 
 'posts_per_page' => -1,
 'meta_query'        => array(
     array(
            'key'       => 'highlight_for_program',
            'value'     => get_the_id(),
            'compare'   => 'LIKE'
        )
       ),
  'order' => 'ASC',
  'orderby'=> 'title', 
];
4

If the relationship is bidirectional each course has a list of programs and each program has a list of courses (you can see these in the wp_postmeta table as serialized arrays of numbers). Assuming the relationship field is called ā€œrelated_coursesā€ from the perspective of a program and ā€œrelated_programsā€ from the perspective of a course (you can name them anything):

// Running on a program post ID

$ids = pods()->field( 'related_courses', [ 'output' => 'ids' ] ) ?: [ 0 ];

return [
 'post_type' => 'course', 
 'posts_per_page' => -1,
 'post__in' => $ids,
 'order' => 'ASC',
 'orderby'=> 'post__in' // if you wanted to sort by position set in the UI
];

I think you can still do it using a meta query though (with fewer database calls):

return [
 'post_type' => 'course',
 'posts_per_page' => -1,
 'meta_query' => [
   [
     'key'     => 'related_courses', // The relationship field
     'value'   => 'i:'. get_the_ID() . ';', // Program ID
     'compare' => 'LIKE'
   ]
 ],
 'order' => 'ASC',
 'orderby'=> 'title'
];

Let me know if the latter works!