How to alter query order direction using $query->set(‘order’, ‘ASC’); inside a pre_get_posts filter?

Yes, I got it:

function custom_search_orderby($orderby) {

    global $wpdb;

    if  ( is_search() ) {

        if ( isset($_GET['order']) ) {

            if ( $_GET['order'] == 'DESC' ) {

                $orderby = $wpdb->prefix . "posts.post_date DESC";

            } else {

                $orderby = $wpdb->prefix . "posts.post_date ASC";

            }

        }

    }

    return $orderby;

}

add_filter('posts_orderby', 'custom_search_orderby', 999);

Related Posts:

  1. Sort on meta value but include posts that don’t have one
  2. multiple orderby in pre_get_posts action
  3. Use pre_get_posts to sort meta_key by an array of values
  4. Why does pre_get_posts() return “date” as the orderby parameter for every sortable column?
  5. Check post_date in pre_get_posts
  6. pre_get_posts shows posts in random order sometimes
  7. Sort by DESC works, ASC doesn’t?
  8. Sort posts by meta value with get method
  9. How to order posts by parents?
  10. Using Orderby and meta_value_num to order numbers first then strings
  11. WP_Query orderby post__in remains ineffective in the Loop [closed]
  12. How to Change Order of Posts in Admin?
  13. get_the_terms in descending alphabetical order
  14. next and previous post link ordered alphabetically
  15. Order posts by meta_value even if meta_key is not filled
  16. Order by first name
  17. Meta query interfering with orderby relevance
  18. Order posts by (hierarchical custom) taxonomy terms and term children
  19. the_tags() : display the tags by the order they are typed in in the backend, not alphabetically
  20. Sort custom post types by last name in the backend
  21. Sorting Attributes order when using get_the_terms
  22. Filter query posts by the count of metas for a meta key
  23. How to order posts by meta value?
  24. How Do I Order Posts by Modified Date? [duplicate]
  25. Orderby Post Views
  26. How to order posts (woocommerce products) alphabetically but ignore certain words, eg ‘The’ and ‘An’
  27. How to order posts by alphabet with numbers at the end
  28. Best Plugin to Reorder Post Types
  29. Ordering system through WordPress
  30. pre_get_posts order by not working
  31. Issue with multiple orderby values
  32. get_query_var returns wrong default value
  33. orderby meta_value breaks taxonomy term archives
  34. Show first the posts from 1 specific tag
  35. Order posts by price
  36. All, published and pending order
  37. get_adjacent_post() returning weird results
  38. Get_Users Orderby Page
  39. Sort order of next/prev sibling page
  40. Help ordering Post loop by two meta values
  41. Order ascending is ignored in meta query?
  42. Order char by post title
  43. next_post_link and previous_post_link order not working properly
  44. query pages by a childs publish date
  45. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  46. List most recently added posts (with a twist)
  47. WP Query – order posts by meta field first and then order the rest
  48. Featured-Content/Featured Posts With Random Order
  49. Orderby in Query Posts affected by operating system?
  50. Ordering posts by title containing numbers
  51. Stylesheet Enqueue Order and Best Practices
  52. wp_list_pages sort order by top nav menu order and child of
  53. How to display taxonomy terms the way they are hierarchical
  54. wp_list_categories() by alphabet? (ex. only category titles that start with “A”) [closed]
  55. Child pages not affected by orderby
  56. Order by ASC, DESC, Title, Date from URL on custom page template post
  57. Offset posts with random order
  58. view subcategories order by id
  59. Sort query output on taxonomy term archive by post type using pre_get_posts
  60. ASC and DESC separately from orderby
  61. Order WP_Query by The Order of an Array in Tax_Query
  62. struggling to order by title
  63. Order by two meta values – one is a number and the other is text
  64. Order posts by taxonomy terms
  65. Last post sorting get_categories
  66. Order resultset by configured value and then list all the rest
  67. Order column custom date using pre_get_posts
  68. Shop sends Mail with order cancellation
  69. List of terms in alphabetical order under the respective initial letter and within columns
  70. update_post_meta saves data but does not show in Order backend
  71. Random order not working correctly when using default loop + $query->set
  72. Changing cache update rate
  73. how to complete order status automatically after paypal payment received
  74. Order management including recurring orders on woocommerce
  75. Orderby Title not working
  76. Why does this incorrect pre_get_posts meta_query work for sort order?
  77. Sort loop by title doesn’t sort single digits like human would
  78. What’s the most efficient way to get two queries based on an if statement?
  79. How to order custom user list columns by datetime?
  80. Creating a post that contains a list of other posts like a table of contents
  81. Want to order by Meta Values (tweaking Post Order Widget)
  82. Order posts by custom column using pre_get_posts
  83. Changing posts order on a page
  84. Re-order posts inside tax query
  85. Pre_Get_Posts order DESC not registering
  86. Ordering Subcategories
  87. single post navigation order (NOT chronological)
  88. Problem with meta_value order after update
  89. Random order of posts on each request
  90. How can I make have_posts() return posts ordered DESC by id?
  91. Add post order like page order
  92. Woocommerce Pre Orders view order link wrong [closed]
  93. How to make WordPress orderby work with post_excerpt column?
  94. Orderby with menu_order and title
  95. Sort wordpress posts by facebook likes [closed]
  96. How to use orderby on meta_value when using Pods custom database table storage
  97. Sorting by date not working?
  98. How to put posts with some taxonomy on top of others in `pre_get_posts`
  99. WP_Query – How to get all posts of specific days of week by custom field date?
  100. Order get_terms by multiple meta_values

Leave a Comment

error code: 523