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

Same name and namespace in other branches

1. 6.3 modules/comment/views_handler_argument_comment_user_uid.inc \views_handler_argument_comment_user_uid::query()
2. 6.2 modules/comment/views_handler_argument_comment_user_uid.inc \views_handler_argument_comment_user_uid::query()

Set up the query for this argument.

The argument sent may be found at $this->argument.

Parameters

bool $group_by: Whether the query uses a group-by.

Overrides views_handler_argument::query

2 methods override views_handler_argument_comment_user_uid::query()

views_handler_argument_node_uid_revision::query in modules/node/views_handler_argument_node_uid_revision.inc

Set up the query for this argument.

views_handler_argument_tracker_comment_user_uid::query in modules/tracker/views_handler_argument_tracker_comment_user_uid.inc

Set up the query for this argument.

File

modules/comment/views_handler_argument_comment_user_uid.inc, line 53

Definition of views_handler_argument_comment_user_uid.

Class

views_handler_argument_comment_user_uid

Argument handler to accept a user id to check for nodes that user posted or commented on.

Code

public function query($group_by = FALSE) {
  $this
    ->ensure_my_table();
  $subselect = db_select('comment', 'c');
  $subselect
    ->addField('c', 'cid');
  $subselect
    ->condition('c.uid', $this->argument);
  $subselect
    ->where("c.nid = {$this->table_alias}.nid");
  $condition = db_or()
    ->condition("{$this->table_alias}.uid", $this->argument, '=')
    ->exists($subselect);
  $this->query
    ->add_where(0, $condition);
}