protected function translateCondition(&$condition) {
switch ($condition['operator']) {
case 'STARTS_WITH':
$condition['value'] .= '%';
$condition['operator'] = 'LIKE';
break;
case 'CONTAINS':
$condition['value'] = '%' . $condition['value'] . '%';
$condition['operator'] = 'LIKE';
break;
case 'ENDS_WITH':
$condition['value'] = '%' . $condition['value'];
$condition['operator'] = 'LIKE';
break;
}
}