Форум

$objDateTime = new DateTime();
$dateFieldName = "DEADLINE";
$arResult = array(">$dateFieldName" => $objDateTime->modify('-7 day')->format('d.m.Y 00:00:00'));

Array
(
    [>DEADLINE] => 2021-12-15 00:00:00

)

Array
(
    [<DEADLINE] => 2021-12-15 00:00:00

)

$sql = "
  SEL ECT
       `TASK_ID`
    FR OM
       `b_tasks_member`
    WHERE `USER_ID` = 775
";

$params = array(
    '!=ZOMBIE' => 'Y', // не удаленные задачи
    "MEMBER_LIST.USER_ID" => array(774,680,775), // ID подчиненных
    "!@MEMBER_LIST.TASK_ID" => new Bitrix\Main\DB\SqlEx * pression($sql), // ID задач (исключаем задачи, где руководитель является участником)
);

$db = TaskTable::getList($params);

$subQuery = new \Bitrix\Main\Entity\Query(Bitrix\Tasks\Internals\Task\MemberTable::getEntity());
$subQuery
    ->setSelect([
        'TASK_ID'
    ])
    ->setFilter([
        'USER_ID' => 775,
    ]);


$params = array(
    '!=ZOMBIE' => 'Y', // не удаленные задачи
    "MEMBER_LIST.USER_ID" => array(774,680,775), // ID подчиненных
    "!@MEMBER_LIST.TASK_ID" => new Bitrix\Main\DB\SqlEx * pression($subQuery->getQuery()), // ID задач (исключаем задачи, где руководитель является участником)
);

$db = TaskTable::getList($params);

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (1241) Operand should contain 1 column(s) (400)
SEL ECT 
   `w4a_hiddentasks_entity_bitrix_task`.`ID` AS `ID`
FR OM `b_tasks` `w4a_hiddentasks_entity_bitrix_task` 
INNER JOIN `b_tasks_member` `w4a_hiddentasks_entity_bitrix_task_member_task` ON `w4a_hiddentasks_entity_bitrix_task_member_task`.`TASK_ID` = `w4a_hiddentasks_entity_bitrix_task`.`ID`
WHERE (`w4a_hiddentasks_entity_bitrix_task`.`ZOMBIE` IS NULL OR `w4a_hiddentasks_entity_bitrix_task`.`ZOMBIE` <> 'Y')
AND (`w4a_hiddentasks_entity_bitrix_task_member_task`.`USER_ID` in (680, 689, 690, 691, 742, 763, 774))
AND `w4a_hiddentasks_entity_bitrix_task_member_task`.`TASK_ID` NOT IN (SEL ECT 
   `tasks_internals_task_member`.`TASK_ID` AS `TASK_ID`,
   `tasks_internals_task_member`.`USER_ID` AS `UALIAS_0`,
   `tasks_internals_task_member`.`TYPE` AS `UALIAS_1`
FR OM `b_tasks_member` `tasks_internals_task_member` 

WHERE `tasks_internals_task_member`.`USER_ID` = 775)
AND (`w4a_hiddentasks_entity_bitrix_task_member_task`.`TYPE` IS NULL OR `w4a_hiddentasks_entity_bitrix_task_member_task`.`TYPE` <> 'U')
GROUP BY `w4a_hiddentasks_entity_bitrix_task`.`ID`
/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:146