Hi, I have some little problem to show some article with a little complex acf relationship.
I have 3 custom post types and some of them have a relation beetween them.
Country
– Country 01
– Country 02
– Country 03
– …
Sports
– Sport 01
– Sport 02
– Sport 03
– …
Trial
– Trial 01
– Trial 02
– Trial 03
– …
I want that when I am on a sport page, they show me the corresponding trial (Sport 01 -> Trial 01, Trial 11, Trial 21 …), that’s work fine with no real problem, and in this page they are also organised by category (Men Women)
In my trial page i have some data, like a relationship field inside the repeater. The relationship let me choose, on of the country, and that’s work fine too.
My problem is on the country page. I want to show some specific trials, that i filter with some value of the trials page (like the rank, the results…), and order them with is category, is parent … I make you a little scheme for you to understand.
Country 01
– First Place (value from a repeater in the trial field)
— Sport (parent of the trial)
— Category (Category of the trial
—- Trial 01 (The trial where, my country is on the first place)
I already filter the specific trial that I wanted and it works fine with
function my_posts_where( $where ) {
$where = str_replace("meta_key = 'resultats_%", "meta_key LIKE 'resultats_%", $where);
return $where;
}
add_filter('posts_where', 'my_posts_where');
// args
$args_one = array(
'numberposts' => -1,
'post_type' => 'epreuves',
'meta_query' => array(
'relation' => 'AND',
array(
'key' => 'resultats_%_rank',
'compare' => '=',
'value' => 1,
)
, array(
'key' => 'resultats_%_country',
'compare' => 'LIKE',
'value' => get_the_ID(),
)
)
);
<?
$the_query_one = new WP_Query( $args_one );
?>
<?php if( $the_query_one->have_posts() ): ?>
<ul>
RANK 01
<?php while ( $the_query_one->have_posts() ) : $the_query_one->the_post(); ?>
<li>
<a href="<?php the_permalink(); ?>"><?php the_title(); ?></a>
</li>
<?php endwhile; ?>
</ul>
<?php endif; ?>
<?php wp_reset_query();
But no, I don’t know how to group the results by category(men/women) inside each sport (the parent custom post type) ?
Thank you
The topic ‘Custom post type and crossed data’ is closed to new replies.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.