Filtering Description

How to configure and adapt Aimeos based shops as developer
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
lara.j
Posts: 2
Joined: 24 Nov 2021, 06:13

Filtering Description

Post by lara.j » 25 Nov 2021, 07:04

How I can filter the product base on the description(mshop_text) using jsonapi

Currently here is my filter in url:

https://localhost/jsonapi/product?page[ ... ice&filter[~%3D][product.label]=selection

User avatar
aimeos
Administrator
Posts: 5643
Joined: 01 Jan 1970, 00:00

Re: Filtering Description

Post by aimeos » 25 Nov 2021, 14:00

Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

lara.j
Posts: 2
Joined: 24 Nov 2021, 06:13

Re: Filtering Description

Post by lara.j » 26 Nov 2021, 02:28

I did try use filter[f_search] to check the content in text with type LONG but no luck to retrieve it.


Please see the image below with highlighted HELLO from the result before searching:
Screen Shot 2021-11-26 at 10.23.41 AM.png
Screen Shot 2021-11-26 at 10.23.41 AM.png (125.06 KiB) Viewed 98 times
After using filter[f_search]:
Screen Shot 2021-11-26 at 10.27.56 AM.png
Screen Shot 2021-11-26 at 10.27.56 AM.png (143.36 KiB) Viewed 97 times

Can you help me with this?

User avatar
aimeos
Administrator
Posts: 5643
Joined: 01 Jan 1970, 00:00

Re: Filtering Description

Post by aimeos » 26 Nov 2021, 17:50

Your text is a bad example because it has a language ID of NULL and thus it's not added to the index. We will fix that in the next release. Just assign a language ID to your text for the moment.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

User avatar
aimeos
Administrator
Posts: 5643
Joined: 01 Jan 1970, 00:00

Re: Filtering Description

Post by aimeos » 26 Nov 2021, 18:22

I've seen that texts with language ID NULL are already added to the index.
Is your example text to stored in the mshop_index_text table after you save the product in the backend?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply