function revisioning_handler_filter_node_number_of_revisions::query in Revisioning 6.4

Same name and namespace in other branches

1. 8 views/revisioning_handler_filter_node_number_of_revisions.inc \revisioning_handler_filter_node_number_of_revisions::query()
2. 6.3 views/revisioning_handler_filter_node_number_of_revisions.inc \revisioning_handler_filter_node_number_of_revisions::query()
3. 7 views/revisioning_handler_filter_node_number_of_revisions.inc \revisioning_handler_filter_node_number_of_revisions::query()

Override the query, in particular the WHERE clause.

File

views/revisioning_handler_filter_node_number_of_revisions.inc, line 13

Views filter override to filter on the number of revisions a node has.

Class

revisioning_handler_filter_node_number_of_revisions

@file Views filter override to filter on the number of revisions a node has.

Code

function query() {
  if (empty($this->value)) {
    return;
  }
  $info = $this
    ->operators();
  if (!empty($info[$this->operator]['method'])) {
    $node_table = $this
      ->ensure_my_table();
    $revisions_table = $this->query
      ->ensure_table('node_revisions');
    $pseudo_field = '(SELECT COUNT(vid) FROM {' . $revisions_table . '} WHERE nid=$node_table.nid)';
    $this
      ->{$info[$this->operator]['method']}($pseudo_field);
  }
}