Filter With Multiple Values

Question

In Magento 2.4.1 I have a custom multiple select attribute 'theme' The theme attribute contains options 'football' and 'sport' Some products have both attribute options applied. I can apply both attribute values to a product fine but when I filter in product grid dashboard, it does not find products which have more than one attribute value applied. If a product has one attribute value only then it filters correctly but if a product has multiple attribute filters applied it does not show. Is this a default Magento 2 setting? Thank you.

Answer 1

I did take a look at this question. A multiselect attribute gets stored in a table with varchar suffix. For instance, product attribute activity (present in Magento sample data) is stored in catalog_product_entity_varchar. Also, the value is a list of options ids.

see attached screenshot.

Therefore, your query has to use a like filter, see below an example.

<?php

namespace Mbs\MultiSelectFilter\Command;

use Magento\Catalog\Api\ProductRepositoryInterface;
use Magento\Framework\Api\FilterBuilder;
use Magento\Framework\Api\SearchCriteriaBuilder;
use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;

class GetProductWithSeveralMultiselectOptions extends Command
{
    /**
     * @var ProductRepositoryInterface
     */
    private $productRepository;
    /**
     * @var SearchCriteriaBuilder
     */
    private $searchCriteriaBuilder;
    /**
     * @var FilterBuilder
     */
    private $filterBuilder;

    /**
     * GetProductWithSeveralMultiselectOptions constructor.
     * @param ProductRepositoryInterface $productRepository
     * @param SearchCriteriaBuilder $searchCriteriaBuilder
     * @param FilterBuilder $filterBuilder
     * @param string|null $name
     */
    public function __construct(
        ProductRepositoryInterface $productRepository,
        SearchCriteriaBuilder $searchCriteriaBuilder,
        FilterBuilder $filterBuilder,
        string $name = null
    ) {
        parent::__construct($name);
        $this->productRepository = $productRepository;
        $this->searchCriteriaBuilder = $searchCriteriaBuilder;
        $this->filterBuilder = $filterBuilder;
    }

    protected function configure()
    {
        $this->setName('mbs:find:product');
        $this->setDescription('Find Product in catalog focusing with multiselect attribute');
    }

    protected function execute(InputInterface $input, OutputInterface $output)
    {
        $filter = $this->filterBuilder->setField('activity')
            ->setConditionType('like')
            ->setValue('%5432%')
            ->create();

        $searchCriteria = $this->searchCriteriaBuilder->addFilters([$filter])->create();

        $result = $this->productRepository->getList($searchCriteria);

        foreach ($result->getItems() as $product) {
            $output->writeln(sprintf('sku: %s', $product->getSku()));
        }

        $output->writeln('CFart log import complete');
    }
}