Андрей Николаев (Все сообщения пользователя)

\Bitrix\Main\Loader::IncludeModule('iblock');

use Bitrix\Main\ORM\Query;
use Bitrix\Main\Entity;

$resList = \Bitrix\Iblock\ElementTable::getList([
   'sel ect' => [
      'ID',
      'PROPERTY_LIST.NAME'
   ],
   'filter' => [
      '=IBLOCK_ID' => 1
   ],
   'runtime' => [
      new Entity\ReferenceField(
         'PROPERTY_LIST', 
         \Bitrix\Iblock\PropertyTable::class,
         Query\Join::on('this.IBLOCK_ID', 'ref.IBLOCK_ID')
            ->whereNull("ref.FILE_TYPE")
      )
   ]
]);

SELECT 
   `iblock_element`.`ID` AS `ID`,
   `iblock_element_property_list`.`NAME` AS `IBLOCK_ELEMENT_PROPERTY_LIST_NAME`
FR OM `b_iblock_element` `iblock_element` 
LEFT JOIN `b_iblock_property` `iblock_element_property_list` ON `iblock_element`.`IBLOCK_ID` = `iblock_element_property_list`.`IBLOCK_ID` AND `iblock_element_property_list`.`FILE_TYPE` IS NULL
WHERE `iblock_element`.`IBLOCK_ID` = 1

SELECT 
   `iblock_element`.`ID` AS `ID`,
   `iblock_element_property_list`.`NAME` AS `IBLOCK_ELEMENT_PROPERTY_LIST_NAME`
FR OM `b_iblock_element` `iblock_element` 
LEFT JOIN `b_iblock_property` `iblock_element_property_list` ON `iblock_element`.`IBLOCK_ID` = `iblock_element_property_list`.`IBLOCK_ID` AND `iblock_element_property_list`.`FILE_TYPE` IS NOT NULL
WH ERE `iblock_element`.`IBLOCK_ID` = 1

'!=this.FIELD' => false,

'reference' => [
   '=this.ID' => 'ref.IBLOCK_ID',
   'ref.CODE' => new \Bitrix\Main\DB\SqlEx * pression('?s', 'COLOR')
],