How can I sort the results of a REST API response by the title of a connected custom post type?

You can’t, WP_Query can sort by post meta value, but it can’t then use that value as a post ID, look up that post, then sort by a value on that other post.

If you had a small number of posts, it could be done by manually sorting the results with PHP.

Fundamentally, the data is not stored in a way that makes this feasible.

Related Posts:

  1. Sort Order for a Custom Query in a Post Type Archive Not Working
  2. Select All in Parent Category, Group by Child Category?
  3. WP_Query -> sort results by relevance (= most tags / taxonomy terms in common)
  4. WP_Query post at custom position
  5. query order by date on custom type: wrong order
  6. Re-order posts in query after
  7. How to query different post types in specific order?
  8. is_main_query() not working for WP REST API
  9. Combining sorted and random CPT
  10. Previous/Next Link by Meta Value in CPT
  11. Wp_query: sort by PHP variable
  12. How to do WP_Query with two meta fields with orderby clause
  13. Order Custom Post Type by Custom Field Value
  14. Change sort order when using ‘orderby’ => ‘type’
  15. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  16. WP_Query of custom post type sorted by meta_key has unexpected results
  17. WP_Query not resetting after wp_reset_postdata
  18. Post ordering not working with custom field
  19. Displaying Portfolio Filter by Category Order (alphabetically)
  20. wp rest api orderby field in a custom table
  21. Display Parent-Child Posts in specific order by comparing IDs in array
  22. WP_Query: how to search tags in addition to a custom post type?
  23. Order posts alphabetically with numbers but some of the posts has numbers in the title
  24. SEARCH QUERIES – REVERSE OUTPUT
  25. Wp Query sort order from custom MetaBox
  26. WP Query with multiple post types ordered by custom meta date then published date
  27. Orderby modified only for specific post types
  28. Custom post order when using OR relation
  29. 404 on Pages for Custom Post Type & Query_Posts
  30. WP_query orderby not working after WP4.0 update [closed]
  31. Store custom post type with JSON content
  32. querying to custom field over ACF REST API
  33. Query order by meta value force specific tag first
  34. Order Wp Query by earliest of 3 dates meta query
  35. Query all posts where a meta key does not exist
  36. Syntax to get the Nth item in a list of custom post types?
  37. WP_Query to loop a Custom Field, Custom Post Types do not show
  38. Compare 3 custom fields and sort by oldest
  39. Using Query Posts With Multiple Post Types And A Taxonomy
  40. How to show posts from multiple post types in a single loop? And display them separately on the same template
  41. Custom Taxonomy List links being re-written
  42. Can’t sort order of wp_query with 2 meta keys
  43. Want to filter only parent post in admin area
  44. Get count of custom post type created by current user
  45. Query Custom Post by Category
  46. Quickest way to get last or oldest post date – WP Query
  47. Display posts if a custom field value is equal to another custom field value
  48. WP_Query and using a variable for ‘cat’=> in the args array = WP Bug?
  49. Custom post query by taxonomy
  50. CPT posts listed by category with custom rewrite URL, please help!
  51. Group custom posts by custom taxonomy names
  52. Using global $post; to get featured image for custom post via WP_Query
  53. Query custom post type by category slug
  54. Can’t query tag and post_type at the same time
  55. Wrong request query on cpt and tax
  56. Search / Filter posts on Title/Content OR Tags
  57. How to order separated Custom Post Search results
  58. Converting the_content string to an array?
  59. A method for ordering mixed dates in search result loop (theory only, no actual code)
  60. Display Woocommerce Orders for specific author [closed]
  61. Pagination with custom query, custom search form, single and pages, ajax and no plugins
  62. How can I group posts by months and years?
  63. Displaying a div from an assigned meta_value when on a page
  64. Creating two loops based on different logic
  65. $wpdb->get_col and ORDER BY?
  66. Getting a custom post’s custom field based on another custom post’s custom field select
  67. Custom post type loop with custom category filtering
  68. Show message when query has no posts
  69. How to show all taxonomies within custom post type loop
  70. Foreach loop returning more than one item when querying taxonomy
  71. how to compare different timestamps in wp-query for events custom post types?
  72. Is there a (preferable built-in) way to check what custom queries are used in a theme?
  73. Sorting the Loop by Taxonomy Value
  74. Previous / Next Links For Custom Post Type Sorted By Meta_Value
  75. Ordering by meta value not working
  76. Custom wp-query display post only today
  77. How to sort by multiple values in a nested WP_Query
  78. WP_Query to display number of custom post type filtered (order by) taxonomy
  79. 2 modal windows with ACF content on Archive page
  80. post_type incorrect for custom post type
  81. Live search by custom tag
  82. Custom Post Type – Display all, wrap in groups of 3
  83. How to get the posts that my following users are liked?
  84. Only show categories that have posts within custom post type
  85. How can you use a page for a custom post type?
  86. Display all Custom taxonomy terms and their relevant custom posts
  87. CPT Efficient way to display posts from different categories with custom query
  88. How To Loop Through list with Custom Post Types
  89. CPT or Custom Table for Repository of Serial Numbers
  90. Query Pulling the same post twice
  91. Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
  92. Custom Post Type + Category archive
  93. Values inside a custom field to determine which category posts to display
  94. Pop up showing same content on all posts display.
  95. Custom post-type’s pagination not working in category.php
  96. Listing all custom post types using a specific term on the said term’s template page, in groups
  97. Count of posts with meta_key filled in?
  98. Are custom posts included when getting a categories’ posts?
  99. Can I add a wordpress page using the slug for a CPT rewrite
  100. Query order by a numeric ACF field