Find out the last order ID of a user?

Question

1C-Bitrix

Hello.
In this piece, the first order made by the user is displayed, and I need to get the ID of the last order generated. please help.

$arFilter = Array(
        "USER_ID" => $USER->GetID(),
    );
    $db_sales = CSaleOrder::GetList(array(), $arFilter);
    while ($ar_sales = $db_sales->Fetch())
    {
        $lasorderid = $ar_sales['ID']; //присвоили переменной ID заказа
    break; //оборвали цикл
    }

Answer 1

this is of course govnokod, tk. you need to edit the query to the database, and there already set the condition

$arFilter = Array(
    "USER_ID" => $USER->GetID(),
);
$db_sales = CSaleOrder::GetList(array(), $arFilter);
$ids = [];
while ($ar_sales = $db_sales->Fetch())
{
    $ids[] = $ar_sales['ID']; // сохраняем все id
}
$orderId =  $ids[count($ids)-1]; // последний элемент массива

Answer 2

So it will still be better, a request with limit is faster than without it

$orderData = \Bitrix\Sale\Order::getList([
  'select' => ['ID'],
  'filter' => ['=USER_ID' => $USER->GetID()],
  'order' => ['ID' => 'DESC'],
  'limit' => 1
]);
if ($order = $orderData->fetch())
{
  $lastOrderId = $order['ID'];
}

Answer 3

It is more correct to deal with the CSaleOrder class.
the first parameter of GetList() is what ?
and there is definitely no 3rd or 4th parameter?
Whether in a method to check sorting is explicitly specified?
and the fact that the goods are returned from the first to the last is just an accident.
But this is if you don’t find through the above questions how
to force the method to return only one required order