[Resolved] Search by grandparent value, parent value, and post value

[Author]

Posts

[chrisS-24]

Tell us what you are trying to do?
-My post types and relationships:
--Seasons (1) => Competitions (many)
--Competitions (1) => Results (many)

-My goal:
--Create a search form that allows a user to search on a field from Seasons, a field from Competitions, and several fields from Results. The search should display Results that match the criteria (ex. Season Name = '2018', Competition City = 'City A', Results Studio = 'Studio A', Results Dancer = 'Dancer A'

Is there any documentation that you are following?
-I searched your support and this is what I found: https://toolset.com/forums/topic/parentchild-relationship-in-custom-search-and-post-form/. I don't, however, understand how to translate this into what I have.

Is there a similar example that we can see?
-hidden link is actually showing Results (even though the name is photos...I'm just re-using results to show something different)

What is the link to your site?
-hidden link is the development version of the site.

[Luo Yang]

Hello,

Yes, it should be possible within Toolset plugins, see our live demo site:
hidden link

In section "Search Houses Use filters", there are two filters:
- State
- City

Which is similar as your case, you can also create your own real-estate demo site here:
https://discover-wp.com/site-types/bootstrap-estate-layouts/

In your case, you just need to setup below post type relationship:
- one-to-many relationship between post types "Seasons" and "Competitions"
- one-to-many relationship between post types "Competitions" and "Results"

Then create a view querying "Results" posts, and in section "Search and Pagination", add a post relationship filter, see screenshot: relationship-filter.JPG