function quiz_views_handler_field_score_aggregate::query in Quiz 8.4

Same name and namespace in other branches

1. 6.6 includes/views/handlers/quiz_views_handler_field_score_aggregate.inc \quiz_views_handler_field_score_aggregate::query()
2. 6.3 includes/views/handlers/quiz_views_handler_field_score_aggregate.inc \quiz_views_handler_field_score_aggregate::query()
3. 6.4 includes/views/handlers/quiz_views_handler_field_score_aggregate.inc \quiz_views_handler_field_score_aggregate::query()
4. 6.5 includes/views/handlers/quiz_views_handler_field_score_aggregate.inc \quiz_views_handler_field_score_aggregate::query()
5. 7.6 includes/views/handlers/quiz_views_handler_field_score_aggregate.inc \quiz_views_handler_field_score_aggregate::query()
6. 7 includes/views/handlers/quiz_views_handler_field_score_aggregate.inc \quiz_views_handler_field_score_aggregate::query()
7. 7.4 includes/views/handlers/quiz_views_handler_field_score_aggregate.inc \quiz_views_handler_field_score_aggregate::query()

File

includes/views/handlers/quiz_views_handler_field_score_aggregate.inc, line 21

Class

quiz_views_handler_field_score_aggregate

Code

function query() {
  $this
    ->ensure_my_table();
  $this->query
    ->add_field($this->table_alias, $this->group_field);
  $this->field_alias = $this->query
    ->add_field(NULL, "AVG({$this->table_alias}.{$this->real_field})", $this->table_alias . '__average', array(
    'aggregate' => TRUE,
  ));
  $this->query
    ->add_groupby("{$this->table_alias}.{$this->group_field}");

  // nid is OK for average. Others maybe not so much
}