Reverse Page Link Query

• [email protected]

• June 9, 2017 at 5:22 pm

I have a post type of “website” and a post type of “on_site_checklist”.

“on_site_checklist” has a page link custom field of “parent_website”.

On the “website” post type how would I query every “on_site_checklist” that has the “website” post type selected?

ie. “website” is called example.com. “on_site_checklist” has example.com selected. Now show “on_site_checklist” on “website” post type.

Thanks for the help.

• [email protected]

• June 10, 2017 at 2:13 am

OK Here’s what I have tried. The concept that I am going with is that the “Page Link” custom field type stores the URL in a string and we just need to query by that meta value. But, it’s not working.

Any ideas?

<?php 
$currentURL = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];

$args = array(
	'numberposts'	=> -1,
	'post_type'		=> 'on_site_optimization',
	'meta_query'	=> array(
		'relation'		=> 'AND',
		array(
			'key'		=> 'website_parent',
			'value'		=> $currentURL,
			'compare'	=> 'LIKE'
		),
	)
);

// query
$the_query = new WP_Query( $args );

?>
<?php if( $the_query->have_posts() ): ?>
	<ul>
	<?php while( $the_query->have_posts() ) : $the_query->the_post(); ?>
		<li>
			<a href="<?php the_permalink(); ?>">
				<?php the_title(); ?>
			</a>
		</li>
	<?php endwhile; ?>
	</ul>
<?php endif; ?>

<?php wp_reset_query(); ?>