Вот вам вар. А[CODE]<?
use Bitrix \ Highloadblock \ HighloadBlockTable as HLBT ;
if ( $_GET [ 'filter1' ]== 'prosmotr' ) { $arFilter [] = array ( '>IDPROSMOTR' => 0 );}
$entityProsmotr = HLBT::compileEntity(HLBT::getById( 4 )->fetch());
$rsUsersU = Bitrix\Main\UserTable::getList( Array (
"select" => Array (
'ID' ,
new \Bitrix\Main\Entity\ExpressionField(
'IDPROSMOTR',
"MAX(%s)",
['PROSMOTR.ID']
),
),
"filter" => $arFilter ,
"count_total" => true ,
"offset" => $nav ->getOffset(),
"limit" => $nav ->getLimit(),
'group' => ['ID'],
'order' => array ( $SORT_BY1 => $SORT_ORDER1 ),
"runtime" => array (
'ELEMENT' => array (
'data_type' => $entity2 ->getDataClass(),
'reference' => array ( '=this.ID' => 'ref.UF_USER' ), 'join_type' => 'LEFT' ,
),
'PROSMOTR' => array (
'data_type' => $entityProsmotr ->getDataClass(),
'reference' => array ( '=this.ID' => 'ref.UF_USER' ), 'join_type' => 'LEFT'
),
)
));
while ( $arUsersU = $rsUsersU ->fetch()) {
var_dump( $arUsersU [ 'ID' ]); echo " - " ; var_dump( $arUsersU [ 'IDPROSMOTR' ]);
echo "<hr>" ;
}
?>
[/CODE]
Вот вам вар. Б[CODE]<?
use Bitrix \ Highloadblock \ HighloadBlockTable as HLBT ;
if ( $_GET [ 'filter1' ]== 'prosmotr' ) { $arFilter [] = array ( '>IDPROSMOTR' => 0 );}
$entityProsmotr = HLBT::compileEntity(HLBT::getById( 4 )->fetch());
$rsUsersU = Bitrix\Main\UserTable::getList( Array (
"select" => Array (
'ID' ,
new \Bitrix\Main\Entity\ExpressionField(
'IDPROSMOTR',
"GROUP_CONCAT(DISTINCT %s SEPARATOR ',')",
['PROSMOTR.ID']
),
),
"filter" => $arFilter ,
"count_total" => true ,
"offset" => $nav ->getOffset(),
"limit" => $nav ->getLimit(),
'group' => ['ID'],
'order' => array ( $SORT_BY1 => $SORT_ORDER1 ),
"runtime" => array (
'ELEMENT' => array (
'data_type' => $entity2 ->getDataClass(),
'reference' => array ( '=this.ID' => 'ref.UF_USER' ), 'join_type' => 'LEFT' ,
),
'PROSMOTR' => array (
'data_type' => $entityProsmotr ->getDataClass(),
'reference' => array ( '=this.ID' => 'ref.UF_USER' ), 'join_type' => 'LEFT'
),
)
));
while ( $arUsersU = $rsUsersU ->fetch()) {
var_dump( $arUsersU [ 'ID' ]); echo " - " ; var_dump( $arUsersU [ 'IDPROSMOTR' ]);
echo "<hr>" ;
}
?>
[/CODE]