function quiz_views_handler_filter_quiz_nid::subselect in Quiz 7.4

Same name and namespace in other branches

1. 8.4 includes/views/handlers/quiz_views_handler_filter_quiz_nid.inc \quiz_views_handler_filter_quiz_nid::subselect()
2. 6.6 includes/views/handlers/quiz_views_handler_filter_quiz_nid.inc \quiz_views_handler_filter_quiz_nid::subselect()
3. 6.3 includes/views/handlers/quiz_views_handler_filter_quiz_nid.inc \quiz_views_handler_filter_quiz_nid::subselect()
4. 6.4 includes/views/handlers/quiz_views_handler_filter_quiz_nid.inc \quiz_views_handler_filter_quiz_nid::subselect()
5. 6.5 includes/views/handlers/quiz_views_handler_filter_quiz_nid.inc \quiz_views_handler_filter_quiz_nid::subselect()
6. 7.6 includes/views/handlers/quiz_views_handler_filter_quiz_nid.inc \quiz_views_handler_filter_quiz_nid::subselect()
7. 7 includes/views/handlers/quiz_views_handler_filter_quiz_nid.inc \quiz_views_handler_filter_quiz_nid::subselect()

Helper method to retrieve the vid(s) the final view query should actually be run against.

Would be done in pre_query(), but $this->argument is not yet available at that time. So, called from set_argument().

1 call to quiz_views_handler_filter_quiz_nid::subselect()

quiz_views_handler_filter_quiz_nid::query in includes/views/handlers/quiz_views_handler_filter_quiz_nid.inc

Override the default behavior of query() to introduce the medial step of retrieving vids from the provided nids.

File

includes/views/handlers/quiz_views_handler_filter_quiz_nid.inc, line 132

Class

quiz_views_handler_filter_quiz_nid

Code

function subselect() {
  $operation = $this->options['which_vid'] == 'initial' ? 'MIN' : 'MAX';
  $subalias = $this->secondary_table_alias . '__subselect';
  $subselect = "SELECT {$operation}({$subalias}.{$this->secondary_vid}) FROM ";
  $subselect .= '{' . $this->secondary_table . "} {$subalias} WHERE ";
  $subselect .= "{$subalias}.{$this->secondary_group_by} = {$this->secondary_table_alias}.{$this->secondary_group_by} AND ";
  $subselect .= "{$subalias}.{$this->secondary_nid} = {$this->secondary_table_alias}.{$this->secondary_nid}";
  return $subselect;
}