Search not being executed as you start typing

[rodrigocoelho]

When start typing on a search field, it works better when having % on the search field. Even having the option "Use 'contains' operator when filtering varchar fields" activated, some fields don't work as contain if not using % manually.

Some Entities, after enabling Full Text Search, only works if you start with %. If not, it doesn't search as you start typing.

[yuri]

Please provide more details, maybe screenshots. l'm really confused and don't understand.

EspoCRM doesn't have a search triggered on typing. Only autocomplete link fields have it.

[rodrigocoelho]

I'm sorry Yuri. Maybe because my bad english. Let's try with screen captures.

Below, an example of me typing scania, and it showing everything but scania. Some times, it shows nothing.



Now it's me typing %scania and it returns what I want.




Here it shows contains enabled all time:

[yuri]

Hi Rodrigo,

I this 5.4 or 5.5 version?

Do you have full-text enabled for Projecto entity type?

[rodrigocoelho]

Hi Rodrigo,

I this 5.4 or 5.5 version?

Do you have full-text enabled for Projecto entity type?

Hi Yuri. version 5.5.3. In some places, it works like expected, in others not. Only works when using "%".

Yes, full-text enabled.

[rodrigocoelho]

Hi Yuri. version 5.5.3. In some places, it works like expected, in others not. Only works when using "%".

Yes, full-text enabled.

5.5.5 and still not working

[rodrigocoelho]

5.5.5 and still not working

Hi, should I post this on Bug Report of GITHUB?

thanks

[yuri]

Hi,

No need.

Do you have the same issue w/o full-text enabled?

[rodrigocoelho]

Hi,

No need.

Do you have the same issue w/o full-text enabled?

Yes, just tried.

And the behavior using "*" is not like when using "%".

[yuri]

Did you run rebuild after disabling full-text?

[rodrigocoelho]

Did you run rebuild after disabling full-text?

Yes....

[rodrigocoelho]

Yes....

If you would like to try yourself, you can enter on the system to try.

[yuri]

I tried but couldn't reproduce. Searching by the word "scania" in parent field gives a proper result.

[yuri]

Seems I reproduced.

[yuri]

I'm not sute if it was ever designed to use 'contains' in an autocomplete lookup. I will look into.