Make a custom column sortable by a value from a different custom post type

(I was going to add this as a comment as it’s not a full answer, but I can’t yet…)

I think you will need to use an SQL query as the standard meta_queries / orderby won’t work. Have a look at Custom Table Column Sortable by Taxonomy Query and http://wpdreamer.com/2014/04/how-to-make-your-wordpress-admin-columns-sortable/#sorting-posts-option-b for a couple of examples.

Related Posts:

  1. How do I set the default admin sort order for a custom post type to a custom column?
  2. Make custom column sortable
  3. Using meta_query, how can i filter by a custom field and order by another one?
  4. Custom sortable columns ordered by meta-value?
  5. How to order adjacent posts (prev / next) by custom field value?
  6. Sorting a query by custom field date
  7. Custom Taxonomy Template Post List with Sort Order
  8. Column sorting with emtpy meta values
  9. manage posts custom column is not populating data from meta boxes
  10. How to sort a table of custom posts by column containing custom field
  11. Add custom column to custom post type overview in backend
  12. How to Sort Custom Field Admin Column by Date
  13. How to Sort by Date When Using d-m-Y Format
  14. Sort by two dates. Default entry date and custom field if present
  15. How do I sort a custom post type admin column using two meta keys?
  16. Sorting custom post type columns with external data and without meta values
  17. WP_Query order by custom field, then randomly order some of results
  18. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  19. Order a custom post type admin screen by a second custom post type title
  20. Sort custom post type by most current date picker
  21. Sorting custom post types in edit.php : Post disappear
  22. How can I sort the order of multiple custom field values in a custom post type?
  23. wp_set_object_terms creates taxonomies but does not add custom posts to it
  24. Sort custom post archives by a meta value from a different custom post type?
  25. sorting in wp query based on custom field value
  26. Custom Fields as Post Type Options
  27. Default custom column to off
  28. Make custom post type column sortable
  29. add comments custom fields after user is logged in
  30. Sort CPT by taxonomy AND THEN by custom field
  31. WP Query from two Custom Post type fields as statement
  32. How to Print Title and Permalink of CPT Post behalf of Posts Meta Value with WP_Query
  33. Using publish_{custom-post-type} hook for custom post type to update meta doesn’t work
  34. Best way to fix bad count on All | Mine | Published
  35. Alike Shortcode using in Custom Shortcode
  36. Sort custom posts by date and then by taxonomy
  37. Query custom post type that has a serialized relational advanced custom field value
  38. How To Read Read Custom Post Type Data in Headless CMS Mode
  39. Auto update publish date of CPT Post if default post custom field value match to cpt post CF Value
  40. Title and URL Error in Breadcrumb Navigation for Custom Post Types
  41. Filter custom post type admin list by custom meta column, where the column is another custom posts meta value
  42. Using OR relation in meta_query to check for a value before sorting by another
  43. How to upload an image to a custom post type
  44. WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
  45. Updating a custom post status after an expiry date rather than trashing it
  46. Add html tot CPT edit screen – no metabox
  47. WP_Query get always custom post_type for first
  48. Custom post type sortable columns when column value is from a custom database value
  49. Plugin Development using classes – Public & Private Callbacks
  50. Display Posts that fit a certain criteria on Category pages
  51. How to display custom field in product description?
  52. Sort custom post column by generated value?
  53. Custom Post Type action on post update
  54. Custom Column in CPT admin table not updated after Quick Edit save
  55. Show Post Types customized in Template Page
  56. In child theme, add CPT to custom taxonomy registered in parent theme
  57. How to only display all posts to a custom User Role?
  58. Store a value in global scope after init hook is fired
  59. Why this didn’t work if i use get_the_ID(), but works if i pass the numeric id
  60. Unable to gather Image URL from Custom Post Type’s; Custom Meta Field
  61. How to keep custom post type related information
  62. What is the correct way that when creating a custom post type assign values to custom fields created with pods framework?
  63. when looping through custom post data not appearing
  64. How to avoid duplicate posts queried from custom meta?
  65. Changing CPT permalink
  66. Custom Metabox Info Not Saving
  67. Add custom template ‘sub-page’ to Custom Post type?
  68. Custom sorting in post columns by ACF Pro Select Field
  69. How can I query and sort custom-post type using WP_Query
  70. Update main post with same category when creating custom post to update the modified date
  71. Meta query and compare “!=” not working as expected
  72. custom post types, custom fields and normalization
  73. Display Custom Field or Custom Taxonomy in front page /post/product
  74. How can I create a button that when clicked populates a div with a list of foods that are checked as a certain type of ACF?
  75. Orderby if between two meta fields
  76. How to add dynamic fields on wordpress custom post type page in admin section
  77. Dynamic page for nav items used as filters
  78. Sort custom post type by custom datepicker instead of filtering
  79. How to access repeater field of a custom field?
  80. Filter posts by their related field’s custom field
  81. Post Click Redirect to Custom URL instead of Single Post Page
  82. How to sort by multiple values in a nested WP_Query
  83. wp_insert_post deleting previous post custom meta
  84. How can I add a meta[] to my custom post type and search by term with the Rest API?
  85. Show posts from WP Custom Post Type selected from a field in a metabox
  86. Custom post type order by post_title
  87. Problem in moving cpt’s from local website to live website
  88. How to sort post category using its Description
  89. How can I fetch all the dates from custom fields from various different custom post types and show / list them at one place in ascending order?
  90. register_rest_field update_callback don’t work for $_FILES
  91. Query custom post type and custom field by URL parameters
  92. Creating an archive page or simple template to list all values of a custom field of specific post type listing
  93. Where is get_post_meta value located?
  94. Hook create / update post
  95. How to convert Post Object Custom Field into Tags
  96. How do I query with multiple custom fields orderby in same column?
  97. PHP Warning with Custom Fields
  98. Custom meta fields not showing up in WP_Response Object via custom endpoint
  99. Query a Custom Post Type using SELECT that has ACF fields to compare dates
  100. I want to create a metabox under custom taxonomy
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)