[url=https://dev.1c-bitrix.ru/api_d7/detail.php?ID=1755489]getList[/url]
\Bitrix\Main\DB\Result public static
\Bitrix\Main\Entity\DataManager::getList(
array $parameters = array()
);
Executes the query and returns selection by parameters of the query. This function is an alias to the Query object functions
Parameters
ParameterDescriptionVersion
$parametersAn array of query parameters, available keys are:
"select" => array of fields in the SELECT part of the query, aliases are possible in the form of "alias"=>"field";
"filter" => array of filters in the WHERE/HAVING part of the query in the form of "(condition)field"=>"value";
also could be an instance of Filter;
"group" => array of fields in the GROUP BY part of the query;
"order" => array of fields in the ORDER BY part of the query in the form of "field"=>"asc|desc";
"limit" => integer indicating maximum number of rows in the selection (like LIMIT n in MySql);
"offset" => integer indicating first row number in the selection (like LIMIT n, 100 in MySql);
"runtime" => array of entity fields created dynamically;
"cache => array of cache options:
"ttl" => integer indicating cache TTL;
"cache_joins" => boolean enabling to cache joins, false by default.
Exceptions
\Bitrix\Main\ArgumentException
See also
\Bitrix\Main\Entity\Query::filter()
Examples