• Модуль: tasks
  • Путь к файлу: ~/bitrix/modules/tasks/lib/provider/taskquerybuilder.php
  • Класс: BitrixTasksProviderTaskQueryBuilder
  • Вызов: TaskQueryBuilder::getDurationFactField
private function getDurationFactField(): ExpressionField
{
	$query = self::createQuery(self::ALIAS_TASK_ELAPSED_TIME, ElapsedTimeTable::getEntity());
	$query->addSelect(
		new ExpressionField(
			"SUM",
			"sum(%s)",
			["MINUTES"]
		)
	);
	$query->where('TASK_ID', new SqlExpression('%s'));
	$query->addGroup('TASK_ID');

	return new ExpressionField(
		"DURATION_FACT",
		"(".$query->getQuery().")",
		["ID"]
	);
}