public function views_handler_sort_ncs_last_updated::query in Views (for Drupal 7) 7.3
Same name and namespace in other branches
- 6.3 modules/comment/views_handler_sort_ncs_last_updated.inc \views_handler_sort_ncs_last_updated::query()
- 6.2 modules/comment/views_handler_sort_ncs_last_updated.inc \views_handler_sort_ncs_last_updated::query()
Called to add the sort to a query.
Overrides views_handler_sort_date::query
File
- modules/
comment/ views_handler_sort_ncs_last_updated.inc, line 18 - Definition of views_handler_sort_ncs_last_updated.
Class
- views_handler_sort_ncs_last_updated
- Sort handler for the newer of last comment / node updated.
Code
public function query() {
$this
->ensure_my_table();
$this->node_table = $this->query
->ensure_table('node', $this->relationship);
$this->field_alias = $this->query
->add_orderby(NULL, "GREATEST(" . $this->node_table . ".changed, " . $this->table_alias . ".last_comment_timestamp)", $this->options['order'], $this->table_alias . '_' . $this->field);
}