xPDOQuery.setClassAlias
Last updated Dec 22nd, 2019 | Page history | Improve this page | Report an issue
Support the team building MODX with a monthly donation.
The budget raised through OpenCollective is transparent, including payouts, and any contributor can apply to be paid for their work on MODX.
Backers
Budget
$306 per month—let's make that $500!
Learn morexPDOQuery::setClassAlias¶
Sets a SQL alias for the table represented by the main class.
Syntax¶
API Docs: 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);