Multiple custom fields for ‘orderby’ in ‘WP_Query’

meta_query and orderby are seperate parameters, you just put them together in an array. You will have to do one then the other.

e.g.

<?php
$args = array(
    'post_type'     => 'property',
    'meta_query'    => array(
        array(
            'relation' => 'AND',
            'city_clause' => array(
                'key'       => 'city',
                'compare'   => 'EXISTS',
            ),
            'street_clause' => array(
                'key'       => 'street_name',
                'compare'   => 'EXISTS',
            ),
        )
    )
    'orderby' => array(
        'city_clause'       => 'desc',
        'street_clause'     => 'desc',
    )
)
?>

https://developer.wordpress.org/reference/classes/wp_query/#order-orderby-parameters

Related Posts:

  1. Posts with at least 3 tags of a list of tags
  2. Get post count of current loop when using multiple queries on one page
  3. Display products from specific category in shop page
  4. Hook/action after WP_Query gets posts to query custom tables for post-related meta
  5. WP_Query to show post from a category OR custom field
  6. Is it possible to select against a post’s parent’s fields with WP_Query?
  7. Get posts by meta data OR title
  8. Display Posts by modifying the where clause only for my query
  9. page was loaded over HTTPS, but requested an insecure image
  10. WP_Query: How do I sort on meta value and use LEFT JOIN?
  11. Pagination causes error 404 when used with front-page.php
  12. How to pass custom parameter to WP_Query for filtering in pre_get_posts
  13. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  14. How to search by title or tags exclusively?
  15. Paginated pages are showing correct content but pagination links are not
  16. Query Posts but only return 1 from a custom taxonomy?
  17. Using AJAX to return search form results
  18. Add custom search results to main WP search [duplicate]
  19. What is the difference between RELATION “AND” and “OR” in TAX_QUERY?
  20. Finding post content that begins with a specific character
  21. Query Set Order By Author
  22. ‘&’ causes an error in my shortcode when I list the content of the page
  23. wp_query, give first post different formatting
  24. SQL Query inside Widget
  25. meta_query works locally but not on live server
  26. getting posts and number by specific meta value in multiple meta
  27. Use ‘parse_query’ filter to show posts that from multiple criteria
  28. How can I pick a single post from the latest 3?
  29. Retrieving list of a custom post type in a widget without using WP_Query?
  30. Get posts for last working week in WP_Query
  31. How to orderby meta_value_num with dollar ($) sign
  32. how to link to detail page(single.php?) in a wp_loop
  33. WP_User_Query unable to retreive all user at once
  34. Order WP_Query by multiple fields, subtracting them from one another
  35. Meta Query Array Error 500
  36. getting post thumbnail within loop causes an error
  37. Reset postdata to custom query in nested queries
  38. Complex WP SQL Query
  39. Hide Administrators From User List except current user (administrator)
  40. Custom Query num_rows returns wrong amount
  41. How to figure out redirection and contents in hybrid solution containing word press content and legacy code (ASP.net)
  42. Category applied to pages, creates multiple breadcrumb entries after a search query (On the translated site)
  43. Most commented post showing 2 records
  44. How to store and receive variables in WP sessions?
  45. Add posts to WP Query object
  46. How to list posts with disabled/closed comments, with pagination?
  47. Category ‘pad_counts’ & ‘parent’ conflict
  48. WP User Query with Custom Fields and Search Results
  49. Order or Orderby in tax_query (How to define order of terms in WP_Query)
  50. Event with multiple dates, display events chronologically
  51. How to exclude Sticky from Recent Post?
  52. Display if author page is author page of current user
  53. Create a loop on my pages with new “WP_Query”
  54. WP_Query order by not working properly due to category I believe
  55. get_query_var always returns the default value
  56. WP ForLoop to compare meta information of posts to determine what post to display
  57. Modify WP_Query using pre_get_posts but only for frontend query?
  58. Multiple wp_query on archive page
  59. WP_Query to get post on frontpage
  60. When listing child pages run out of memory
  61. Function to retrieve IDs of posts, cache results, and improve wp_query
  62. parse_tax_query causing Navigation Menu To Disappear
  63. WP_query is not returning the expected result
  64. the_post_thumbnail do 2 queries. How to optimize
  65. wp query meta value is not null
  66. Trying to use WP_Query to display a custom post type
  67. Search.php – return number of results but cannot loop through
  68. Creating ‘posts page’ loop based on the page itself
  69. How to get pages of parent (non-recursive)?
  70. WP_Query and pagination AGAIN?
  71. Can’t get term id for category archive
  72. Combine query in WP_User_Query()
  73. Nearby locations using Advanced custom fields, maps?
  74. How to display the category dropdown auto search list when key press?
  75. order by post date and modified date posts both in wpquery
  76. How to get_comments() ordered by date and parent?
  77. WPQuery loop not giving expected output
  78. WP Query filters active on wrong query
  79. Not able to fetch woocommerce variation sales products for particular category products
  80. Global page ID variable empty error
  81. WordPress tax_query ignoring relation OR
  82. pagination functions are not working
  83. Gather same custom field values in one value in a select tag with wp_query
  84. Continue loop after $queryObject
  85. Order Posts By Youtube Views
  86. WP Query with sticky posts and tax_query
  87. Declare inline background image in functions.php
  88. WP_Query for attachments without duplicating post_parent and displaying tagged image
  89. Looking for a way to exclude frontpage and nav menu from query filter
  90. Using Query In Post Type Archives
  91. Query posts by custom fields
  92. Showing posts from 4 categories along with all latest posts
  93. Searching in specific custom post type
  94. WP Query Obj: Set value to be unequal | Hide media by admin
  95. WordPress pagination returns the same posts
  96. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  97. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  98. Get posts using multiple values from ACF checkbox as meta query wordpress
  99. How to save the results of a query as a php file for an autocomplete search bar
  100. Why ignore_sticky_posts argument is in sticky post query?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)