This thread is resolved. Here is a description of the problem and solution.
Problem:
I have a many-to-many relationship setup on my site.
Faculty (parent) --> Research Projects (Child) <--- Portfolio (Parent)
What I need this view to do is show me Faculty that share a child Research Project with the Portfolio item. It does this! BUT I need to to display alphabetically by post title of the Faculty post, not the Research Project.
Solution:
There isn't such a built-in feature within Views plugin, Views is using WordPress class WP_Query to query posts, your view is querying the posts of child post type "Research Projects", it can only order the results by fields of child post type "Research Projects", it is not possible to order the results by it's parent "Faculty" posts.
Relevant Documentation:
https://codex.wordpress.org/Class_Reference/WP_Query#Order_.26_Orderby_Parameters
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| - | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | - |
| - | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | - |
Supporter timezone: Asia/Hong_Kong (GMT+08:00)
This topic contains 2 replies, has 2 voices.
Last updated by TJS3586 6 years, 6 months ago.
Assisted by: Luo Yang.
I have a many-to-many relationship setup on my site.
Faculty (parent) --> Research Projects (Child) <--- Portfolio (Parent)
I have a view on this Portfolio page: hidden link that displays any "Research Projects" that are a child of it, but the view shows fields based on the Faculty parent.
What I need this view to do is show me Faculty that share a child Research Project with the Portfolio item. It does this! BUT I need to to display alphabetically by post title of the Faculty post, not the Research Project.
I've attached two screenshots so you can see my query and my view. Please let me know if there's anyway to alphabetize the faculty fields being displayed.
Thanks!
