Hello everyone!
I'm using phalcon in a project but i have a problem using query builder.
my query has an column that I named with 'concat(JSON_EXTRACT(...)...) as <name>' alias,
but phalcon for any reason doesn't accepts this "column" in my having clause,
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'XXXX' in 'having clause
help please!
$di->setShared('dispatcher', function ($di) {
$dispatcher = new Dispatcher();
$dispatcher->setDefaultNamespace('CM\Controllers');
$eventsManager = $di->getShared('eventsManager');
$eventsManager->attach("dispatch:beforeExecuteRoute", new Auth());
$dispatcher->setEventsManager($eventsManager);
return $dispatcher;
});