• Модуль: tasks
  • Путь к файлу: ~/bitrix/modules/tasks/lib/internals/useroption.php
  • Класс: BitrixTasksInternalsUserOption
  • Вызов: UserOption::getFilterSql
static function getFilterSql(int $userId, int $option, $aliasPrefix = ''): string
{
	$filterSql = '';

	if (!$userId || !static::isOption($option))
	{
		return $filterSql;
	}

	$tableName = UserOptionTable::getTableName();

	return "IN (
		SELECT {$aliasPrefix}TUO.TASK_ID FROM {$tableName} {$aliasPrefix}TUO
		WHERE
			{$aliasPrefix}TUO.OPTION_CODE = {$option}
			AND {$aliasPrefix}TUO.TASK_ID = {$aliasPrefix}T.ID
			AND {$aliasPrefix}TUO.USER_ID = {$userId}
	)";
}