• Модуль: tasks
  • Путь к файлу: ~/bitrix/modules/tasks/lib/provider/taskquerybuilder.php
  • Класс: BitrixTasksProviderTaskQueryBuilder
  • Вызов: TaskQueryBuilder::getUserOptionField
private function getUserOptionField(string $field, int $option): ExpressionField
{
	$sql = "
		SELECT 'x' 
		FROM ". UserOptionTable::getTableName() ."
		WHERE TASK_ID = %s
		  AND USER_ID = {$this->taskQuery->getBehalfUser()} 
		  AND OPTION_CODE = {$option}
	";

	$sql = 'case when EXISTS(' . $sql . ') then 'Y' else 'N' end';

	return new ExpressionField(
		$field,
		$sql,
		['ID']
	);
}