[Resolved] Filter query by Relationship fields in a view on content template

[Author]

Posts

[giorgioC-2]

Good morning ,
I need to filter the results of a view based on filling in a field.
I created the relationship between two Posts, Companies and Networks. I added custom fields to the report: Join Date and Network Exit Date.
Now, inside the Network tab, I have to show the list of companies that have not entered data in the "date of exit from the network".

This is the page of list hidden link

Thank you

[Luo Yang]

Hello,

I assume we are talking about this case:
1) Two post types:
- Companies
- Networks

2) Many-to-many relationship between Companies and Networks using intermediate post type "report", with custom fields:
- Join Date
- Network Exit Date

You are going to do this:
In the single "Network" post, display those related Company posts without "Network Exit Date" value

If it is, you can try these:
Create a post view:
1) Query "report" posts
2) Filter by:
- post type relationship between Companies and Networks
- "Network Exit Date" field value is empty
- In view's loop, display related Companies post information
https://toolset.com/course-lesson/displaying-related-posts/#displaying-one-related-item-parent