The query uses Concat_WS which breaks my query I also had to tweak the code to fix collate errors.
In views_handler_filter_combine.inc

foreach ($fields as $key => $field) {
$separated_fields[] = $field . ' collate SQL_Latin1_General_CP1_CI_AS'; <----------had to add this
if ($key < $count - 1) {
$separated_fields[] = "' '";
}
}
$expression = implode(', ', $separated_fields );
//$expression = "CONCAT_WS(' ', $expression)";
$expression = "CONCAT(' ', $expression)"; <------- had to change to this.

This fixed my errors.

Comments

matpiet created an issue. See original summary.

matpiet’s picture

Title: issue with combined field filter » issue with combined field filter broken in MS SQL 2012