I recently started a topic on here which helped me take a single department page (department content type) and list out the faculty (people content type) that are linked to that department via Post Object.
Here’s that topic: https://support.advancedcustomfields.com/forums/topic/querying-a-post-object-relation-field-inside-a-repeater/
I may have pre-maturely marked it solved.
Say the department is Math. I set up the code to display the faculty appropriately under two different headings: Department Head and Supporting Members. The distinction is made via a checkbox sub-field, right next to the one in which that person is linked to the department (again, by Post Object)
The problem is the code in the link (and below) is looking at the repeater and subfield and processing it as “if this person is marked as department head in ANY department, list them as the department head in this department.” or “if this person is marked as a supporting member in ANY department, list them under supporting faculty for this department.”
What I need is for the second part of the meta_query to only apply to the particular row resulting from the first part.
It looks like this tutorial does a good job of querying specific data to particular repeater rows…is this what I need? And if so, how can I assign it to a different content type?
OR
Is there a way to use the code below but tell it that two subfields of the meta_query must be aligned to the same particular row?
<?php
// filter
function my_posts_where( $where ) {
$where = str_replace("meta_key = 'person_department_%", "meta_key LIKE 'person_department_%", $where);
return $where;
}
add_filter('posts_where', 'my_posts_where');
// checks if there's a department head
// if so, displays that person
// args
$args_faculty_head = array(
'posts_per_page' => -1,
'post_type' => 'people',
'orderby' => 'title',
'order' => 'ASC',
'meta_query' => array(
'relation' => 'AND',
array(
'key' => 'person_department_%_person_department_select', // this should be the first sub-field
'value' => get_the_ID(),
'compare' => '='
),
array(
'key' => 'person_department_%_person_department_head', // this should be the second sub-field
'value' => '"Yes"',
'compare' => 'LIKE'
)
)
);
// query
$the_query = new WP_Query( $args_faculty_head );
?>
<?php if( $the_query->have_posts() ): ?>
<ul>
<?php while ( $the_query->have_posts() ) : $the_query->the_post(); ?>
<li>
<?php the_title(); ?>
</li>
<?php endwhile; ?>
</ul>
<?php endif; ?>
<?php wp_reset_query(); // Restore global post data stomped by the_post(). ?>
