Home › Forums › Front-end Issues › Better query for ACF checkbox values? › Reply To: Better query for ACF checkbox values?
Hi @avwijk
I believe you can use the IN compare instead. You should also always try to use the WP_Query
class instead of get_posts()
. That’s just a wrapper which also bypasses several filters.
There’s also a few performance tricks one can do to improve performance on the WP_Query class. a single WP_Query actually runs 4 queries per default. We can disable some of these. Below is your query with two of the four queries removed.
$posts = new WP_Query(array(
'post_type' => 'team_member',
'posts_per_page' => 500, //never set to -1 as this is an hazard. what if we at some point has 10 000 posts?
'no_found_rows' => true, //since we dont use pagination we can use this
'update_post_term_cache' => false, //Since we dont use taxonomies we can use this. If you are going to output taxonomies based on this query remove this line.
'meta_query' => array(
'relation' => 'OR',
array(
'key' => 'groep',
'value' => array('7a', '7b', '8a', '8b'),
'compare' => 'IN'
)
)
));
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!
We’re working hard on Advanced Custom Fields PRO 6.0, and Beta 1 is now available 🚀
— Advanced Custom Fields (@wp_acf) August 12, 2022
Featuring improved performance for Repeater fields with large datasets, and a new generation of ACF Blocks.
Let’s take a look 🧵https://t.co/Befre3kFAo
© 2022 Advanced Custom Fields.
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Cookie Policy. If you continue to use this site, you consent to our use of cookies.