Support Forums

Hello Trevor,
sorry for not getting back sooner, was occuppied with the other suport ticket Ross is working on.

I checked your suggestion, but it is actually already set up like you suggested.

My developer managed to solve the problem by manually changing the class-search-filter-cache.php file from line 1292 (else if compare_mode overlap onward to this:

       else if($filter['compare_mode']=="overlap")
        {
            $field_terms_results = $wpdb->get_results( $wpdb->prepare(
                "
				SELECT post_id, post_parent_id, field_value_min, field_value_max FROM
					(SELECT min_table.post_id as post_id, min_table.post_parent_id as post_parent_id, min_table.field_value as field_value_min, max_table.field_value as field_value_max 
					FROM (SELECT post_id, post_parent_id, field_value FROM $this->table_name WHERE field_name = '%s') AS min_table
					LEFT JOIN (SELECT post_id, field_value FROM $this->table_name WHERE field_name = '%s') AS max_table 
					ON min_table.post_id = max_table.post_id) as range_table
				WHERE 
				(
					cast(field_value_min AS $cast_type) > cast(%s as $cast_type) AND
					cast(field_value_min AS $cast_type) < cast(%s as $cast_type)
				)
				OR
				(
				    cast(field_value_max AS $cast_type) > cast(%s as $cast_type) AND
					cast(field_value_max AS $cast_type) < cast(%s as $cast_type)
				)
				OR
				(
				    cast(field_value_min AS $cast_type) < cast(%s as $cast_type) AND
					cast(field_value_max AS $cast_type) > cast(%s as $cast_type)
				)
				OR
				(
				    cast(field_value_min AS $cast_type) >= cast(%s as $cast_type) AND
					cast(field_value_max AS $cast_type) <= cast(%s as $cast_type)
				)
				",
                $start_field_name, $end_field_name, $min_value, $max_value, $min_value, $max_value, $min_value, $max_value, $min_value, $max_value
            ) );
        }

I really do not want to revert to manual customization of plugin files, because that will cause me headaches with any future plugin update. Is there a way to make this change without altering the plugin files itself?