Sort by custom field that is an array?

At the stage of retrieving posts from database this is impossible (or at least impractical), since arrays are stored serialized by PHP in meta table and SQL won’t be able to process them on the fly effectively.

This is easy enough to do for specific set of posts retrieved, just sort results in $mostsharedposts->posts before output. But that won’t give you sane continuous pagination in that order.

In a nutshell if you want this in reliable non–hacky way, you will likely want to break out copy of that value in array into separate meta field.

Related Posts:

  1. How to only display posts whose meta_value field is not empty?
  2. Can wp_query return posts meta in a single request?
  3. order by numeric value for meta value
  4. How do I query for posts by partial meta key?
  5. WordPress retrieving meta data for all custom post types in list view
  6. Order by optional meta key?
  7. meta_query: using BETWEEN with floats and/or casting to DECIMAL
  8. Reduce or prevent calling of update_meta_cache
  9. What is the most efficient way of querying posts based on visits and date for current day?
  10. WP_Query displaying ALL posts
  11. Query Custom Meta Value with Increment
  12. WP-CLI How to generate a list of posts with corresponding meta values
  13. What is an efficient way to query based on post_meta?
  14. How to count post meta key values for all posts in database
  15. How should I use posts_where to change meta_value from a string to integer?
  16. How can I create a WP_Query that returns posts where one meta_value
  17. WordPress altering my custom query, How to fix it?
  18. WP Meta Query for some meta (array) values
  19. WP Query post meta value
  20. Would this post meta be better added to the post table rather than post_meta table
  21. query posts in functions.php and update a field
  22. How to get sum of meta_values of a meta_key in wp_query according to conditions
  23. how to fire join query with post_meta
  24. Best approach to create Hot and Trending sections
  25. WP_Query, custom sort and custom filter
  26. Order posts by meta value and Date
  27. How to make orderby ‘meta_value_num’ OPTIONAL?
  28. Query Posts depends on custom field inside repeater field using acf
  29. Minimising Database Queries when using Advanced Custom Fields
  30. Get meta info related to current post
  31. Select from wp_post and multiple meta_value from wp_postmeta
  32. Pull post meta with post_query?
  33. Group WP_Query by meta_key date
  34. WP_query posts closest to todays date
  35. exclude posts with a specific custom field and value
  36. Inserting serialized value into wp_postmeta using update_post_meta
  37. How to make Meta Query case sensitive?
  38. Performance when getting post meta for post retrieved by meta value
  39. Get attachment by meta_key value
  40. Display custom field meta outside loop, site wide
  41. Using hook to use DISTINCT in a wp_query
  42. Where to put meta Keys
  43. how to make members list directory through wordpress post custom meta key.
  44. How do I query for posts by partial meta key?
  45. Large AND OR query timing out
  46. get_post_meta slowing down my page load (in a plugin)
  47. New WP_Query loop in admin causes problems
  48. echo a specific meta_key queried through a custom post
  49. How to increase load time of an archive/search page (WP_Query)
  50. get_post_meta in WP_Query
  51. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  52. Hide posts with meta key in WP_Query
  53. Filter posts by comparing custom meta value against postdate
  54. WordPress query posts with multiple post_meta data
  55. WP_Query – Accessing MetaValue from Query Result
  56. search serialised meta_value for date value?
  57. How do I check if an article is popular this week?
  58. Woocommerce: order posts by meta key
  59. Order WP_Query results by meta key value in custom query
  60. How can I update post meta inside a WP_Query loop or the WordPress loop?
  61. Nested array issue in meta_query
  62. Display post meta conditionally based on it’s value
  63. Filtering by multiple conditions in the loop
  64. Orderby two meta fields not working
  65. Query posts by searching for a string in a meta field
  66. WP_Query meta compare must include ALL array values
  67. How do i create a custom post query when the meta value is an array?
  68. wp query to use both author id and meta_query
  69. Sort by price wpdb
  70. Trouble with serialized metadata
  71. show most viewed post
  72. Display posts from multiple value in meta separated by comma
  73. Custom filter from post meta
  74. Why can my filter query SOME metadata but not other metadata?
  75. update_post_meta performance in a loop woocommerce
  76. update_post_meta performance in a loop woocommerce
  77. How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
  78. I need query_posts() to order results first by a meta value and then by post ID
  79. Look for string in posts and postmeta
  80. Query postmeta based on meta_value, return array of post_id
  81. I can’t get post based on its postmeta value and key
  82. Saving custom fields for WP_Query to retrieve
  83. Meta key in wp_query bug?
  84. How to show all the associated posts with specific date of data metabox?
  85. WP Meta Query at depth 2
  86. WP_Query with child element
  87. WP_Query Posts by Metadata from Option Tree
  88. Sorting Posts with meta value not working
  89. How to get several fields from wp_query?
  90. WP Query to order posts by multiple meta fields
  91. Return a single custom post from multiple meta queries
  92. Custom Search Query – include only custom fields and title
  93. How to count post meta key values for all posts in database
  94. loop through custom post types with meta data
  95. query by meta value then date and not empty meta value
  96. wordpress sorting using array merge by price in ascending order but price with 0 must be show last
  97. Query posts by meta value and sort by another meta key
  98. WP_Query by meta key not returning any posts
  99. Extend search query to search meta keys values based on search string
  100. How to get posts that have certain meta key value and order based on another meta key’s value
techhipbettruvabetnorabahisbahis forumutaraftarium24eduedueduedusedusedueduseduseduedus