[Resolved] Sorting view by date stored in child post

[Author]

Posts

[Greig Neilson]

I have a parent post type called Vehicles and a child post called SOS test.

I want to display a table with sortable columns, using a date field within the child post to sort ASC.

Each parent will have multiple SOS tests, but I am only interested in the date of the most recent test.

My 'parent view' looks fine - I am seeing the most recent SOS test. The problem is that I can't sort by that column.

How can I achieve this?

[Luo Yang]

Hello,

There isn't such a built-in feature within Views, Views is using WP_Query to query posts, see WordPress document:
https://developer.wordpress.org/reference/classes/wp_query/#order-orderby-parameters
‘meta_value‘ – Note that a ‘meta_key=keyname‘ must also be present in the query.

Since you are querying Vehicles posts, so you can only order by fields of Vehicles post type, can not order by fields of other post type "SOS test".

You might consider these:
Create a post view:
- Query "SOS test" posts
- Order results by the date field
- Display it's parent Vehicles post information
https://toolset.com/documentation/post-relationships/how-to-display-related-posts-with-toolset/#displaying-one-related-item-parent