Custom post type sortable columns when column value is from a custom database value

You can sort the results based on your custom table data by applying a custom filter to your existing query using the “posts_orderby” hook (untested example code):

add_filter('posts_orderby', 'edit_posts_orderby');

function edit_posts_orderby($orderby_statement) {
    $orderby_statement = "views DESC";
    return $orderby_statement;
}

Source: based on user comment at:
https://developer.wordpress.org/reference/hooks/posts_orderby/

Related Posts:

  1. Can the Next/Prev Post links be ordered by menu order or by a meta key?
  2. How do I set the default admin sort order for a custom post type to a custom column?
  3. Make custom column sortable
  4. Using meta_query, how can i filter by a custom field and order by another one?
  5. group search results by post type?
  6. register_post_type sort order by title by default
  7. Drag n Drop Post Order for multiple Custom Post Types
  8. Sort custom post type list table by display name of a user id stored as post meta value
  9. Custom sortable columns ordered by meta-value?
  10. How to order adjacent posts (prev / next) by custom field value?
  11. WordPress post sorting with AJAX
  12. Ordering posts by custom taxonomy in admin area
  13. Custom Post Type, WP_Query and ‘orderby’
  14. Filter admin columns by custom post field value
  15. Sorting a query by custom field date
  16. Custom Taxonomy Template Post List with Sort Order
  17. Ordering Posts List By Taxonomy Terms?
  18. Column sorting with emtpy meta values
  19. Number of pages – multiple (custom) post types
  20. WP_Query -> sort results by relevance (= most tags / taxonomy terms in common)
  21. how to sort post in admin column by recently
  22. Custom Post type sort order not working in the admin area
  23. How to sort a table of custom posts by column containing custom field
  24. Alphabetical sorting of custom post type – one letter per page
  25. sort events based on event date custom field
  26. How to Sort Custom Field Admin Column by Date
  27. How to Sort by Date When Using d-m-Y Format
  28. Sort Posts Best Practice
  29. Custom Post Type sorted by Title
  30. How to add new tab to admin list of posts and handle result list
  31. Sort by two dates. Default entry date and custom field if present
  32. How do I sort a custom post type admin column using two meta keys?
  33. Custom-post-type-archive: posts sorted/filtered by year?
  34. How to make in WordPress admin panel sortable column for the custom field, that count the number of page impressions?
  35. query_posts with a custom post type, a meta_query and sorting by post date?
  36. sort order for a custom post-type [closed]
  37. Sort admin area by custom Event Date field
  38. Custom post type ‘orderby’ => ‘meta_value’ not working
  39. How to rank custom post type from score points
  40. Sorting multiple custom post types without a meta key/value pair by sort order
  41. Order By Post Type ThenBy Taxonomy
  42. Combining sorted and random CPT
  43. Sorting custom post type columns with external data and without meta values
  44. Default sort on admin columns with meta date hides draft posts with empty date value
  45. Categories sorting
  46. Wp_query: sort by PHP variable
  47. Crafting WP_Query array, sort by date
  48. WP_Query order by custom field, then randomly order some of results
  49. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  50. Custom post type, organized by categories
  51. WooCommerce sort products by the actual product width(not the shipping width)
  52. Sort and filter custom post type posts by custom taxonomy
  53. WordPress posts page for customer filtering and sorting along with category filter
  54. manage_edit-{post_type}_sortable_columns sorts, but wrong!
  55. Sort entries by date mixing two post types
  56. Order a custom post type admin screen by a second custom post type title
  57. How to sort posts in a custom post type by title in ascending order by default?
  58. sort post types by amount of views
  59. Custom post type sorting: alphabetical order
  60. Sort a custom post with ACF: Date Picker & Display Featured!
  61. Sortable column containing numeric values for Custom Post Type at WordPress Backend
  62. Custom Post Type page sorts differently on different environments
  63. Sort custom post type by most current date picker
  64. Creating a “glossary” of WordPress posts of a specific post type
  65. Sort results without WP_QUERY?
  66. Make a custom column sortable by a value from a different custom post type
  67. sort by name (slug) custom post type
  68. Sort column on meta key and meta value
  69. Sorting custom post types in edit.php : Post disappear
  70. Custom loop request based on custom field
  71. What’s an easy way of sorting custom post types manually?
  72. How can I sort the order of multiple custom field values in a custom post type?
  73. Sorting the Loop by Taxonomy Value
  74. How to order query results based on if a custom field has been populated, then the order by the date of the post?
  75. Sort custom posts by date and then by taxonomy
  76. Sort custom post type by custom datepicker instead of filtering
  77. How to sort by multiple values in a nested WP_Query
  78. Custom post type order by post_title
  79. How to sort post category using its Description
  80. How to use multiple orderby conditions on query search results? (orderby one post type, relevance)
  81. Wp Query sort order from custom MetaBox
  82. Using Orderby and meta_value to order natural/alphanumerical
  83. sorting in wp query based on custom field value
  84. week days sorting based on starting day
  85. How to sort custom post’s category by id from the theme’s function.php?
  86. Group/list/sort custom post type posts by date in tabs from acf datepicker field
  87. Grouping and paging CPT events by month with custom field date
  88. Ordering Posts List By Taxonomy Terms?
  89. Custom post type taxonomy not sorting correctly
  90. How do I sort post listing by child post count?
  91. Make custom post type column sortable
  92. sort custom post type by display name
  93. How can I sort posts ascending by post title for a specific post type, but on a category archive template?
  94. Test if a Category contains certain Custom Post Types
  95. Sort CPT by taxonomy AND THEN by custom field
  96. Custom order of CPT posts by title, in wp-admin area by default
  97. Sorting by Title for Post Archive Categories for Custom Post Type
  98. Submit post and upload image from front-end
  99. Using Custom Fields in Custom Post Type URL
  100. Why is the »_builtin« parameter not advised in »register_post_type()« for custom post types?
tech