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 multiple post types – Order by type and post title title
  36. Show custom post type filtered by category
  37. Randomize Posts. Skip the first post in ascending order
  38. Creating a navigation menu of all posts of a custom post type and their children posts?
  39. Get custom taxonomies from multiple posts
  40. Pagination for Custom Taxonomy Page [duplicate]
  41. Filtering WP_Query
  42. Search / Filter posts on Title/Content OR Tags
  43. Pagination on with query_posts in custom post type template
  44. How to order separated Custom Post Search results
  45. WP_Query most viewed posts, in multiple Post Types, last 30 days, excluding a specific taxonomy term
  46. Allow user to set custom order to a list of custom taxonomies?
  47. Custom-Posttype & Custom Taxonomy WP_Query
  48. Crafting WP_Query array, sort by date
  49. Custom loop with multiple taxonomy queries
  50. Return one unique custom post type result when it shares a custom taxonomy in WP_QUERY?
  51. Converting the_content string to an array?
  52. forming WP_Query for posts of all post types but from specific categories
  53. Get latest 3 posts from multiple CPT in one query
  54. Loop to fetch 3 post_thumbnail instances from 3 most recent custom post types named “portfolio”
  55. Display upcoming Events for next 7 Days
  56. Cannot add custom field to “orderby” parameter in Rest API
  57. Isotope Filtering with Bootstrap Tabs – Custom Post Type Query Loop in each Tab (Have to click twice to filter)
  58. Custom post ui plugin & WP_Query – Polylang
  59. How can I get the number of custom post type posts that have a specific attachment image set?
  60. How to use load more custom post type data normal or according to on click category tab In WP
  61. orderby rand is not working for a custom post types
  62. Sort CPT archive by order prevents sorting in admin
  63. Getting meta in editor plugin, and event triggering issue
  64. Problem querying Custom post type by custom fields
  65. Orderby CPT custom fields not working
  66. Custom taxonomy rewrite give pagination 404
  67. WP_Query order by custom field, then randomly order some of results
  68. WP_Query inside foreach loop returning same value for all options when filtered using ajax
  69. Mixing 2 custom post types with posts output in specific pattern
  70. Custom post taxonomies as tax_query terms?
  71. Expose a custom field of a custom post type to the REST API
  72. How to create custom post by using REST API securely?
  73. Custom post type archive page – Posts overview – with one modal for multiple posts?
  74. creat filter with wp_query
  75. Troubles with acf/save_post and WP_Query
  76. A method for ordering mixed dates in search result loop (theory only, no actual code)
  77. Query custom post type with ACF Date
  78. Stuck in Order by more then one
  79. Display featured image from one CPT within another CPT query
  80. Custom WP Query on custom meta and sort by multiple meta keys value
  81. Show only one post on custom post type archive
  82. WP Rest API – How to get an empty response if query has no posts
  83. Woocommerce search pagination not working
  84. Callback to custom field is not working in WordPress REST API
  85. How to order WP_Query by parent for hierarchical Custom Post Type?
  86. Including metaboxes from custom post types in global search — continued
  87. Custom Post Type not showing in Rest API on Multisite
  88. WordPress loop: Show only a Custom Post Type Taxononmy TERM
  89. post meta parameter in post custom-post-type endpoint with restapi
  90. How can I made custom taxonomies relationship?
  91. Query Multiple Custom Posts by Custom Fields
  92. What’s the WP way to load remaining custom posts?
  93. Why is this query not working? (Standard posts + custom post type)
  94. How do you paginate a query grouped by month?
  95. Exclude objects from WordPress API based from ACF field using rest_prepare_{$post_type}
  96. Custom taxonomies relationship
  97. filter custom post in rest api with custom function
  98. Get Posts by multiple custom fields is not working
  99. Custom post type ‘articles’ ignores posts_per_page, reserved post_type?
  100. Several post types on WP Query by tag and taxonomy
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)