query posts, filter by custom checkbox

• amyK

• August 4, 2021 at 1:25 pm

I’m hoping someone can help me figure out what I’m doing wrong here.

I’m trying to produce a list of “Resource” posts (custom post type) that are videos. I have a custom field checkbox for each resource with three choices of ‘sal_resource_type’ (Literature, Audio Recording, and Video.) When I use the following code, I get a list of ALL resource posts, regardless of what type or if any of the boxes are checked at all.

I’ve tried many versions of this with no luck, and have read many others with similar questions but more complicated queries. What am I missing?

Here’s the code as I have it now:

<?php 
// args
$vid_args = array(
	'posts_per_page'	=> -1,
	'post_type'		=> 'resource',
	'orderby' 		=> 'title', 
	'order' 		=> 'ASC',
	'key'			=> 'sal_resource_type',
	'value'			=> '"Video"',
	'compare'		=> 'LIKE'
);

// query
	$vid_query = new WP_Query( $vid_args );
?>
<?php if( $vid_query->have_posts() ): ?>
<h3>Videos</h3>
<ul>
	<?php while( $vid_query->have_posts() ) : $vid_query->the_post(); ?>
	<li>
		<a href="<?php the_permalink(); ?>">
							
			<?php the_title(); ?>
		</a>
	</li>
					
	<?php endwhile; ?>
</ul>
<?php endif; ?>

<?php wp_reset_query();	

When I use print_r as below:

<?php $testTypes = get_field('sal_resource_type');
							print_r($testTypes);

I get results like this:
Array ( [0] => Literature )

What am I missing??

Thanks in advance for any help.

• John Huebner

• August 4, 2021 at 2:35 pm

$vid_args = array(
	'posts_per_page'	=> -1,
	'post_type'		=> 'resource',
	'orderby' 		=> 'title', 
	'order' 		=> 'ASC',
	'meta_key'			=> 'sal_resource_type',
	'meta_value'			=> '"Video"',
	'meta_compare'		=> 'LIKE'
);

• amyK

• August 4, 2021 at 3:05 pm

Hallelujah! Thanks