Hi, I’m trying to query a relationship between two CPT’s as a pretty much spot on example of this tutorial: http://www.advancedcustomfields.com/resources/tutorials/querying-relationship-fields/, but it’s not working out quite right…
The issue I’m having… For most artists, nothing appears. There are a few, however, that show a single piece of art, even though multiple artworks are associated.
When testing, if I removed the
meta_query portion of the query only 5 posts appear.
Can anyone tell me what I’m doing wrong here? The code seems pretty spot on to the tutorial…
Thanks, great plugin – this is my first time using it and it’s quickly proving to be a tool I’ll use again and again.
Thanks for all the info. Very clear!
As for the code. You will need to add in the ‘posts_per_page’ arg and set it to
This should fit the 5 post limit issue.
As for the code, it looks great.
If you turn the get_posts into a WP_Query, you can then debug the actual SQL. This will help to spot any issues in the SQL.
You can do this like so:
<?php $artworks = new WP_Query(array( 'post_type' => 'artworks', 'meta_query' => array( array( 'key' => 'artist', // name of custom field 'value' => '"' . get_the_ID() . '"', // matches exaclty "123", not just 123. This prevents a match for "1234" 'compare' => 'LIKE' ) ) )); print_r($artworks); die;
Hope that helps
I was able to get the query to work by removing the quotes from the
value param as such:
'value' => get_the_ID(), // dropped the quotes around the value since its a number
Hopefully this doesn’t cause other issues, but I’m glad it’s working. Any thoughts on why it’s different from your code? Perhaps you can explain further why the quotes were there in the first place. Have you seen issues arise with false positives?
You must be logged in to reply to this topic.
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!
© 2020 Advanced Custom Fields. Subscribe