PRODUCT_DONOTSEARCH_ANYWHERE still searches ref

[ohsnaplol]

Bug

Although I have set PRODUCT_DONOTSEARCH_ANYWHERE to 1, (I also tried % based on looking at the code) the ajax combo box still shows results from the ref field, even though it is supposed to only search the label.

According to the documentation:

When Ajax search is enabled, search is done on criteria anywhere in label of product. By adding this option, search is done only on start of label. This is really faster when you have a huge number of products.

I presume this is the intended behavior?

Dolibarr Version

23.0.0

Environment PHP

8.2.30

Environment Database

12.2.2-MariaDB-ubu2404

Steps to reproduce the behavior and expected behavior

Add PRODUCT_DONOTSEARCH_ANYWHERE with value 1 in Other setup. The behavior will be different than without this value set up, but not in the way it is described in the documentation.

Attached files

[bos4711]

In your screenshot, all your labels are starting with the search phrase "8102" and get returned, which is what I would expect.

With the parameter set, this is what i get:

[bos4711]

But I also seem to get a hit for "3636" (which does not start at the beginning anywhere), which maybe confirms it's bug:

[ohsnaplol]

Since it made matches in the ref bold, I thought it was still searching there. That, along with it not being as fast as I think it should be if it really is just searching at the beginning of the label. The search in the example took 6 seconds on 700,000 records on a machine with modest specs with php memory_limit raised to 2G.

[ohsnaplol]

But I also seem to get a hit for "3636" (which does not start at the beginning anywhere), which maybe confirms it's bug:

I think this is working as intended, as the documentation explicitly says "anywhere in label of product". The bold in the ref just threw me off.