Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
3752 Prikazi

I am currently using the eCommerce module to set up a list of products in the website.

Currently in the website's eShop page I can search the products by their name and IDs which I assume are the default fields that the searchbox will check.

The question is, is there a way to add more fields to search by from the eShop page? I added a custom string field for products called 'x_school_name', is there a way to make it so that the website searchbox also checks for this custom field? Where or which view should I edit?

Thank you.

Avatar
Opusti
Best Answer

Hi,

Try this in your controller.

def _get_search_domain(self, search, category, attrib_values, search_in_description=True):
    # For getting the product domain
    domain = super()._get_search_domain(
        search, category, attrib_values,
        search_in_description=search_in_description
    )
    if search:
        domain = expression.OR(
            [domain, [('product_variant_ids.x_school_name','ilike', search)]])

    return domain
Regards
Avatar
Opusti

Inherited the WebsiteSale in my class and tried this code, facing this issue, do you have any idea?

ERROR: column ir_attachment.original_id does not exist
LINE 1: ...d", "ir_attachment"."write_date" as "write_date", "ir_attach.

Related Posts Odgovori Prikazi Aktivnost
0
jan. 25
655
0
mar. 24
1286
1
mar. 15
6230
1
mar. 24
3071
0
avg. 17
4599