GROUP_CONCAT(expr)
Wed, 08/10/2011 - 09:13
concating txt elements in group clause
Added in QQuery.slass.php
class QQGroupConcat extends QQAggregationClause {
protected $strFunctionName = 'GROUP_CONCAT';
public function __toString() {
return 'QQGroupConcat Clause';
}
}
static public function GroupConcat($objNode, $strAttributeName) {
return new QQGroupConcat($objNode, $strAttributeName);
}usage
QQ::GroupConcat(QQN::Order()->Note, 'NOTE'),
Hi Mile, this is a great add for the QCubed core. I suggest ask if this feature can be added in the next release.
I use sometimes the function on MySQL querys but being not build in QCubed makes me do my own custom QQuerys.
This is excelent!
JMI