[Cerrado] Parametric search and filtering by related content

[Autor]

Mensajes

[michaelR-12]

Hi
is it possible to create a view with parametric search and filter it by related custom type?

I have 3 types:
Courses
Trainers
References as my help object to allow many to many relationships between courses and trainers

I would like to create a view to display courses and filter them by related Trainers, is it possible?

Regards,
Michael

[Adriano]

Dear Michael,

This filter is not in our list of available filters. But as workaround you can create this manually:

1) Inser the Filter code manually in right section. The value must be the right post type slug name:

<select name="post_type">
<option value="Courses">Courses</option>
<option value="Trainers">Courses</option>
</select>

2) Use wpv_filter_query to extend the filter of this view:

add_filter('wpv_filter_query', 'filter_post_type', 10, 2);
function filter_post_type($query, $settings) {
    if($settings['view_id'] = 123)
    {
    	if(isset($_GET['post_type'])){
	    	$query['post_type'] = $_GET['post_type'];
	        return $query;
    	}
    }
}

You must replace 123 with the ID of the view. It will return only posts with the same post type of the URL parameter value "post_type": hidden link

[michaelR-12]

Hi Adriano, I'm not sure if I explained it right. I would like to create a view of courses and filter it by related trainers, so the filter option should be:

Filter:
<option>Trainer 1</option>
<option>Trainer 2</option>
<option>Trainer 3</option>

View:
Course 1
Course 2
Course 3
Course 4
....

Then if I choose in filter 'Trainer 2' it will show me only the courses where this trainer is an author of the course. Is it possible?

Is it possible to generate the trainers list in filter(options) dynamically, so if the trainer profile is deleted it will be no more available in filter as option to select?

Regards,
Michael

[Adriano]

Dear Michael,

Right, go to your view, then add the "Post Relationship - Post is a child of:" filter. You must choose the option "Post with ID set by the URL parameter". The thing you need to do now is to send the correct ID of the right parent in the URL argument.