Login Register

Mvc\Model\Query\Builder::having

public having (mixed $having)

Sets a HAVING condition clause. You need to escape PHQL reserved words using [ and ] delimiters

$builder->having('SUM(Robots.price) > 0');

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Mvc_Model_Query_Builder.html#having

doc_Phalcon

2016-10-16 09:54:31

Comments

Leave a Comment

Please login to continue.

Popular Articles

Mvc\Model\Query\Builder implements Phalcon\Mvc\Model\Query\BuilderInterface, Phalcon\Di\InjectionAwareInterface Source on GitHub Helps to create PHQL queries using an OO int

Mvc\Model\Query\Builder::from public from (mixed $models) Sets the models who makes part of the query $builder->from('Robots'); $builder->from(array('Robots', 'RobotsParts')

Mvc\Model\Query\Builder::leftJoin public Phalcon\Mvc\Model\Query\Builder leftJoin (string $model, [string $conditions], [string $alias]) Adds a LEFT join to the query $builder->lef

Mvc\Model\Query\Builder::andWhere public Phalcon\Mvc\Model\Query\Builder andWhere (string $conditions, [array $bindParams], [array $bindTypes]) Appends a condition to the current cond

Mvc\Model\Query\Builder::distinct public distinct (mixed $distinct) Sets SELECT DISTINCT / SELECT ALL flag $builder->distinct("status"); $builder->distinct(null);