How to filter using CIBlockElement::SubQuery()?

Question

1C-Bitrix

CIBlockElement::SubQuery();does not filter by ACTIVE(or any other field/property). The filter is not applied. Outputs all elements.

$elementObj = CIBlockElement::GetList(
    [], 
    [
        'IBLOCK_ID' => 4,
        //'PROPERTY_REL_ID.ACTIVE' => 'N', // Это работает!
        'ID' => CIBlockElement::SubQuery('PROPERTY_REL_ID', [
            'IBLOCK_ID' => 1,
            'ACTIVE' => 'N'
        ]),
    ],
    false,
    false,
    ['ID', 'IBLOCK_ID', 'NAME']
);
    
while ($elementArray = $elementObj->Fetch()) {
    $resultArray[] = $elementArray;
}

Thus if to use $arFilter = ['PROPERTY_REL_ID.ACTIVE' => 'N'], then filters. But I need a filter by property.

Answer 1

Try like this:

[
        'IBLOCK_ID' => 4,

        'PROPERTY_REL_ID' => CIBlockElement::SubQuery('ID', [
            'IBLOCK_ID' => 1,
            'ACTIVE' => 'N'
        ]),
    ],
    false,
    false,