[CODE]use Bitrix\Main;
use \Bitrix\Sale;
$new['filter'] = [
'PROPERTY_VAL.ORDER_PROPS_ID' => '1',
'PROPERTY_VAL.VALUE' => 'N',
'PROPERTY_VAL_2.ORDER_PROPS_ID' => '2',
'PROPERTY_VAL_2.VALUE' => 'N'
];
$new['runtime'] = [
'PROPERTY_VAL' => [
'data_type' => Sale\Internals\OrderPropsValueTable::class,
'reference' => [
'=this.ID' => 'ref.ORDER_ID',
],
'join_type' => 'LEFT'
],
'PROPERTY_VAL_2' => [
'data_type' => Sale\Internals\OrderPropsValueTable::class,
'reference' => [
'=this.ID' => 'ref.ORDER_ID',
],
'join_type' => 'LEFT'
]
];
$dbRes = \Bitrix\Sale\Order::getList($new);
while ($order = $dbRes->fetch()){
echo $order['ID'].'<br>';
}[/CODE]
use \Bitrix\Sale;
$new['filter'] = [
'PROPERTY_VAL.ORDER_PROPS_ID' => '1',
'PROPERTY_VAL.VALUE' => 'N',
'PROPERTY_VAL_2.ORDER_PROPS_ID' => '2',
'PROPERTY_VAL_2.VALUE' => 'N'
];
$new['runtime'] = [
'PROPERTY_VAL' => [
'data_type' => Sale\Internals\OrderPropsValueTable::class,
'reference' => [
'=this.ID' => 'ref.ORDER_ID',
],
'join_type' => 'LEFT'
],
'PROPERTY_VAL_2' => [
'data_type' => Sale\Internals\OrderPropsValueTable::class,
'reference' => [
'=this.ID' => 'ref.ORDER_ID',
],
'join_type' => 'LEFT'
]
];
$dbRes = \Bitrix\Sale\Order::getList($new);
while ($order = $dbRes->fetch()){
echo $order['ID'].'<br>';
}[/CODE]