Build the query to fetch data from the database
| public buildQuery ( boolean $overrideLimits = false ) : JDatabaseQuery | ||
| $overrideLimits | boolean | Should I override limits |
| Результат | 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;
}
