public function views_handler_filter_node_uid_revision::query in Views (for Drupal 7) 7.3

Same name and namespace in other branches

1. 6.3 modules/node/views_handler_filter_node_uid_revision.inc \views_handler_filter_node_uid_revision::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_in_operator::query

File

modules/node/views_handler_filter_node_uid_revision.inc, line 18

Definition of views_handler_filter_node_uid_revision.

Class

views_handler_filter_node_uid_revision

Filter handler to check for revisions a certain user has created.

Code

public function query($group_by = FALSE) {
  $this
    ->ensure_my_table();
  $placeholder = $this
    ->placeholder();
  $args = array_values($this->value);
  $this->query
    ->add_where_expression($this->options['group'], "{$this->table_alias}.uid IN({$placeholder}) " . "OR\n      ((SELECT COUNT(*) FROM {node_revision} nr WHERE nr.uid IN({$placeholder}) AND nr.nid = {$this->table_alias}.nid) > 0)", array(
    $placeholder => $args,
  ), $args);
}