Search builder examples

not-working-search-builder-example.php

<?php
require_once __DIR__ . '/../app/bootstrap.php';

use \Magento\Framework\Api\SortOrder;

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();

/** @var \Magento\Framework\App\State $appState */
$appState = $objectManager->get('\Magento\Framework\App\State');
$appState->setAreaCode(\Magento\Framework\App\Area::AREA_FRONTEND);

/** @var Magento\Framework\Api\SearchCriteriaBuilder $searchCriteriaBuilder */
$searchCriteriaBuilder = $objectManager->create('Magento\Framework\Api\SearchCriteriaBuilder');
$searchCriteriaBuilder->addFilter('entity_id', 2000, 'gt');

/** @var \Magento\Framework\Api\SortOrder $sortOrder1 */
/** @var \Magento\Framework\Api\SortOrder $sortOrder2 */
$sortOrder1 = $objectManager->get('\Magento\Framework\Api\SortOrder');
$sortOrder2 = $objectManager->get('\Magento\Framework\Api\SortOrder');

$sortOrder1->setField('name')->setDirection(SortOrder::SORT_ASC);
$sortOrder2->setField('price')->setDirection(SortOrder::SORT_DESC);

$searchCriteriaBuilder->setSortOrders([$sortOrder1, $sortOrder2]);

/** @var \Magento\Catalog\Model\ProductRepository $productRepository */
$productRepository = $objectManager->get('\Magento\Catalog\Model\ProductRepository');

$items = $productRepository->getList($searchCriteriaBuilder->create())->getItems();

echo "<pre>";
foreach ($items as $item){
    var_dump(['name' => $item->getName(), 'price' => $item->getPrice()]);
}

working-search-builder-example.php

<?php
require_once __DIR__ . '/../app/bootstrap.php';

use \Magento\Framework\Api\SortOrder;

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();

/** @var \Magento\Framework\App\State $appState */
$appState = $objectManager->get('\Magento\Framework\App\State');
$appState->setAreaCode(\Magento\Framework\App\Area::AREA_FRONTEND);

/** @var Magento\Framework\Api\SearchCriteriaBuilder $searchCriteriaBuilder */
$searchCriteriaBuilder = $objectManager->create('Magento\Framework\Api\SearchCriteriaBuilder');
$searchCriteriaBuilder->addFilter('entity_id', 2000, 'gt');

/** @var \Magento\Framework\Api\SortOrder $sortOrder1 */
/** @var \Magento\Framework\Api\SortOrder $sortOrder2 */
$sortOrder1 = $objectManager->create('\Magento\Framework\Api\SortOrder');
$sortOrder2 = $objectManager->create('\Magento\Framework\Api\SortOrder');

$sortOrder1->setField('name')->setDirection(SortOrder::SORT_ASC);
$sortOrder2->setField('price')->setDirection(SortOrder::SORT_DESC);

$searchCriteriaBuilder->setSortOrders([$sortOrder1, $sortOrder2]);

/** @var \Magento\Catalog\Model\ProductRepository $productRepository */
$productRepository = $objectManager->get('\Magento\Catalog\Model\ProductRepository');

$items = $productRepository->getList($searchCriteriaBuilder->create())->getItems();

echo "<pre>";
foreach ($items as $item){
    var_dump(['name' => $item->getName(), 'price' => $item->getPrice()]);
}