跳至內容
選單
此問題已被標幟
1 回覆
3726 瀏覽次數

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.

頭像
捨棄
最佳答案

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
頭像
捨棄

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.

相關帖文 回覆 瀏覽次數 活動
0
1月 25
647
0
3月 24
1265
1
3月 15
6221
1
3月 24
3065
0
8月 17
4591