Cache issue with WP_Query and custom field filtering

Found a fix. Apparently CMB doesn’t use integers while saving values to database from custom checkboxes, but rather adds an on string when a checkbox is checked.

Also when a previously checked checkbox is unchecked, the corresponding row isn’t removed from wp_postmeta table, but remains there with an empty value.

So this will return all posts that at some point have had the checkbox active:

'meta_key' => '_cmb_work_front_large',
'meta_value_num' => 1

And this will show only the active ones:

'meta_key' => '_cmb_work_front_large',
'meta_value' => 'on'

Related Posts:

  1. Multiple orderby values in WP_Query
  2. Search multiple custom fields by using meta_query
  3. WP_Query orderby custom field then post_date in one query
  4. how to filter by last name for custom post
  5. Filtering a WP_Query meta_query by numeric values isn’t working
  6. Sorting a query by custom field date
  7. Filtering a WP Query result
  8. Display Custom Post Type Fields
  9. Search Custom Post Type with all meta attached?
  10. How to sort CPT by custom meta value (date), and return posts month by month
  11. WP_Query on custom post type not displaying, multiple loops & get_template_part
  12. Using new WP_Query in shortcode in a custom field causes the main post content to not display
  13. WordPress query by multiple Custom fields and order by date
  14. Comparing timestamps in meta query doesn’t work
  15. Display two post types ordered by two custom fields
  16. Get post info inside modal window?
  17. WP Query group/order by category name
  18. Having trouble with custom date field for CPT query (WordPress)
  19. Display posts if a custom field value is equal to another custom field value
  20. Sort by two dates. Default entry date and custom field if present
  21. Filtering by Post Meta Custom Fields – Performance
  22. wp_query to find posts by year and month
  23. WP Query—Relationship between two custom post types and their fields
  24. How to dynamically attach pictures to a carousel
  25. Custom Post type and Custom Field WP_Query
  26. Including Custom Meta with posts_where query
  27. WP_Query: include custom post type only with specific meta value
  28. WP_Query orderby modified to include custom meta changes
  29. WordPress custom loop filter by meta_key and value with serialize data
  30. Returning a list of custom post types excluding those without a specific meta_value
  31. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  32. How can I get the number of custom post type posts that have a specific attachment image set?
  33. Problem querying Custom post type by custom fields
  34. Orderby CPT custom fields not working
  35. WP_Query order by custom field, then randomly order some of results
  36. Query custom post type with ACF Date
  37. Including metaboxes from custom post types in global search — continued
  38. Query Multiple Custom Posts by Custom Fields
  39. Get Posts by multiple custom fields is not working
  40. Order Custom Post Type by Custom Field Value
  41. First custom field value (out of several) displayed twice after query
  42. Possible to filter custom post type with multiple meta data?
  43. Query based on custom fields start and end date
  44. DIsplaying URL of custom field in last post of certain taxonomy && post type
  45. WP Query ‘posts_per_page’
  46. Display post from a date range from custom field
  47. post_per_page ignored in WP_Query
  48. How to get specific post meta by title or id
  49. Getting a custom post’s custom field based on another custom post’s custom field select
  50. WP_Query orderby not work with meta_key
  51. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  52. Display custom post type for specific user
  53. Custom Post type loop with ACF not displaying properly
  54. Group by custom field value (start and end times)
  55. How do I list a custom field and custom taxonomies for each result in a loop?
  56. WP query_posts group by meta field related
  57. Custom Form / Search with Custom Post Type Data
  58. Create if else for post types in WP_Query ‘post__in’ values
  59. WP Query from two Custom Post type fields as statement
  60. Alike Shortcode using in Custom Shortcode
  61. Query custom post type that has a serialized relational advanced custom field value
  62. WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
  63. WP_Query get always custom post_type for first
  64. Sort custom post column by generated value?
  65. How can I query and sort custom-post type using WP_Query
  66. Filter posts by their related field’s custom field
  67. Query custom post type and custom field by URL parameters
  68. Custom meta fields not showing up in WP_Response Object via custom endpoint
  69. Query a Custom Post Type using SELECT that has ACF fields to compare dates
  70. meta query multiple values for the same key
  71. Sort custom post archives by a meta value from a different custom post type?
  72. Custom post types – meta_query: search lesson which starts sooner
  73. Post Filtered by Custom Field Value
  74. Filter custom WP_Query by first letter of a custom field – hopefully using Search and Filter Pro?
  75. sorting in wp query based on custom field value
  76. Meta_Query refuses to return results
  77. WordPress query in which condition uses custom field
  78. WordPress loop add heading before first of type
  79. How to make a shortcode for my WP_Query Loop? [duplicate]
  80. Error in WP Query. If variable is empty it is displaying previous post value
  81. Query events post type after current date and timezone
  82. Calling specific page with wp query
  83. How to stop wp_query searching pages as well as the specified CPT
  84. Selecting posts older than the current Unix epoch timestamp
  85. WP_Query and two custom fields returns no posts
  86. WP_Query get posts where post_name is empty
  87. Storing/querying custom date data
  88. Query recent posts by author
  89. 404 on Pages for Custom Post Type & Query_Posts
  90. Querying meta values within an array
  91. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  92. Filter Custom post type by another Custom post type
  93. Show Posts in Vertical Tabs with Scrollbar
  94. How to show all posts of specific custom post type with their custom fields values?
  95. querying to custom field over ACF REST API
  96. Display ACF object field data using Elementor Custom Query
  97. WordPress custom field sorting, weird behavior: the latest post is at the end
  98. Sort CPT by taxonomy AND THEN by custom field
  99. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?
  100. Query order by a numeric ACF field