ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)

This isn’t possible using WP_Query, you can’t query the insides of structured data stored in a single post meta value.

At best you can use regular expressions, or do math/boolean comparisons, you can even do LIKE comparisons, but these are all string operations.

If you need to query structured data such as objects or arrays, then the data needs breaking apart into multiple separate post meta values.

At the end of the day, post meta values are just strings of text as far as the database is concerned. You can cast them to a different basic data type such as a date or number, but that’s it.

Related Posts:

  1. WP_Query, ACF field and array
  2. Meta query with string starting like pattern
  3. compare meta_query in get_posts arguments
  4. ACF Relationship Field Search Filtering [closed]
  5. Filtering a WP_Query meta_query by numeric values isn’t working
  6. Getting attachments by meta value
  7. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  8. querying with custom meta field with meta_query
  9. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  10. Revolution Slider Orderby Two Custom Fields
  11. WordPress altering my custom query, How to fix it?
  12. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  13. meta_query with array as value
  14. Order by meta_key in custom post type doesn’t affect the query
  15. meta_key and meta_value not working together
  16. Order Posts by meta value AND published date
  17. If two first numbers exist in wp_meta_query value
  18. WP_Query meta_query >= date
  19. How To Fix WP Query Returns Results But Shouldn’t?
  20. ACF Date Based wp_query
  21. Custom query based on meta key – Reduce three states to two in results?
  22. What is the random string I am seeing when I use get_query_var?
  23. How to make Meta Query case sensitive?
  24. Any number in meta key (wp query)
  25. Fetch Record based on meta key dates
  26. Meta_query with multiple keys and multiple values
  27. meta_query BETWEEN, but the range is stored in the custom field
  28. Extend product search with meta in WooCommerce
  29. how to make members list directory through wordpress post custom meta key.
  30. Large AND OR query timing out
  31. meta_value_num not ordering all items
  32. WP_Query with meta_query dosen’t return results
  33. Query based on custom fields start and end date
  34. meta_compare not comparing whole integer
  35. filter wp_query result with custom field values
  36. Display posts with specific value first in query
  37. Get every post with value in meta key
  38. Custom query filter by ACF date custom field
  39. add_query_arg to compare and display events from a certain date
  40. Comparing 2 Decimal Numbers from custom fields and displaying posts
  41. meta_query weird behaviour, static int will work, but not user data
  42. Query multiple post types, but different order for each
  43. Order by the first array within a meta_query
  44. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  45. Query ACF relationship field – Comparator IN – Value array
  46. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  47. How do i create a custom post query when the meta value is an array?
  48. Query posts by post type, author and post meta
  49. WP Query – grouping posts by same meta key, adding together values from another key
  50. meta_query is overriding default search
  51. Trouble with serialized metadata
  52. Comparing Meta Field date in WPQuery using Meta_Query?
  53. Getting posts by custom field value
  54. Query against multiple locations within single custom post type post
  55. Pre get posts sort by meta key returns no results if meta key does not exist
  56. Order by Date Custom Field
  57. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  58. Query by meta value (add a dropdown of all values)
  59. Order Posts By Custom Field That is an array of objects
  60. Get posts meta_query by repater field
  61. How can I modify standard search query to include also ACF custom fields values?
  62. Custom WP_query and integrating into theme file
  63. Wrap group of wp query posts to parent div by date/year
  64. Using custom field as ‘orderby’ value causing post grouping by publish date
  65. Compare meta key separation
  66. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  67. query post based on comparison
  68. Query posts filter not working
  69. Display all custom meta field values from the database using ACF Repeater
  70. Get posts by meta value except one post [closed]
  71. Get posts using multiple values from ACF checkbox as meta query wordpress
  72. How do I subquery with custom meta fields?
  73. Best performance for use Custom Field in WP
  74. Use value from meta key array for use in WP_Query
  75. How to use meta_query to retrieve posts from multiple custom post type
  76. How to get products with the same custom attribute like ean code
  77. WP_Query filtering in ACF field containing dates
  78. Problem making a WPQuery with ACF boolean
  79. Display posts in correct month order using single date custom field
  80. Order by multiple custom fields within woocommerce hook for catalog ordering (woocommerce_get_catalog_ordering_args)
  81. Check if searched number is within the post meta value
  82. Meta query compare for ID’s greater than specific ID
  83. Appending to existing WP_Query’s meta_query if exists
  84. WP ForLoop to compare meta information of posts to determine what post to display
  85. WP_query shortcode inside acf Repeater breaks the repeater loop
  86. WordPress – Optimize the Meta Query for 3 meta keys at a time
  87. WP_Query not using relation key as expected and not producing any results
  88. Passing a variable containing a comma separated list of values in a meta-query
  89. Complicated `orderby` based on text in custom field
  90. Sort wp_query of two post types using meta datefield for one and date for the other – possible?
  91. Meta query with ACF relationship field
  92. meta_query post_date not returning results
  93. WP Query: orderby with one meta key, but multiple values
  94. Multiple meta value orderby clauses in a WP_Query
  95. WP_Query: how to sort all posts by date when one category has a custom “date” field?
  96. Include custom post type that matches taxonomy field in another custom post type
  97. Use Custom Field to Display Post Loop
  98. get_meta_sql hook is not firing
  99. WP_query with ajax filter not working with input fields
  100. Post Query with Meta Query no longer working
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)