function kaltura_views_handler_filter_kaltura_text::query in Kaltura 7.3
Same name and namespace in other branches
- 7.2 plugins/kaltura_views/kaltura_views_handler_filter_kaltura_text.inc \kaltura_views_handler_filter_kaltura_text::query()
Add this filter to the query.
Due to the nature of fapi, the value and the operator have an unintended level of indirection. You will find them in $this->operator and $this->value respectively.
Overrides views_handler_filter::query
File
- plugins/
kaltura_views/ kaltura_views_handler_filter_kaltura_text.inc, line 51 - Class kaltura_views_handler_filter_kaltura_text.
Class
- kaltura_views_handler_filter_kaltura_text
- Kaltura Text filter handler class.
Code
function query() {
$this
->ensure_my_table();
$field = "{$this->table_alias}.{$this->real_field}";
$field1 = "{$this->table_alias}.kaltura_tags";
$field2 = "{$this->table_alias}.kaltura_description";
$concat = "({$field} OR {$field1} OR {$field2})";
$placeholder = $this
->placeholder();
$this->query
->add_where_expression($this->options['field'], "{$field} LIKE {$placeholder}", array(
$placeholder => '%' . db_like($this->value) . '%',
));
$this->query
->add_where_expression($this->options['field'], "{$field1} LIKE {$placeholder}", array(
$placeholder => '%' . db_like($this->value) . '%',
));
$this->query
->add_where_expression($this->options['field'], "{$field2} LIKE {$placeholder}", array(
$placeholder => '%' . db_like($this->value) . '%',
));
$this->query
->set_where_group('OR', $this->options['field']);
}