Called to add the field to a query.
Overrides FieldPluginBase::query
public function query() {
// last_comment_name only contains data if the user is anonymous. So we
// have to join in a specially related user table.
$this
->ensureMyTable();
// join 'users' to this table via vid
$definition = array(
'table' => 'users',
'field' => 'uid',
'left_table' => $this->tableAlias,
'left_field' => 'last_comment_uid',
'extra' => array(
array(
'field' => 'uid',
'operator' => '!=',
'value' => '0',
),
),
);
$join = drupal_container()
->get('plugin.manager.views.join')
->createInstance('standard', $definition);
// ncs_user alias so this can work with the sort handler, below.
$this->user_table = $this->query
->ensure_table('ncs_users', $this->relationship, $join);
$this->field_alias = $this->query
->addField(NULL, "COALESCE({$this->user_table}.name, {$this->tableAlias}.{$this->field})", $this->tableAlias . '_' . $this->field);
$this->user_field = $this->query
->addField($this->user_table, 'name');
$this->uid = $this->query
->addField($this->tableAlias, 'last_comment_uid');
}