\Phalcon\Mvc\Model\Query\Builder alias?

Question

\Phalcon\Mvc\Model\Query\Builder alias?

Ivan Vorontsov Apr '13

Created Apr '13	Last Reply Apr '13	Replies 1	Views 2027	Votes 1

Ivan Vorontsov 18.5k

Apr '13

For example:

 $builder = $this->modelsManager->createBuilder()
                ->from('\Core\Model\LanguageTranslation')
                ->where("\\Core\\Model\\LanguageTranslation.original LIKE '%{$search}%'")
                ->orWhere("\\Core\\Model\\LanguageTranslation.translated LIKE '%{$search}%'");

Too long... Is there some possibility to add alias for table?

1

Phalcon
98.9k

Accepted
answer

Apr '13

You can use an alias this way:

 $builder = $this->modelsManager->createBuilder()
                ->from(array('la' => '\Core\Model\LanguageTranslation'))
                ->where("la.original LIKE '%{$search}%'")
                ->orWhere("la.translated LIKE '%{$search}%'");

Ivan Vorontsov · Answer 1 · 2013-04-16T13:08:16-07:00

Ivan Vorontsov
18.5k

Apr '13

Oh, thanks you, missed this in documentation in a rush.