How do I get sale_order_item table data by using injection method?

Question

I am trying to use the itemFactory to get last 30 minutes (updated_at) data from sales_order_item table , but not success. Anyone can hep to verify where I did wrong?

use Magento\Sales\Model\Order\ItemFactory as itemFactoryCollection;



   protected $itemFactory;



  public function __construct(
        itemFactoryCollection $itemFactory
    ) {
        $this->itemFactory = $itemFactory;
    }


public function getOrderItems(): itemFactory
    {
        $orderItemCollectData = $this->itemFactory->create()->getCollection();
    
         $orderItemCollectData->getSelect()
          ->where(
                'updated_at >= ?',
                $orderItemCollectData->getConnection()->getDateSubSql(
                    new Zend_Db_Expr('NOW()'),
                    '30',
                    AdapterInterface::INTERVAL_MINUTE
                )
            );
        return $orderItemCollectData;
    }

$OrderItems = $this->getOrderItems();

Answer 1

I like to use a CollectionFactory to create the collection, then use the pre-baked methods for querying.

Try injecting these :

\Magento\Sales\Model\ResourceModel\Order\Item\CollectionFactory $itemCollectionFactory,
\Magento\Framework\Stdlib\DateTime\DateTime $dateTime

Then use it like this:

// 'Y-m-d H:i:s' is the MySQL timestamp format
$timestamp30MinutesAgo = $this->dateTime->date('Y-m-d H:i:s', strtotime('-30 minutes'));
// ^^ You might want to drop a debugger here 
// to make sure this timestamp is what you want 😅

/** @var \Magento\Sales\Model\ResourceModel\Order\Item\Collection $collection */
$collection = $this->itemCollectionFactory->create();
$collection->addFieldToFilter('created_at', [
    'gteq' => $timestamp30MinutesAgo
]);

$orderItems = $collection->getItems();

Good luck!