3 namespace Drupal\node\Plugin\views\argument;
5 use Drupal\user\Plugin\views\argument\Uid;
8 * Filter handler to accept a user id to check for nodes that
9 * user posted or created a revision on.
11 * @ViewsArgument("node_uid_revision")
13 class UidRevision extends Uid {
15 public function query($group_by = FALSE) {
16 $this->ensureMyTable();
17 $placeholder = $this->placeholder();
18 $this->query->addWhereExpression(0, "$this->tableAlias.uid = $placeholder OR ((SELECT COUNT(DISTINCT vid) FROM {node_revision} nr WHERE nr.revision_uid = $placeholder AND nr.nid = $this->tableAlias.nid) > 0)", [$placeholder => $this->argument]);