How to Filter Product Collection by Matching String in Magento 2

catalogsearchmagento2product-collection

We have loaded product collection based on category ID, we are further trying to filter the product collection result with query string.

We have tried :

Query string set and get is working fine with below code.

$query = $this->_queryFactory->create();
$query->setQueryText('Joust');
$query->getQueryText();

Add search filter is not working to my product collection.

use Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection;

$collection->addSearchFilter($query->getQueryText());

Can any one help me on this query.

Best Answer

addSearchFilter does not do much if you don't apply the filter:

public function addSearchFilter($query)
{
    $this->queryText = trim($this->queryText . ' ' . $query);
    return $this;
}

What you need to do is to inject \Magento\Framework\Api\FilterBuilder, \Magento\Framework\Api\Search\SearchCriteriaBuilder as well as \Magento\Search\Api\SearchInterface and do the following:

$this->filterBuilder->setField('search_term');
$this->filterBuilder->setValue('Joust');
$this->searchCriteriaBuilder->addFilter($this->filterBuilder->create());
$searchCriteria = $this->searchCriteriaBuilder->create();
$searchCriteria->setRequestName("search");
$this->searchResult = $this->searchInterface->search($searchCriteria);

Related Solutions

Magento Quick Search Custom Attributes with Conditions

Try creating a new module

In your config.xml

...
<adminhtml>
    <global_search>
        <magepal_custom_attributes>
            <class>MagePal_GlobalAttributesSearch_Model_Search_Customattributes</class>
            <acl>magepal_globalattributessearch</acl>
        </magepal_custom_attributes>
    </global_search>
</adminhtml> 
    ...

in app/code/local/MagePal/GlobalAttributesSearch/Model/Search/Customattributes.php

<?php
class MagePal_GlobalAttributesSearch_Model_Search_Customattributes extends Varien_Object
{
    /**
     * Load search results
     *
     */
    public function load() {
        $arr = array();
        $searchText = $this->getQuery();


        // move code above to your if statement and do your db lookup accordingly 
        $collection = Mage::getModel('module/name')->getCollection()

         if(is_int($searchText)){
           /* search for int in product sku and custom */
            $collection->addFieldToFilter(
                array('field_name'),
                array(
                    array('like'=>'%'.$searchText.'%'), 
                    )
                );
         }
         else{
            /* search product name and description  */
            $collection->addFieldToFilter(
                array('field_name','field_name'),
                array(
                    array('like'=>'%'.$searchText.'%'),
                    array('like'=>'%'.$searchText.'%'), 
                    )
                );
         }

        $collection->load();

        foreach ($collection as $model) {
            $arr[] = array(
                'id'            => 'path/1/'.$model->getId(),
                'type'          => Mage::helper('adminhtml')->__('Custom Attributes'),
                'name'          => $model->getId(),
                'description'   => Mage::helper('core/string')->truncate('desc', 35),
                'url' => Mage::helper('adminhtml')->getUrl('*/path/edit', array('id'=>$model->getId())),
            );
        }

        $this->setResults($arr);
        return $this;
    }
}

See http://blog.mattstephens.co.uk/post/27326981315/adding-custom-module-to-magentos-admin-global-search

You could also rewrite the global product search block.

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;
}

Best Answer

Related Solutions

Magento Quick Search Custom Attributes with Conditions

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

Related Topic