Fulltext search does not work with multiselect attribute option values

[superdav42]

Description

Create a custom product attribute with the multiselect input type. Create several options. Make the attribute searchable and shown in advanced search.
Create product with the attribute and select several values.

Preconditions

1. Occurs with Magento 2.2.3 and any 2.2.x

Steps to reproduce

1. From Admin, Go to Stores - Attribute Product. Click Add New Product
2. From Catalog Input Type for Store Owner select Multiple Select
3. Add several Options under Manage Options(Values of Your Attribute)
4. From left ATTRIBUTE INFORMATION select Storefront Properties
5. Select Use in Search - Yes, Visible in Advanced Search - Yes. Save Attribute
   
6. Go to Catalog - Products and Add Product
7. Click Add Attribute and add the previously created attribute
8. Under Attributes select all available options (use ctrl key) and Save the product
9. Open Storefront, click Advanced Search
   
10. Select an Option or several options from Custom Product Attribute and click Search
    

Expected result

1. Searching by label name should be possible in the quick search or advanced search to find the associated product.

Actual result

1. Nothing is found
   

I just opened this issue because my PR to fix it hasn't got any attention yet. #13001

[magento-engcom-team]

@superdav42, thank you for your report.
We've acknowledged the issue and added to our backlog.

[nkajic]

This is documentation problem.

Multiselect attributes needs to have "Visible in Advanced Search" flag checked in addition to "Use in Search" and "Search Weight" mentioned in documentation.

After this do reindex.

Please see implementation on

magento2/app/code/Magento/CatalogSearch/Model/ResourceModel/Engine.php

Line 95 in 18dcf17

&& ($attribute->getIsVisibleInAdvancedSearch()

[ghost]

@nkajic how can I add these options to my attribute that I am creating programmatically? and where is the official documentation on attribute options?

[m2-assistant]

Hi @engcom-Bravo. Thank you for working on this issue.
Looks like this issue is already verified and confirmed. But if you want to validate it one more time, please, go though the following instruction:

• 1. Add/Edit Component: XXXXX label(s) to the ticket, indicating the components it may be related to.

• 2. Verify that the issue is reproducible on 2.4-develop branch

  Details

  - Add the comment @magento give me 2.4-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.4-develop branch, please, add the label Reproduced on 2.4.x.
  - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!

• 3. If the issue is not relevant or is not reproducible any more, feel free to close it.

---

• Join Magento Community Engineering Slack and ask your questions in #github channel.

[magento-engcom-team]

✅ Confirmed by @engcom-Bravo
Thank you for verifying the issue. Based on the provided information internal tickets MC-30223 were created

Issue Available: @engcom-Bravo, You will be automatically unassigned. Contributors/Maintainers can claim this issue to continue. To reclaim and continue work, reassign the ticket to yourself.

[matthew99]

If it is any help this is my experience.
I use Mirasvit Elasticsearch module. In Mirasvit I can add a search index for any attribute (in my case 'writers'), which is a great feature.

My experience:
Only first value of multiselect could be found by advanced search and layered nav.
There is difference between /catalogsearch/results, advanced search and layered nav.

In my case I made an multi select attribute 'writers' (values writer1, writer2, writer3) .
Product 'Book1' has writer1, writer2, writer3 set in the write multiselect attribute.

When I search for 'writ' in the search box, the Miravit search autocomplete neatly lists the 3 writers and the book in seperate blocks. Clicking on any writer leads to advanced search &author=x, which means no results - EXCEPT for the first value (writer1).

If I search for 'writ' and hit enter (/calalogsearch/results/) it lists Book1 and the 3 writers. However, in the layered nav only writer1 is found. Mirasvit overrides this catalog/search but lists all three writers here as well. Clicking same result (-> advanced search only works for first writer).

If I pick advanced search:
Advanced searching on writer 2 or 3 does not list my book.
Advanced searching on writer 1 list my book.

If I click on the category with Book1 in it, in the layered navigation only Writer1 is listed - again, first value.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed after 14 days if no further activity occurs. Is this issue still relevant? If so, what is blocking it? Is there anything you can do to help move it forward? Thank you for your contributions!