function StringArgument::getFormula

Get the formula for this argument.

$this->ensureMyTable() MUST have been called prior to this.

File

core/modules/views/src/Plugin/views/argument/StringArgument.php, line 175

Class

StringArgument

Basic argument handler to implement string arguments that may have length limits.

Namespace

Code

public function getFormula() {
    $formula = "SUBSTRING({$this->tableAlias}.{$this->realField}, 1, " . intval($this->options['limit']) . ")";
    if ($this->options['case'] != 'none') {
        // Support case-insensitive substring comparisons for SQLite by using the
        // 'NOCASE_UTF8' collation.
        // @see Drupal\Core\Database\Driver\sqlite\Connection::open()
        if (Database::getConnection()->databaseType() == 'sqlite') {
            $formula .= ' COLLATE NOCASE_UTF8';
        }
        // Support case-insensitive substring comparisons for PostgreSQL by
        // converting the formula to lowercase.
        if (Database::getConnection()->databaseType() == 'pgsql') {
            $formula = 'LOWER(' . $formula . ')';
        }
    }
    return $formula;
}