public function views_handler_argument_node_uid_revision::query in Views (for Drupal 7) 7.3
Same name and namespace in other branches
- 6.3 modules/node/views_handler_argument_node_uid_revision.inc \views_handler_argument_node_uid_revision::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_comment_user_uid::query
File
- modules/
node/ views_handler_argument_node_uid_revision.inc, line 17 - Definition of views_handler_argument_node_uid_revision.
Class
- views_handler_argument_node_uid_revision
- Filter handler to accept a user id to check for nodes that user posted or created a revision on.
Code
public function query($group_by = FALSE) {
$this
->ensure_my_table();
$placeholder = $this
->placeholder();
$this->query
->add_where_expression(0, "{$this->table_alias}.uid = {$placeholder} OR ((SELECT COUNT(*) FROM {node_revision} nr WHERE nr.uid = {$placeholder} AND nr.nid = {$this->table_alias}.nid) > 0)", array(
$placeholder => $this->argument,
));
}