3 namespace Drupal\node\Plugin\views\filter;
5 use Drupal\user\Plugin\views\filter\Name;
8 * Filter handler to check for revisions a certain user has created.
10 * @ingroup views_filter_handlers
12 * @ViewsFilter("node_uid_revision")
14 class UidRevision extends Name {
16 public function query($group_by = FALSE) {
17 $this->ensureMyTable();
19 $placeholder = $this->placeholder() . '[]';
21 $args = array_values($this->value);
23 $this->query->addWhereExpression($this->options['group'], "$this->tableAlias.uid IN($placeholder) OR
24 ((SELECT COUNT(DISTINCT vid) FROM {node_revision} nr WHERE nr.revision_uid IN ($placeholder) AND nr.nid = $this->tableAlias.nid) > 0)", [$placeholder => $args],