WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’

Use a meta_query and set type to NUMERIC–

$query->set('meta_query', array(
    array(
       'key' => '_ai_price_int',
       'value' => array(0, 4000),
       'compare' => 'BETWEEN',
       'type' => 'NUMERIC'
    )
));
$query->set('meta_key', '_ai_price_int');
$query->set('orderby', 'meta_value_num');

Related Posts:

  1. Order resultset by configured value and then list all the rest
  2. Why does this incorrect pre_get_posts meta_query work for sort order?
  3. Admin products page column not sorting
  4. Using meta_query on pre_get_posts to exclude a particular meta_key value
  5. Meta query interfering with orderby relevance
  6. Multiple Values stored as array in Meta Query
  7. Order by nested named meta queries with ‘exists’ and ‘not exists’
  8. Help With issue on pre_get_posts filter in taxonomy
  9. Arrange Posts By Date In Order Of Closest To The Current Date
  10. Using get_terms() with meta_query parameters
  11. pre_get_posts order by not working
  12. Does meta_query working with value paramater higher then 999?
  13. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  14. Custom post type archive with rand and meta_value
  15. How to orderby multiple meta fields if some fields are empty
  16. Help ordering Post loop by two meta values
  17. Order ascending is ignored in meta query?
  18. pre_get_posts and set
  19. Orderby doesn’t work like expected on custom query
  20. last_name + first_name orderby with meta_query [solved]
  21. Can I use pre_get_posts to add up values from two different meta_keys?
  22. Fetch custom post related to a User
  23. How to Ordering by user meta
  24. meta_query Array
  25. Sort products by Sale price and stock status
  26. Querying terms with calculations based on term meta data, sql vs. get_terms
  27. meta_query check multiple date formats
  28. WordPress meta query not working
  29. Get meta_value from GDRating
  30. WordPress meta query with meta serialized data array value
  31. Reading Content in an Array as it relates to a meta_query
  32. How to output meta_key in wp_postmeta?
  33. Meta query array – same order as specified order in value
  34. How to order product for key exists?
  35. Meta query terribly slow
  36. meta_query sorting by 2 keys
  37. How to handle optional end date in compare clause in meta_query
  38. Best practice – Meta Query vs. post_clauses for “left join” ordering
  39. Different page parameters inside query
  40. Is there a way to do multiple ordering on a multiple meta_query?
  41. LIKE %…% Meta Query
  42. Order by custom field date with ASC order
  43. Documentation for post meta
  44. Ordering posts by anniversary using only day and month
  45. Sort custom post types by last name in the backend
  46. pre_get_posts filter using numeric meta_query comparison (from dates)
  47. How to use meta_query to check if a meta field has something set?
  48. pre_get_posts and search query for admin
  49. Using database meta_values to calculate new post order using pre_get_posts or a ‘request’ hook
  50. Display custom post types with custom date field value (before today) & order by custom date field
  51. How to make a WP REST API query with meta_query in WP4.7?
  52. pre_get_posts filter meta_query without conflicting existing meta_query
  53. Query posts only if meta_value is not empty
  54. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  55. Display post in order of ACF checkbox?
  56. How to pass user meta_key and meta_value (values as array)
  57. Query Multiple values for same key
  58. Meta query with a sub query group possible?
  59. meta_query compare=’!=’ with multiple custom fields
  60. Query posts with numeric meta values within a given range
  61. Query multiple meta values
  62. orderby meta_value breaks taxonomy term archives
  63. AJAX pagination offset returns same post on adjacent pages
  64. How do you get Posts by multiple meta_keys and meta_values with the Rest API V2?
  65. Meta_query on same meta key, with diffrenct values
  66. Query custom field with date
  67. Meta query with regular expression does not work
  68. Searching in title or meta, with a tax query too!
  69. Exclude posts from main loop based on meta value
  70. Why does pre_get_posts() return “date” as the orderby parameter for every sortable column?
  71. Pre Get Posts / Multiple Meta Keys / Orderby Single Key
  72. meta_query with multiple values optimization
  73. Get a single post ID based on an exact match of 1 or more meta values
  74. ORDER BY custom field value out of where clause
  75. Extend meta query arguments
  76. get_posts( $args ) return empty data
  77. WP_Query of custom post type sorted by meta_key has unexpected results
  78. how to search all user meta data that have value like “vivek”
  79. Sort posts using multiple custom fields and menu_order in single query?
  80. I can not display meta value in extras.php and template-tags.php
  81. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  82. Order (by ASC) posts with meta_key so posts without values are last
  83. Tax query get first product with attribute value in pre_get_posts
  84. Sort by DESC works, ASC doesn’t?
  85. meta_query is overriding default search
  86. WP_Query multiple value not working
  87. get_user can’t read variable
  88. WP_User_Query Orderby Not Working
  89. Pre get posts sort by meta key returns no results if meta key does not exist
  90. Meta_Query with multi select values
  91. Get Posts from Custom Meta Query
  92. Meta query broken since 4.7.4 Update
  93. Best way to Order Post in Home without a plugin
  94. How to fetch WP_User_Query with multiple role arguments [duplicate]
  95. How to get meta value based on latest post id with group by term name
  96. Want to order by Meta Values (tweaking Post Order Widget)
  97. Order posts by custom column using pre_get_posts
  98. Order Wp Query by earliest of 3 dates meta query
  99. How to use orderby on meta_value when using Pods custom database table storage
  100. acf/save_post affecting WP_Query results