Get order collection past one hour completed orders magento 2

Question

How to add filter last past one-hour completed orders collection in Magento 2?

  $searchCriteria = $this->searchCriteriaBuilder
        ->addFilter('is_process', $isprocess)
        ->addSortOrder($this->sortBuilder->setField('entity_id')
            ->setAscendingDirection()->create())
        ->setPageSize(3)->setCurrentPage(1)->create();

    $fromDate = date('Y-m-d H:i:s', strtotime('-1 hour'));
    $toDate = date('Y-m-d H:i:s');

    $ordersList = $this->orderRepository->getList($searchCriteria);
    $ordersList->addFieldToFilter('created_at', array('from' => $fromDate, 'to' => $toDate));

    return $ordersList;

Answer 1

here's a shorter version to build the time filter:

// get current time - 1 hour
$time = date(
    "Y-m-d H:i:s",
    (time() - 3600)
);

// then use it as a filter
(...)
->addFieldToFilter(
   'created_at',
   [
      'gteq' => $time
   ]
);

as for the status filtering, it should be something like this:

->addFieldToFilter(
    'status',
    [
        'eq' => 'complete'
    ]
);

Answer 2

Works for me

$searchCriteria = $this->searchCriteriaBuilder
             ->addFilter('is_reward_process', $isrewardprocess)
             ->addSortOrder($this->sortBuilder->setField('entity_id')
             ->setAscendingDirection()->create())
             ->setPageSize(50)->setCurrentPage(1)->create();
    
   $ordersList = $this->orderRepository->getList($searchCriteria);
         
   $ordersList->getSelect()->where(
                    new \Zend_Db_Expr('TIME_TO_SEC(TIMEDIFF(CURRENT_TIMESTAMP, `created_at`)) >= ' . $canceltime * 60 * 60)
                );
    
    return $ordersList;