Support

Account

Home Forums General Issues Trouble with relationship query Reply To: Trouble with relationship query

  • Hi @spigot

    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 -1.

    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