• Модуль: tasks
  • Путь к файлу: ~/bitrix/modules/tasks/lib/provider/taskprovider.php
  • Класс: BitrixTasksProviderTaskProvider
  • Вызов: TaskProvider::buildQuery
private function buildQuery(): string
{
	$strSql = "
		SELECT " . $this->distinct . "
		" . implode(",n", $this->arSqlSelect) . "
		" . $this->obUserFieldsSql->GetSelect() . "
		FROM b_tasks T
		" . implode("n", $this->arJoins) . "
		" . implode("n", $this->relatedJoins) . "
		" . $this->obUserFieldsSql->GetJoin("T.ID") . "
		" . (count($this->arSqlSearch)? "WHERE " . implode(" AND ", $this->arSqlSearch) : "") . "
		" . $this->strGroupBy . "
		" . $this->strSqlOrder;

	return $strSql;
}