Modify WHERE clause

Hi Héctor,

You can add fields to the final query, there are multiple ways, these are not documented yet unfortunately. I recommend using these hooks:

$add_select = apply_filters('asp_cpt_query_add_select', '', $args, $phrase, $phrase_array);
$add_join = apply_filters('asp_cpt_query_add_join', '', $phrase, $phrase_array);
$add_where = apply_filters('asp_cpt_query_add_where', '', $phrase, $phrase_array);

You can add a hook to them like so:

add_filter('asp_cpt_query_add_join', 'my_asp_cpt_query_add_join', 10, 4);
function my_asp_cpt_query_add_join($query, $args, $phrase, $phrase_array) {
	global $wpdb;
	// Return the join query you want
	return "LEFT JOIN ...";
}

Sure, sorry I forgot about that:

apply_filters('asp_it_query_add_select', '');
apply_filters('asp_it_query_add_join', '');
apply_filters('asp_it_query_add_where', '');

Please note that the index table engine uses a completely different query on a different tabe, so to get the fields you need I recommend checking line 350-398 in wp-content/plugins/ajax-search-pro/includes/classes/search/class-asp-search-indextable.php

• This reply was modified 3 years, 5 months ago by  Ernest Marcinko.

Hm, I think not without changes to the core. It looks like I forgot to add those arguments to the filters.
Anyways, I will definitely fix that in the upcoming release, but until then, you can fix that by replacing one of the plugin files:

1. Open up the wp-content/plugins/ajax-search-pro/includes/classes/search/class-asp-search-indextable.php file on your server.
2. Replace it’s contents with this
3. Save

Now you should be able to use the same arguments as on the regular engine (query, $args, $phrase, $phrase_array)