xPDOQuery.setClassAlias
xPDOQuery::setClassAlias
Sets a SQL alias for the table represented by the main class.
Syntax
API Docs: http://api.modx.com/revolution/2.2/db_core_xpdo_om_xpdoquery.class.html#\xPDOQuery::setClassAlias()
xPDOQuery setClassAlias ([string $alias = ''])
Example
Grab all OtherBox objects, but set the alias to 'Box' for easier reading.
$query = $xpdo->newQuery('OtherBox');
$query->setClassAlias('Box');
$query->where(array(
'Box.name' => 'RoundBox',
));
$otherBoxes = $xpdo->getCollection('OtherBox',$query);