function views_handler_field_ncs_last_updated::query in Views (for Drupal 7) 6.2

Same name and namespace in other branches

1. 6.3 modules/comment/views_handler_field_ncs_last_updated.inc \views_handler_field_ncs_last_updated::query()
2. 7.3 modules/comment/views_handler_field_ncs_last_updated.inc \views_handler_field_ncs_last_updated::query()

Called to add the field to a query.

Overrides views_handler_field::query

File

modules/comment/views_handler_field_ncs_last_updated.inc, line 6

Class

views_handler_field_ncs_last_updated

Field handler to display the newer of last comment / node updated

Code

function query() {
  $this
    ->ensure_my_table();
  $this->node_table = $this->query
    ->ensure_table('node', $this->relationship);
  $this->field_alias = $this->query
    ->add_field(NULL, "GREATEST(" . $this->node_table . ".changed, " . $this->table_alias . ".last_comment_timestamp)", $this->table_alias . '_' . $this->field);
}