[Resolved] View selected by some fields values of child

[Author]

Posts

[fabriceS]

My PROPERTY CPT have a field "status" which indicates if it is for sale or sold.

This property is in relation to a ski-station.
One ski-station can have multiple properties.
I need to list all the ski-stations that have at least 1 property with the state "for sale". If a ski-station has 2 sold properties, it can not appear.
How can I achieve that ?

Many thanks.

[Minesh]

Hello. Thank you for contacting the Toolset support.

There are multiple ways - we can do this either by using the view's hook "wpv_filter_query" or using the "wpv_filter_query_post_process":
- https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query
- https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query_post_process

Here is the related ticket that might help you:
- https://toolset.com/forums/topic/only-display-parent-posts-that-have-children-with-a-custom-field-value/page/2/#post-2013295

if you need further assistance, please share problem URL where you want to display your view and tell me what posts should be included.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.