Problem:
How to add a custom search for some field where the field value starts with the search term (rather than the normal behaviour where the search term can appear anywhere inside the field value).
Solution:
It is not supported within the UI, but you can use the Views API to customise the query arguments to take advantage of the ability to use regular expressions in meta queries.
Following is an example of such code, which needs editing for the ID(s) of the View(s) it should apply to, and the custom fields which should use this approach:
function tssupp_filter_query($view_args, $view_settings, $view_id)
{
$views = array( 167 ); // comma-separated array of View IDs to modify
$fields = array( 'wpcf-searchable' ); // comma-separated array of fields to modify filter of, including wpcf- prefix
if ( in_array($view_id, $views ) && isset( $view_args['meta_query'] ) ) {
$meta_queries = $view_args['meta_query'];
foreach ($meta_queries as $key => $meta_query) {
if ( in_array( $meta_query['key'], $fields ) ){
$view_args['meta_query'][$key]['value'] = '^'.$meta_query['value'];
$view_args['meta_query'][$key]['compare'] = 'REGEXP';
}
}
}
return $view_args;
}
add_filter('wpv_filter_query', 'tssupp_filter_query', 101, 3);
We document known issues and their solutions in Toolset errata. Save time by checking there first and seeing if what you are facing is a known issue. This list is kept short. We do our best to resolve all known issues with every release of Toolset plugins.
Support Policy
Toolset staff will help you use the Toolset plugins correctly, provide any information you need, help troubleshoot problems and advice on best-practices.
Please make sure to issue only one topic per each support ticket.
