You are here

Home » API reference » OA Comment 7.2 » views_handler_sort_oa_comment_last_date.inc » views_handler_sort_oa_comment_last_date

function views_handler_sort_oa_comment_last_date::query in OA Comment 7.2

Called to add the sort to a query.

Overrides views_handler_sort::query

File

views/views_handler_sort_oa_comment_last_date.inc, line 18
Definition of views_handler_sort_oa_comment_last_date.

Class

views_handler_sort_oa_comment_last_date
Sort handler to sort by last commented date or post

Code

function query() {
  $this
    ->ensure_my_table();
  $field = "{$this->table_alias}.{$this->real_field}";
  $node = $this->query
    ->ensure_table('node');

  // Add the field.
  $params = $this->options['group_type'] != 'group' ? array(
    'function' => $this->options['group_type'],
  ) : array();
  $this->query
    ->add_orderby(NULL, "COALESCE({$field}, {$node}.changed)", $this->options['order'], $this->table_alias . '_' . $this->field, $params);
}