Meta query with multiple logic (AND / OR)

The correct syntax for performing the AND OR is as follows:

'meta_query'    => array(
    'relation' => 'AND',
    array( 
        'key'     => 'flagged',
        'value'   => '1',
        'compare' => '!='
    ),
    array(
        'relation' => 'OR',
        array(
            'key'       => 'expiry_date',
            'value'     => date('Y-m-d',strtotime("today")),
            'compare'   => '>=',
            'type'      => 'DATETIME',
        ),
        array( //has no date
            'key'       => 'expiry_date',
            'value'     => '',
            'compare'   => '='
        )
    )
)

As a side note, it seems that post meta which are set to NULL (eg flagged) will not be returned by this query. Setting to any other value (such as 0) resolves this issue.

Related Posts:

  1. How to do a meta query using REST-API in WordPress 4.7+?
  2. Meta query terribly slow
  3. meta_query sorting by 2 keys
  4. Get result from meta_query() between two numbers
  5. How to handle optional end date in compare clause in meta_query
  6. Using meta_query on pre_get_posts to exclude a particular meta_key value
  7. Different page parameters inside query
  8. Return posts with specific meta key first, but the rest in alpha order by last name
  9. meta_query key value from array
  10. Order by nested named meta queries with ‘exists’ and ‘not exists’
  11. Arrange Posts By Date In Order Of Closest To The Current Date
  12. WP_User_Query with meta_query array relation ‘OR’
  13. meta_query problem
  14. Custom Upcoming Events List for Events Manager Plugin
  15. How to use meta_query to check if a meta field has something set?
  16. How to exlude posts that have certain meta_value?
  17. User Relationship
  18. WordPress Core – Optimizing meta_query generated SQL?
  19. Edit post_content on posts with Featured Image
  20. Display no post when metavalue is 0
  21. Use both meta query and tax query
  22. meta_query, number comparison, not quite working as it should
  23. Meta Query Compare with Date
  24. Query posts only if meta_value is not empty
  25. meta_query keys and sticky posts
  26. How to pass user meta_key and meta_value (values as array)
  27. meta_query compare=’!=’ with multiple custom fields
  28. Query posts with numeric meta values within a given range
  29. Fastest way to do meta query when I don’t need the actual posts, and just need post_id?
  30. meta_query not working on live site
  31. How to query post only with different excerpt?
  32. How do you get Posts by multiple meta_keys and meta_values with the Rest API V2?
  33. Meta query with regular expression does not work
  34. WP User Query Issues
  35. How to use meta query for greater than value in array?
  36. Wp Query custom search by meta query
  37. Filter posts by meta query?
  38. Help on multiple meta_query
  39. Meta query – How to display a null meta key
  40. pre_get_posts and set
  41. How to use orderby with meta_query?
  42. I would like to have add_post_meta to return the ID instead of true or false
  43. last_name + first_name orderby with meta_query [solved]
  44. Extend meta query arguments
  45. get_posts( $args ) return empty data
  46. how to get post meta where value is an array of key value pairs
  47. Meta Query Based on Month Range
  48. how to search all user meta data that have value like “vivek”
  49. Find posts by related taxonomy field
  50. wordpress meta value compare between two date
  51. Can I use pre_get_posts to add up values from two different meta_keys?
  52. WP JSON API meta_query not working
  53. get_users with Serialized Custom Meta Value
  54. Sorting posts by ACF field
  55. Ordering custom posts by meta field date
  56. latitude/longitude meta_query
  57. meta_query displays all results and none, my query is wrong
  58. How to properly escape values in meta query
  59. Delete all posts with a specific custom field using meta_query
  60. Fetch custom post related to a User
  61. How to Ordering by user meta
  62. Use meta_query in args for relationship
  63. meta_query Array
  64. meta_query compare “=“ returns nothing when it seems it should
  65. Order resultset by configured value and then list all the rest
  66. Issue with user meta_query
  67. How to get an archive page meta?
  68. Search for value(s) in meta field for a multi select
  69. Querying terms with calculations based on term meta data, sql vs. get_terms
  70. How can I create a meta_query with an array of dates?
  71. WordPress meta query not working
  72. Get meta_value from GDRating
  73. How to count items of meta query?
  74. WordPress meta query with meta serialized data array value
  75. wordpress meta query with multiple meta condition causing a load on server and slows down the server..!
  76. Why does this incorrect pre_get_posts meta_query work for sort order?
  77. How to sort custom posts including null meta-values ​in admin columns with meta_query?
  78. meta_query not filering but meta_key works fine
  79. get posts meta query returning the latest post if no meta key found
  80. WordPress search between two newmeric values with a custom post type
  81. like_escape notice when using LIKE in meta query
  82. WP User Query with meta queries
  83. Search using specific meta fields only (excluding post title and content)
  84. How to fetch WP_User_Query with multiple role arguments [duplicate]
  85. How to get meta value based on latest post id with group by term name
  86. Meta query not returning results even though the sql contains the information
  87. Display Users from two roles in one list
  88. WP_Query with UNIX timestamp in meta query
  89. Querying by meta key and value
  90. Multiple Queries with meta_query
  91. Get foreach for meta_query value
  92. Sort posts by post views and consider meta key
  93. Meta query “OR” comparison not working as expected with array
  94. order by meta_key [duplicate]
  95. WordPress Meta Query very slow with NOT EXISTS comparison
  96. ACF meta_query field treated as “0” resulting in false negative search when testing ranges
  97. Is it possible to customize meta query in this way?
  98. Ordering WP_Query results by second meta_key
  99. How making a new search box in admin post table working on a specific column
  100. wp_user_query with meta_value_num for leaderboard

Leave a Comment