Jump to main content Jump to doc navigation

xPDOQuery::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);

See Also

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

  • modmore
  • Jens Wittmann – Gestaltung & Entwicklung
  • Digital Penguin
  • eydolan
  • deJaya
  • Following Sea
  • Nick Clark
  • Lefthandmedia
  • YJ
  • Sepia River Studios
  • Murray Wood
  • Dannevang Digital
  • Richard

Budget

$217 per month—let's make that $500!

Learn more