Magento 2 – How to Get Product Collection by Full Text Search

catalogsearchfulltextmagento2search

How to get product collection by full text search?

        $query = $this->queryFactory->get()->getQueryText();
        $collection = $this->_productCollectionFactory->create();

        $collection->addAttributeToFilter('name', array('like' => '%'.$query.'%'));
        $collection->setPageSize(10); // fetching only 10 products

Any one help in this?

Best Answer

Please check with below url :

https://mage2.pro/t/topic/1121

I hope its work for you.

Related Solutions

Magento 1.7 – How to Add Custom Product to Catalog Search Collection

It might be because it's an empty collection. Without further testing I wouldn't know for sure. But maybe give this a try

public function prepareProductCollection($collection)
{
    $collection
        ->addAttributeToSelect('entity_id')
        ->addSearchFilter(Mage::helper('catalogsearch')->getQuery()->getQueryText())
        ->setStore(Mage::app()->getStore())
        ->addMinimalPrice()
        ->addFinalPrice()
        ->addTaxPercents()
        ->addStoreFilter()
        ->addUrlRewrite();


    $extra_collection = Mage::getResourceModel('catalog/product_collection')
                            ->addFieldToSelect('entity_id')
                            ->addFieldToFilter('entity_id', array(1,2));

    $collection_ids = array_merge($collection->getAllId(), $extra_collection);

    $collection = Mage::getResourceModel('catalog/product_collection')
                            ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
                            ->addFieldToFilter('entity_id', $collection_ids);


    Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection);
    Mage::getSingleton('catalog/product_visibility')->addVisibleInSearchFilterToCollection($collection);

    return $this;
}

Magento2 Admin Grid – How to Enable Full Text Search

To enable fulltext search for custom grid you need to create fulltext index in your grid table. fulltext filter scans indexes list and builds query with fulltext condition only if index exists.

See example, how fulltext filter works, for Merchant Beta, Mainline

Best Answer

Related Solutions

Magento 1.7 – How to Add Custom Product to Catalog Search Collection

Magento2 Admin Grid – How to Enable Full Text Search

Related Topic