having() public method

Sets the HAVING part of the query.
See also: andHaving()
See also: orHaving()
public having ( string | array | yii\db\Expression $condition, array $params = [] )
$condition string | array | yii\db\Expression the conditions to be put after HAVING. Please refer to [[where()]] on how to specify this parameter.
$params array the parameters (name => value) to be bound to the query.
Query Class Documentation
Example #1
0
 public function testHaving()
 {
     $query = new Query();
     $query->having('id = :id', [':id' => 1]);
     $this->assertEquals('id = :id', $query->having);
     $this->assertEquals([':id' => 1], $query->params);
     $query->andHaving('name = :name', [':name' => 'something']);
     $this->assertEquals(['and', 'id = :id', 'name = :name'], $query->having);
     $this->assertEquals([':id' => 1, ':name' => 'something'], $query->params);
     $query->orHaving('age = :age', [':age' => '30']);
     $this->assertEquals(['or', ['and', 'id = :id', 'name = :name'], 'age = :age'], $query->having);
     $this->assertEquals([':id' => 1, ':name' => 'something', ':age' => '30'], $query->params);
 }