public function NullSort::query in Views Sort Null Field 1.x

Same name and namespace in other branches

1. 8 src/Plugin/views/sort/NullSort.php \Drupal\views_sort_null_field\Plugin\views\sort\NullSort::query()
2. 9.1.x src/Plugin/views/sort/NullSort.php \Drupal\views_sort_null_field\Plugin\views\sort\NullSort::query()

Called to add the sort to a query.

Overrides SortPluginBase::query

File

src/Plugin/views/sort/NullSort.php, line 17

Class

NullSort

Basic sort handler for NULL values.

Namespace

Drupal\views_sort_null_field\Plugin\views\sort

Code

public function query() {
  $this
    ->ensureMyTable();

  // Make an alias.
  $alias = implode('_', [
    $this->tableAlias,
    $this->realField,
    'is_null',
  ]);
  $this->query
    ->addOrderBy(NULL, "ISNULL({$this->tableAlias}.{$this->realField})", $this->options['order'], $alias);
}