Help for Aimeos

Hello,

We need to filter data based on text. We have tried with filter[f_search]. But, that is not well. It is searching from all text fields and also it searched for individual character. We need to search full string and in product name only.

So, we have check filter[~=][product.lable]. It is working fine. But, Again we have two language then it is creating issue. So, Can we use this filter ([~=]) into text content only? Right now it is working with product.lable.

example: this is working fine
{endpoints}+"/jsonapi/product?filter[~=][content]=Hitachi washing&include=text"

We need to use same condition for text.content field into included array.

regards
Tejas

You can try but please be aware that the "~=" operator is extremely slow becaus it uses no indexes!

So, from listed operators, which one is fastest?

The "==" or "=~" operator uses indexes and are fast.

ok thanks

Hello, we are using f_search parameter on api request. But that is searching from all text fields. So, we are not getting very precise result on first positions.

While, if we check same thing on demo website on laravel platform, search results are very good.
How can we prepare api which return accurate results?

Currently we are calling this {endpoints-product}?sort=relevance&filter[f_search]=gas%20detector&include=text,media

On this api, Product with name : Gas detector is coming at end. And other products returns first cause those product has gas keyword into description.

Thanks in advance

What happens if your remove "sort=relevance"?

It is returning same result.

The 2020.10 LTS version used in the Laravel demo returns correct order by relevance:
https://laravel.demo.aimeos.org/default ... retty=true

There had been some improvements in 2020.07 and 2020.10 regarding ranking IIRC.