I would like to query with four variables. Three of them are inside of the same repeating field. The forth is the city of a connected address field. The content type is parish, it has a repeating field of mass times. Mass times has three variables: Day of the week, Language, Time.
I have setup a view, Post type Parish, with filters of Language, times, and city.
When I add the city in, it doesn't work.
Here is the custom query
function custom_search_criteria( $query_args ,$view_settings ) {
if (isset($view_settings['view_id']) && $view_settings['view_id'] == 59863 ) {
$index = 0;
if(isset($query_args['meta_query'])){
$index = count($query_args['meta_query'])+1;
}
$mass_time = $_GET['mass-time'][0] ;
$mass_end_time=$mass_time+400;
$mass_day = $_GET['mass-day'];
$mass_city = $_GET['city'];
$mass_language = $_GET['mass-language'];
$query_args['meta_query'][$index] = array(
'relation' => 'AND',
array(
'key' => 'wpcf-masstimes-start_time',
'value' => ($mass_time .",".$mass_end_time),
'compare' => 'BETWEEN',
'type' => 'NUMERIC',
),
array(
'key' => 'wpcf-masstimes-day_of_the_week',
'value' => $mass_day,
'compare' => 'IN',
),
array(
'key' => 'wpcf-masstimes-language',
'value' => $mass_language,
'compare' => 'IN',
),
array(
'key' => 'wpcf-parish_address_locality',
'value' => $mass_city,
'compare' => 'IN',
)
);
}
return $query_args;
}
This is the MYSQL it generates:
SELECT wp_posts.*
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
INNER JOIN wp_postmeta AS mt2
ON ( wp_posts.ID = mt2.post_id )
INNER JOIN wp_postmeta AS mt3
ON ( wp_posts.ID = mt3.post_id )
WHERE 1=1
AND ( ( ( wp_postmeta.meta_key = 'wpcf-masstimes-start_time'
AND CAST(wp_postmeta.meta_value AS SIGNED) BETWEEN '1000'
AND '1400' )
AND ( mt1.meta_key = 'wpcf-masstimes-day_of_the_week'
AND mt1.meta_value IN ('Sunday','','Sunday') )
AND ( mt2.meta_key = 'wpcf-masstimes-language'
AND mt2.meta_value IN ('French') )
AND ( mt3.meta_key = 'wpcf-parish_address_locality'
AND mt3.meta_value IN ('Regina') ) ) )
AND wp_posts.post_type IN ('parish', '45mass_times')
AND ((wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_title DESC
BUT the line for wpcf-parish_address_locality is not correct. Because the mass times is a repeating field the city and the repeating fields won't be in the same line.
I *think what I need is to have a filtered query with the IDs of the parishes First and check if it is that list, but I don't know how to do that.
Does that even make sense?
Content type: Parish
Fields :
Address Field (with a city)
Repeating items field with Day of the week, Language, Time
other fields
A working Drupal version of this is here: hidden link
