Customize search result

Hi wearecrunch,

I suggest you select the search mode ‘is one of’ for your role field. This way your users will be able to select one filter or both, according to their preference.

Hi Andrea, thank you for your reply. Unfortunately your suggestion does not solve my challenge as I don’t want to allow the user to select multiple roles at the same time.

Is there any options to customize the search result or filters via functions.php?

Yes, you can add this code to your functions.php file:

add_filter ('bps_field_sql', 'change_query', 10, 2);
function change_query ($sql, $f)
{
	if ($f->code == 'role' && $f->value != 'subscriber')
	{
		$sql['where']['set_match_any'] .= " OR (meta_value LIKE '%:\\\"administrator\\\";%')";
	}
	return $sql;
}

Replace ‘subscriber’ with the internal name of ‘Not in the mentor program’, and ‘administrator’ with the internal name of ‘Mentor and Mentee’.

Hi again,

I inserted this into my functions.php but it still only shows “Mentee” when I click that filter and not both “Mentee” and “Mentor and Mentee”. Is the code below correct?

add_filter (‘bps_field_sql’, ‘change_query’, 10, 2);
function change_query ($sql, $f)
{
if ($f->code == ‘role’ && $f->value != ‘Not in the mentor program’)
{
$sql[‘where’][‘set_match_any’] .= ” OR (meta_value LIKE ‘%:\\\”Mentor and Mentee\\\”;%’)”;
}
return $sql;
}

Sorry, I assumed you were using the WordPress role, but now I see you are using a BP profile field. So the correct code is:

add_filter ('bps_field_sql', 'change_query', 10, 2);
function change_query ($sql, $f)
{
	if ($f->code == 'field_24' && $f->value != 'Not in the mentor program')
	{
		$sql['where']['text_is'] .= " OR (value = 'Mentor and Mentee')";
	}
	return $sql;
}

You can use it as it is, and please let me know if it works for you!

Thank you! That was exactly what I meant, works perfectly ??