function views_raw_sql_get_field_sql in Views Raw SQL 7

Get sql from field. We did this before in views_fieldoperations.

Parameters

$field_handler:

$query_alias:

Return value

string

1 call to views_raw_sql_get_field_sql()

views_raw_sql_get_query_tokens in ./views_raw_sql.module

Get query tokens. Nearly straight copy (without self tokens) from \views_handler_field::get_render_tokens().

File

./views_raw_sql.module, line 131

Code

function views_raw_sql_get_field_sql($field_handler, $query_alias) {

  // Oh this is hacky, but we need  it...
  if (empty($field_handler->query->fields)) {
    $field_handler->view
      ->_build('field');
  }
  $query_fields = $field_handler->query->fields;
  if (isset($query_fields[$query_alias]['field'])) {

    // We must copy the SQL expression, because aliases can neither be used in
    // select, where, having, orderby. (At least not portably.)
    $query_field = $query_fields[$query_alias];
    $snippet = $query_field['field'];
    if (!empty($query_field['table'])) {
      $snippet = $query_field['table'] . '.' . $snippet;
    }
    return $snippet;
  }
}