Build the query to fetch data from the database
public buildQuery ( boolean $overrideLimits = false ) : JDatabaseQuery | ||
$overrideLimits | boolean | Should I override limits |
return | JDatabaseQuery | The database query to use |
/** * Overrides the DataModel's buildQuery to allow nested set searches using the provided scopes * * @param bool $overrideLimits * * @return \JDatabaseQuery */ public function buildQuery($overrideLimits = false) { $db = $this->getDbo(); $query = parent::buildQuery($overrideLimits); // Wipe out select and from sections $query->clear('select'); $query->clear('from'); $query->select($db->qn('node') . '.*')->from($db->qn($this->tableName) . ' AS ' . $db->qn('node')); if ($this->treeNestedGet) { $query->join('CROSS', $db->qn($this->tableName) . ' AS ' . $db->qn('parent')); } return $query; }