• Модуль: tasks
  • Путь к файлу: ~/bitrix/modules/tasks/lib/internals/task/projectuseroption.php
  • Класс: BitrixTasksInternalsTaskProjectUserOptionTable
  • Вызов: ProjectUserOptionTable::getSelectExpression
static function getSelectExpression(int $userId, int $option): string
{
	$tableName = static::getTableName();

	return "
		IF(
			EXISTS(
				SELECT 'x'
				FROM {$tableName}
				WHERE
					PROJECT_ID = %s
					AND USER_ID = {$userId}
					AND OPTION_CODE = {$option}
			),
			'Y',
			'N'
		)
	";
}