array arOrder = Array("ID"=>"DESC"),
 array arFilter = Array(),
 bool  arGroupBy = false,
 bool  arNavStartParams = false,
 array arSelectFields = Array()

Returns list of categories by the arFilter, sorted in the arOrder. Non-static method.

Method parameters

arOrder Array for sorting of result. Array of the array("sorting field"=>"sorting direction" [, ...]) type Field for sorting can have the following values:
  • ID - category ID;
  • BLOG_ID - blog ID;
  • NAME - category name.
Optional. By default it is filtered by descending category ID.
arFilter Array of the array("filtered field"=>"filter value" [, ...])type. Filtered field can have the following values:
  • ID - category ID;
  • BLOG_ID - blog ID;
  • NAME - category name.
Type of filtration can be specified in front of the name of filtered field:
  • "!" - not equal
  • "<" - less
  • "<=" - less or equal
  • ">" - more
  • ">=" - more or equal

"filter value" - single value or an array.

Optional. By default records are not filtered.
arGroupBy Array of fields, by which the records are grouped. The array has the following structure:
      "aggregate_function2" => "field_name2", ...)
Any field can be specified as "field_nameN". The following can be specified as aggregate function:
  • COUNT - number count;
  • AVG - average value calculation;
  • MIN - minimal value calculation;
  • MAX - maximum value calculation;
  • SUM - sum calculation.
If the array is empty, the array will return the number of records, satisfying the filter.
Optional. By default - false - means that the result will not be grouped.
arNavStartParams Array of selection parameters. Can contain the following keys:
  • "nTopCount" - number of records returned by the method will be limited from above by the value of this key
  • any key, accepted by the CDBResult::NavQuery method as the third parameter.
Optional. By default - false - means that there are no sample parameters.
arSelectFields Array of records, which will be returned by the method. Only those fields that are needed can be specified. If there is a "*" value in the array - all available fields will be returned.

Optional. By default - empty array() - means that all fields of the request's main table will be returned.

Returned value

CDBResult object is returned.

Examples of use

// select all blog categories with identifier 1 
$arOrder = Array(
        "NAME" => "ASC",
        "ID" => "ASC"
$arFilter = Array(
$arSelectedFields = Array("ID", "BLOG_ID", "NAME");

$dbCategory = CBlogCategory::GetList($arOrder, $arFilter, false, false, $arSelectedFields);
while ($arCategory = $dbCategory->Fetch())

© «Bitrix24», 2001-2023