ACF relationship field on options page - query not working WordPress

herrfischer comments:

For several reasons i don't want to use a post type.

Andrea P comments:

then you could try adding a conditional within the custom field loop, which will display the box only if the post within the relationship field is the same as the currently viewed page's main query.

something like this:


<?php
// -------------------------------------------------------
// FLEXIBLE content fields for Info Boxes
// -------------------------------------------------------

// store the current post id
$current_post_id = get_the_ID();

if( have_rows('info_boxen_anlegen', 'option') ) :

// loop through the rows of data
while ( have_rows('info_boxen_anlegen', 'option') ) : the_row(); ?>

<?php if( get_row_layout() == 'normale_info_box' ): ?>

<?php $posts = get_sub_field('box_loaction');

if( $posts ): ?>

<ul>

<?php foreach( $posts as $post): // variable must be called $post (IMPORTANT) ?>

<?php setup_postdata($post); ?>

<?php if ($post->ID == $current_post_id) { ?>

<li>
is it working???
</li>

<?php } ?>

<?php endforeach; ?>

</ul>

<?php wp_reset_postdata(); // IMPORTANT - reset the $post object so the rest of the page works correctly ?>

<?php endif; ?>

<?php endif; endwhile; endif; ?>


herrfischer comments:

hello andrea, with this code there is nothing shown.

herrfischer comments:

hello andrea, with this code there is nothing shown.

herrfischer comments:

@andrea: If i would have custom post type i would use a query like this:


<?php
// WP_Query arguments
$args = array(
'post_type' => 'infobox',
'meta_query' => array(
'relation' => 'OR',
array(
'value' => '"' . get_the_ID() . '"',
'compare' => 'LIKE'
)
)
);
?>


This would work with post types, but not with option fields. The reason that i don't want to use a post type is that i am not very flexible with these. You can e.g. not chose a template for a custom post type (like with pages), sure i could make a template like "single-cpt_name.php", but i can not make more templates for 1 custom post type. now some could say i have to build more custom post types (i want to serve 30 of these info-boxes with several layouts) but

1: it looks ugly to have 30 post types in the sidebar and - more important for me:
2: i have posts and see only headlines in the overview (i have to open every post to see what is in there and where the box is shown etc.) – in contrast to this, on my options page i see all boxes with all fields on one page which is my final goal

but maybe "options" is just an "options" page like the name says and not for streaming content onto the page … hmmm … but it would be kinda cool. it works perfect, but not with the relationship field, the relation seems to be broken or something.

Andrea P comments:

I think the code was not working because I thought the relationship field was passing an object rather than an id.

try this:

<?php
// -------------------------------------------------------
// FLEXIBLE content fields for Info Boxes
// -------------------------------------------------------


// store the current post id
$current_post_id = get_the_ID();

if( have_rows('info_boxen_anlegen', 'option') ) :

// loop through the rows of data

while ( have_rows('info_boxen_anlegen', 'option') ) : the_row(); ?>

<?php if( get_row_layout() == 'normale_info_box' ): ?>

<?php $posts = get_sub_field('box_loaction');

if( $posts ): ?>

<ul>

<?php foreach( $posts as $post): // variable must be called $post (IMPORTANT) ?>

<?php if ($post == $current_post_id) { ?>

<?php setup_postdata($post); ?>

<li>
is it working???
</li>

<?php } ?>

<?php endforeach; ?>

</ul>

<?php wp_reset_postdata(); // IMPORTANT - reset the $post object so the rest of the page works correctly ?>


<?php endif; ?>
<?php endif; endwhile; endif; ?>


regarding your points, the problem is that a relationship field is not acting into the post that you select within the field, but into the page (in this case the options page), where you placed the field. so if you select the kontakt post in the options page field, the actual kontakt post won't have memory of that selection.

but probably the above code would work for you, because it will check all the info-boxes from the options page, and display only the one which has the current post set into the relationship field (this will also allow for a box to have more than one post connected into the relationship field).

herrfischer comments:

andreas and bobs solutions are both working, i think andrea was faster?

Andrea P comments:

I'm glad it works fine for your needs.

I still have doubts regarding the structure, because in this way you are going to make a quite tricky nested loop every time someone views a posts. your code will retrieve the flexible content fields (all of them) and then loop each of them. for each of them it will then retrieve the relationship field (which could be one or more posts), and loop each of those post ids. it will then print out only data from the box in which the post is the same as the current, but it will browse all the repeater fields and all their relationship posts ids..

though I do understand your points regarding an easier and nicer administration of the boxes. I had a look at it and it is definitely more straight forward than using a post type. but be aware that if you are going to have a lot of these boxes, and a lot of visits, this could have some effects on your site performances. (though you could easily fix them by using caching plugins or similar solutions).


p.s. I just thought that you should move the wp_reset_postdata(); just before the braket that closes the conditional if ($post == $current_post_id) {
in this way it will run the reset_postdata (which is a costly function) only for the box which is actually being displayed, and so only if it actually set up the post data.

p.p.s. regarding the prize, my answer was posted a few hours earlier, so we normally assign the prize to the first correct answer, but in any case it's up to you.

cheers!