function node_gallery_api_views_handler_item_date::query in Node Gallery 7
Called to add the field to a query.
Overrides views_handler_field::query
File
- includes/
views/ node_gallery_api_views_handler_item_date.inc, line 10 - Creates an image date handler for galleries.
Class
- node_gallery_api_views_handler_item_date
- @file Creates an image date handler for galleries.
Code
function query() {
$this
->ensure_my_table();
$sql = "SELECT n.changed FROM {node_gallery_relationship} ng\n LEFT JOIN {node} n on ng.nid = n.nid\n WHERE n.status = 1 AND ng.ngid = node.nid\n ORDER BY changed DESC LIMIT 1";
$this->field_alias = $this->query
->add_field(NULL, "({$sql})", 'item_date');
}