Topic Tag: Setting up post relationship

Problem:

Many-to-many relationship between post types "fighters" and "fight",

I have 2 fighters - Max and Andre. How can I show Max's Title when I look at Andre's profile?

What settings do I need to make this work?

P.S. Max and André - 2 fighters in a single fight

Solution:

It needs a nested view, for example,
1) parent view get related "fight" posts of current "fighter" post,

filter by:
Select posts in a Fights Fighters relationship that are related to the Post where this View is shown.

And display below child view:

2) Child view get related "fighter" post exclude current "fight" post:

in section "Query Options", enable option "Don't include current page in query result"

filter by:
Select posts in a Fights Fighters relationship that are a related to the current post in the loop.

3) Put the parent view into a single "fighter" post:

<hr />
<h2>Show related fighter's Title</h2>
[wpv-view name="related-fights-of-current-fighter-parent-view"]

Please test it, check if it is what you want. thanks

Relevant Documentation:

Problem:

I'm trying to create a functional MMA fights. (example.png)

I created CPTs -tournament (event), fight, fighter. But I'm stuck in some aspects. When I create a fight in backend, I choose two fighters (fight-fighters.jpg). Also I created select fields to this relationship:
- "result" (win, loss, draw)
- "method" (knockout, submissions, decision of the judges).

1. Here I have the first question. Am I on the right track? It's a little uncomfortable...After all, it's somewhat inconvenient to choose a "win" for one fighter and "loss" for another, the same for "method" .. You can get confused. Maybe I'm doing something wrong? What structure would you recommend?

2. To display the relationship fields, I had to use the view, because in the content template for the fighter, this field did not output anything. Am I doing the right thing?

Things have changed a bit in Toolset, and I want to adapt to new improvements and use the plugins correctly.

Solution:

Q1) I think your are on the right track, since one "fight" can connect to 2 "fighter" posts, and one "fighter" post can connect to multiple "fight" posts, you can setup many-to-many relationship between "fight" and "fighter" custom post types.

Q2) I have tested it in my localhost be below steps, it works fine:

1) Create two post type "fight" and "fighters", setup many-to-many "fight-fighter" relationship between them

2) Create a view, list posts of post type "fights fighters Intermediary Posts"

3) Filter by post type relationship:

Select posts in a fights fighters relationship that are related to the Post where this View is shown.

see screenshot: filter.JPG

https://cdn.toolset.com/wp-content/uploads/2018/05/904763-filter.JPG

4) in the "Loop Editor" section, display the result as below:

[wpv-post-link item="@fight-fighter.parent"] | 
[wpv-post-link item="@fight-fighter.child"] | 
[types field="result"][/types] | 
[types field="method"][/types]

Then put above view into a single "fight" post, it works fine.

Relevant Documentation: