Order by meta_value_num DESC and meta_value ASC on WP 4.0

Although the new orderby parameter is great in WP_Query, it does not support multiple orderby for multiple meta_key‘s.

I’ve went through a couple of scenarios and even went and digged into trac and make and came up with the following

None of the issues regarding this very problem have been answered. It also seems from those two links that there is an issue ordering by a meta_key and another field like post date for instance. I haven’t tried this as yet.

I truelly think that you have two choices here without creating two queries.

  • hack using the posts_orderby filter as described by @s_ha_dum in his answer here

  • By making use of PHP ordering using usort. The idea here would be to sort your query by one meta_key and then take the returned posts array ($posts) and sort them by the second meta_key before the loop starts. You can either use the the_posts filter (just remember to remove the filter once done) or simply unset $posts in your template and set it with the reordered array of posts once done

Related Posts:

  1. Meta query with string starting like pattern
  2. compare meta_query in get_posts arguments
  3. Getting attachments by meta value
  4. querying with custom meta field with meta_query
  5. WordPress altering my custom query, How to fix it?
  6. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  7. Order by meta_key in custom post type doesn’t affect the query
  8. meta_key and meta_value not working together
  9. Order Posts by meta value AND published date
  10. How to make Meta Query case sensitive?
  11. Fetch Record based on meta key dates
  12. Meta_query with multiple keys and multiple values
  13. meta_query BETWEEN, but the range is stored in the custom field
  14. Extend product search with meta in WooCommerce
  15. how to make members list directory through wordpress post custom meta key.
  16. Large AND OR query timing out
  17. meta_value_num not ordering all items
  18. meta_compare not comparing whole integer
  19. Display posts with specific value first in query
  20. Get every post with value in meta key
  21. add_query_arg to compare and display events from a certain date
  22. Comparing 2 Decimal Numbers from custom fields and displaying posts
  23. meta_query weird behaviour, static int will work, but not user data
  24. Query multiple post types, but different order for each
  25. Order by the first array within a meta_query
  26. Query ACF relationship field – Comparator IN – Value array
  27. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  28. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  29. How do i create a custom post query when the meta value is an array?
  30. WP Query – grouping posts by same meta key, adding together values from another key
  31. meta_query is overriding default search
  32. Trouble with serialized metadata
  33. Comparing Meta Field date in WPQuery using Meta_Query?
  34. Getting posts by custom field value
  35. Query against multiple locations within single custom post type post
  36. WP_Query, ACF field and array
  37. Order by Date Custom Field
  38. Query by meta value (add a dropdown of all values)
  39. Order Posts By Custom Field That is an array of objects
  40. Custom WP_query and integrating into theme file
  41. Using custom field as ‘orderby’ value causing post grouping by publish date
  42. Compare meta key separation
  43. query post based on comparison
  44. Get posts by meta value except one post [closed]
  45. How to get products with the same custom attribute like ean code
  46. Meta_query compare operator explanation
  47. meta_query ‘compare’ => ‘IN’ not working
  48. Sorting: custom query with orderby meta_value_num THEN by title
  49. WP_Query with checkbox meta_query
  50. Meta Query with date and time on the same Day before given time
  51. How to grab metabox value in wp_query meta_query key
  52. Is “orderby” in WP Meta Query conflicting with Meta Query?
  53. Query two post types and order by two different date fields
  54. WP Meta Query for some meta (array) values
  55. Sort users by meta_value_num
  56. meta_query with array as value
  57. Using WP Query to search within ALL keys in meta query
  58. WP Query – Get WooCommerce Products with variation that is in stock
  59. Meta_query with or without value
  60. How can i make WP_Query return post image and categories?
  61. wp_query not searching with apostrophe
  62. Custom query based on meta key – Reduce three states to two in results?
  63. Add quicklink to in the Admin posts page where I can query by a meta_key
  64. Performance when getting post meta for post retrieved by meta value
  65. How to display multiple custom fields with the same meta_key in an ascending order?
  66. Order by empty custom field
  67. Tax query AND/OR meta query [duplicate]
  68. Help ordering Post loop by two meta values
  69. database query with more than a couple meta hangs and doesn’t complete
  70. Search posts missing a particular custom field
  71. Conditional operator OR not working with custom fields
  72. Sort by presence of thumbnail
  73. it’s possible make a WP_Query with math operations?
  74. Sorting search results with custom dropdown
  75. Posts query according to meta box date
  76. create metabox to activate slider
  77. Query only displays one page_id
  78. Display post meta conditionally based on it’s value
  79. What’s missing in this wp_query and meta_query
  80. How to use the Term Object from a custom select field in a query
  81. meta_query order by date present -> future then show null
  82. Problem with my loops
  83. Sort posts on custom field AND after that sort on date?
  84. meta_query compare > not working
  85. Saving custom fields for WP_Query to retrieve
  86. Filter posts/pages by user_role array
  87. WP_Query with MetaQuery issue
  88. Custom loop – Isolating post meta output depending on current query taxonomy terms
  89. WP_Query with meta_value_num and meta_query not paged correctly
  90. Post Query not working after updating to 4.1
  91. How do I display posts with specific value in a custom field into my loop?
  92. Orderby Meta Value and Query from Meta Query
  93. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  94. Sort posts in dashboard using custom field; also include posts where field isn’t set
  95. Sort Posts with custom meta key by default which is currently set as optional
  96. WP_Query with several meta_query-statements and order by meta_value
  97. Querying meta values within an array
  98. How do I have multiple metaqueries inside one wordpress query
  99. Display only posts with thumbnails
  100. How to use meta_query to retrieve posts from multiple custom post type

Leave a Comment