WP_Query using meta_query with relation OR and orderby meta_value doesn’t work

The issue is that WordPress are getting all posts that has a ‘startDate’ meta key, no matter the meta value.

You can understand that form this part of the request:

...
AND (
 wp_postmeta.meta_key = 'startDate'
 OR ( mt1.meta_key = 'startDate' AND CAST(mt1.meta_value AS CHAR) >= '20140305' )
 OR ( mt2.meta_key = 'endDate' AND CAST(mt2.meta_value AS CHAR) >= '20140305' )
)
...

so if a post has a the meta_key ‘startDate’ it will be returned.

The culprit of this behavior is the 'meta_key' argument

...
new WP_Query( array(
    'post_type'     => 'evenements',
    'orderby'       => 'meta_value',
    'meta_key'      => 'startDate', // <-- this is the culprit
    ...

However, if you remove it you will not be able to order by a meta value, because, sometimes WordPress is… (I don’t know the english term, complete the sentence by yourself).

The solution is (should be) put the first part of your meta query (regarding start date), as plain arguments (not part of meta_query), and the second part (regarding end date) inside meta_query array:

$evenements = new WP_Query(array(
  'post_type'      => 'evenements',
  'meta_key'       => 'startDate',
  'meta_value'     => date('Ymd'),
  'meta_type'      => 'NUMERIC',
  'meta_compare'   => '>=',
  'orderby'        => 'meta_value',
  'order'          => 'ASC',
  'meta_query'     => array(
    'relation'  => 'OR',
     array (
       'key'     => 'endDate',
       'value'   => date('Ymd'),
       'compare' => '>=',
       'type'    => 'NUMERIC'
     )
  )
));

Your setup is too complex to make me test it accurately, so try it yourself and let me know.

Related Posts:

  1. meta_query ‘compare’ => ‘IN’ not working
  2. How to query posts based on lat-lng coordinate as post meta?
  3. Set Alias for meta_query arguments in get_posts()
  4. Sorting: custom query with orderby meta_value_num THEN by title
  5. WP_Query with checkbox meta_query
  6. Add indexing to meta_value in wp_postmeta
  7. Is it possible to orderby multiple meta_keys when using meta_value_num?
  8. Custom WP_Query order by post_meta and (author) user_meta
  9. Perform query with meta_value date
  10. Meta Query with date and time on the same Day before given time
  11. How to grab metabox value in wp_query meta_query key
  12. Is “orderby” in WP Meta Query conflicting with Meta Query?
  13. datetime picker, timestamps and meta queries
  14. Compare two meta-fields in a wp_query (where meta-field-A is larger than meta-field-B)
  15. How can I create a WP_Query that returns posts where one meta_value
  16. Meta Query querrying several post types based on ACF fields is broken after update to WP 4.1
  17. WP Meta Query for some meta (array) values
  18. Sort users by meta_value_num
  19. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  20. How to get sum of meta_values of a meta_key in wp_query according to conditions
  21. How to count data records in wordpress which have same meta_value in wp_postmeta table?
  22. Meta_query with or without value
  23. meta_key and meta_value not working together
  24. Order WP Query posts by custom order calculated from post meta values
  25. how to speed up a complex wp_query?
  26. How to query for custom field within Gutenberg block from outside of that post? [closed]
  27. Meta Query for specific months
  28. Meta query with JSON value
  29. Get meta info related to current post
  30. Creating arguments from loop for WP_Query meta_query
  31. wp_query not searching with apostrophe
  32. Add condition of user capability in WP_query
  33. ACF Date Based wp_query
  34. Custom query based on meta key – Reduce three states to two in results?
  35. How to make Meta Query case sensitive?
  36. Get attachment by meta_key value
  37. Any number in meta key (wp query)
  38. Using meta_query with multiple keys and compare values
  39. Mysql query and order meta value
  40. How to display multiple custom fields with the same meta_key in an ascending order?
  41. Meta_query with multiple keys and multiple values
  42. Is it a good idea to improve meta query performance by adding tax query?
  43. meta_query BETWEEN, but the range is stored in the custom field
  44. Is it possible to set specific posts to show first in a query?
  45. Modify wp-query and sort by post meta key
  46. Orderby listing issue
  47. Order ascending is ignored in meta query?
  48. database query with more than a couple meta hangs and doesn’t complete
  49. Make meta query treat meta_value as 1 or 0
  50. WP Query Meta Value – How To Identify Specific, Unique Values?
  51. Order by meta_key doesn’t work
  52. Appending to existing WP_Query’s meta_query if exists
  53. Sort by presence of thumbnail
  54. it’s possible make a WP_Query with math operations?
  55. Multiple meta_key ordering with pre_get_posts
  56. Sorting search results with custom dropdown
  57. Error in meta_query not get result
  58. Meta query with compare by more than 2 fields
  59. How to get current page nearest parent id?
  60. WP_Query meta compare must include ALL array values
  61. meta_query returning excluded result
  62. What’s missing in this wp_query and meta_query
  63. meta_query weird behaviour, static int will work, but not user data
  64. Creating a query that get all posts but places meta items first
  65. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  66. get_posts query is taking about 40 seconds to execute
  67. wp query to use both author id and meta_query
  68. WP_Query for a taxonomy value OR a custom post type meta field
  69. Trouble with serialized metadata
  70. meta_query order by date present -> future then show null
  71. Meta query orderby meta_value_num sorting by role first
  72. Get posts having meta value between two numbers
  73. How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
  74. meta_query compare > not working
  75. meta_query is not allowing to show posts when querying multiple arguments in a WP_Query
  76. Speed up WP_query with meta comparing dates
  77. Meta Query if Values Don’t Exist
  78. Saving custom fields for WP_Query to retrieve
  79. How to show all the associated posts with specific date of data metabox?
  80. WP_Query returns empty if meta_query has more than 7 values
  81. Is it possible to search for a string in posts OR postmeta?
  82. Filter posts/pages by user_role array
  83. WP_Query with MetaQuery issue
  84. WP_Query Posts by Metadata from Option Tree
  85. Custom loop – Isolating post meta output depending on current query taxonomy terms
  86. Using orderby with 2 meta keys
  87. WP_Query with meta_value_num and meta_query not paged correctly
  88. Post Query not working after updating to 4.1
  89. Orderby Meta Value and Query from Meta Query
  90. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  91. Sort posts in dashboard using custom field; also include posts where field isn’t set
  92. Sort Posts with custom meta key by default which is currently set as optional
  93. Why is WP_Query’s meta_query not filtering results?
  94. WP_Query with several meta_query-statements and order by meta_value
  95. meta_query in wp_query not working as expected
  96. WordPress extremely slow when using get_posts with multiple meta_query relations
  97. How to get all post_id and meta_value using meta_key in wp_postmeta table
  98. WP Query – Show custom posts only if user contain some user meta
  99. How do I subquery with custom meta fields?
  100. Showing Counts on Comment List with Custom Query

Leave a Comment