GetList

CDBResult
CBlogCategory::GetList(
 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

Parameter	Description
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: array("field_name1", "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(
        "BLOG_ID"=>'1'
    );
$arSelectedFields = Array("ID", "BLOG_ID", "NAME");

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