Model::havingOpen

Add open bracket on Having query

Description

public self Model::havingOpen( [ string $andOr = 'AND' ] )

Opens a bracket in the HAVING clause; close it with havingClose.

Arguments

Name	Data type	Default	Remarks
$andOr	string	'AND'	How the bracket joins the previous condition: AND or OR

Example

Controller

$model = new Model(false, array(
    'table'   => 'cms_news',
    'id'      => 'news_id',
    'visible' => 'visible',
));

$model->select('category, count(*) AS n, max(post_date) AS latest')->group('category');
$model->having('n > ?', 5);
$model->havingOpen();
$model->having('category = ?', 1);
$model->having('latest >= ?', '2026-01-01', 'OR');
$model->havingClose();

// ... Group By category
// Having n > 5 AND (category = 1 OR latest >= '2026-01-01')
$records = $model->all();