How to get product collections by set of ids in magento 2?

Question

I wanna something like "IN CLAUSE" in MYSQL using by magento2 ORM, something like this:

select * from product where id in (...)

but by using collection in magento 2? for example something like this:

$this->getCollection()->addFieldToFilter('id','in',[...]);

is any one have any idea?

Answer 1

Try below code:

$this->getCollection()->addFieldToFilter('entity_id', array(
                                        'in' => array(3,8,9,207))
                                        );

Answer 2

Yeah you can do the following:

$this->getCollection()->addFieldToFilter('entity_id',['in' => [...]]);

Answer 3

If you want get the collection which keep its ids order that is not ASC or DESC, you could use codes like below:

$ids = '4,5,3,1,2';
$collection = $this->collectionFactory->create()
        ->addFieldToFilter('id', ['in' => $ids])
$collection->getSelect()->order(new \Zend_Db_Expr("FIELD(entity_id,$ids)"));

Answer 4

  <?php
  namespace Mageplaza\HelloWorld\Block;
 class HelloWorld extends \Magento\Framework\View\Element\Template
{    
    protected $_productCollectionFactory;
    public function __construct(
       \Magento\Backend\Block\Template\Context $context,        
       \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory 
        $productCollectionFactory,        
    array $data = []
)
{    
       $this->_productCollectionFactory = $productCollectionFactory;    
        parent::__construct($context, $data);
}

// getproductcollection

public function getProductCollection()
{
 Ids=array(1,2,3);
 $collection = $this->_productCollectionFactory->create();
 $collection->addAttributeToSelect('*')
 $collection->addFieldToFilter('entity_id', ['in' => $Ids]);
 return $collection;
}
}
?>