Борис (Все сообщения пользователя)

Catalog\PriceTable::getList(array(
                        'select' => array('PRODUCT_ID', 'PRICE', 'CURRENCY', 'QUANTITY_FROM', 'QUANTITY_TO'),
                        'filter' => array('@PRODUCT_ID' => $noOffersIds, '=CATALOG_GROUP_ID' => $priceId)
                    ));

registerRuntimeField('opt_is_approved', [
        'data_type'=>'integer',
        'expression' => ['%s IS NOT NULL', 'ug.GROUP_ID']

$res = CIBlockElement::SetPropertyValueCode(75630, "MORE_PHOTO_WATERMARK", []);

        $arFilter = [
            'ACTIVE' => 'Y',
            '=prop_uf_make.IBLOCK_PROPERTY_ID' => self::PROP_UF_MAKE,
        ];

        $query = new \Bitrix\Main\Entity\Query(\Bitrix\Iblock\ElementTable::getEntity());

        $query->registerRuntimeField('prop_uf_make', [
                'data_type' => '\Bitrix\Iblock\ElementPropertyTable',
                'reference' => ['=this.ID' => 'ref.IBLOCK_ELEMENT_ID'],
            ])->registerRuntimeField('section', [                
                'data_type' => '\Bitrix\Iblock\SectionTable',
                'reference' => ['=this.prop_uf_make.VALUE' => 'ref.ID'],
            ])->setSelect($arSelect);

$query = new \Bitrix\Main\Entity\Query(\Bitrix\Iblock\Model\Section::compileEntityByIblock(32)); 
$query 
   ->setOrder(array("ID" => "ASC")) 
   ->setFilter( 
      array( 
         "IBLOCK_ID" => 32, 
         "ACTIVE" => "Y", 
         0 => array( 
            "LOGIC" => 'AND', 
            0 => array( "UF_TAGS" => '2902' ), 
            1 => array( "UF_TAGS" => '4909' ), 
         ) 
      ) 
   ) 
   ->setSelect(
      array( "ID", "IBLOCK_ID", "UF_TAGS" )
   ) 
   ->setLimit(10); 
   
$result= $query->exec(); 
while ( $sec_arr= $result->fetch() ) { 
   echo '<pre>', print_r( $sec_arr ), '</pre>'; 
}

$arFilter = [
            '=property.IBLOCK_PROPERTY_ID' => 3461,
            'property.VALUE' => '%'.$findText.'%'
        ];


$query = new \Bitrix\Main\Entity\Query(\Bitrix\Iblock\ElementTable::getEntity());
        $query->registerRuntimeField('property', [
                'data_type' => '\Bitrix\Iblock\ElementPropertyTable',
                'reference' => ['=this.ID' => 'ref.IBLOCK_ELEMENT_ID'],
            ])->setSelect($arSelect)->setFilter($arFilter)

var basketItemHtml = this.renderBasketItem(basketItemTemplate, this.items[itemId]);