Documentation

SubQuery

object
CIBlockElement::SubQuery(
 string strField,
array arFilter
 );

The method allows using subqueries. Static method.

Note: applicable only to the ID field for a main query element.

Call parameters

Parameter Description
strField Field name used for filtration.
Possible values:
  • ID - by element ID
  • PROPERTY_<PROPERTY_CODE> - by property value, where PROPERTY_CODE - ID or symbolic code for boded property. The property must have the "binded to elements" type.
arFilterElement filter is the same as in the methodCIBlockElement::GetList.

Returned value

Subquery object.

See Also

Examples

<?
//Select authors who wrote books in 21st century.
if(CModule::IncludeModule('iblock'))
{
$rsBooks = CIBlockElement::GetList(
array("NAME" => "ASC"), //Sort by name
array(
"IBLOCK_ID" => $AUTHOR_IBLOCK,
"ACTIVE" => "Y",
"ID" => CIBlockElement::SubQuery("PROPERTY_AUTHOR", array(
"IBLOCK_ID" => $BOOK_IBLOCK,
">=PROPERTY_PRINT_DATE" => "2000-01-01 00:00:00",
)),
),
false, // Without grouping
false, //without page wise navigation
array("ID", "IBLOCK_ID", "NAME") // Select only the fields required for display
);
while($arBook = $rsBooks->GetNext())
echo "<li>", $arBook["NAME"],"\n";
}
?>

See Also



© «Bitrix24», 2001-2022
Up