function LatestRevision::query

Overrides FilterPluginBase::query

File

core/modules/views/src/Plugin/views/filter/LatestRevision.php, line 88

Class

LatestRevision

Filter to show only the latest revision of an entity.

Namespace

Code

public function query() {
    
    /** @var \Drupal\views\Plugin\views\query\Sql $query */
    $query = $this->query;
    $query_base_table = $this->relationship ?: $this->view->storage
        ->get('base_table');
    $entity_type = $this->entityTypeManager
        ->getDefinition($this->getEntityType());
    $keys = $entity_type->getKeys();
    $definition = [
        'table' => $query_base_table,
        'type' => 'LEFT',
        'field' => $keys['id'],
        'left_table' => $query_base_table,
        'left_field' => $keys['id'],
        'extra' => [
            [
                'left_field' => $keys['revision'],
                'field' => $keys['revision'],
                'operator' => '>',
            ],
        ],
    ];
    $join = $this->joinHandler
        ->createInstance('standard', $definition);
    $join_table_alias = $query->addTable($query_base_table, $this->relationship, $join);
    $query->addWhere($this->options['group'], "{$join_table_alias}.{$keys['id']}", NULL, 'IS NULL');
}