[BUG] Filter product

[leandrosantoss]

Describe the bug
Click on product registration and try to filter

I have 3 products

But when filter only accepts the full name. If filtering a snippet doesn't work

Not case insensitive

Thanks

[hussaincoder23]

Can you please describe it again , what is the issue ?

[leandrosantoss]

The problem is in the filter:

• Case sensitive
• Filters only full name

Should be:

• Case insensitive
• Filter by a part of the name (show prints attached)

[treoden]

Hi @leandrosantoss ,

You are using keyword search, it is a full text search in postgres db. Not an ilike query.
You can check more here:

evershop/packages/evershop/src/modules/catalog/services/registerDefaultProductCollectionFilters.js

Line 19 in e86a670

`to_tsvector('simple', product_description.name || ' ' || product_description.description) @@ websearch_to_tsquery('simple', :${bindingKey})`,

Thanks

[leandrosantoss]

Is the idea to continue with the full text?

It makes it a little difficult because rarely does the person know the exact name.

[treoden]

Hi @leandrosantoss

I tried and see it:

1. Is not case sensitive
2. Does not require full name

Can you check again?
Thanks

[leandrosantoss]

Hi, @treoden

It doesn't work in my application (1.1.0). Do I need to do any configuration?

products-google-chrome-2024-06-03-11-50-24_MoZYObZd.mp4

[leandrosantoss]

Hi @treoden, do you understand my problem?

[treoden]

Hi @leandrosantoss

Yes i see. Let me double check again

[leandrosantoss]

Hi @treoden
Were you able to check?

[leandrosantoss]

Hi @treoden news about this?